1. Transform the data model to a physical model (database design). Note: a. Draw the entity-relationship diagram (ERD) in Crow's foot notation using MS Visio 2019/2021. Use only the crow's foot database notation (template) in MS Visio (10 pts. penalty is assessed if the wrong template is used). b. There must be no many-to-many relationships (to place FKs appropriately). c. The ERD must include not only tables, foreign keys and relationships with cardinalities but also all columns and their data types (do not use char type only; you need to choose the appropriate data types for each column instead) and also display data types in the Visio file (10 pts. reduction if data types are not included or displayed). See below for instructions on how to enable and modify the display of data types. d. The names must be the same as provided in the data model; clearly label the primary keys and foreign keys. e. All foreign keys are required, i.e., cannot be null. GG_SERVICE PK ServiceID ServiceDescription CostPerHour I OWNER PK OwnerID OwnerName OwnerEmail OwnerType -+----Has EMPLOYEE PROPERTY_SERVICE PK EmployeelD PK PropertyServiceID --Perform--O o Has H LastName FirstName ServiceDate HoursWorked CellPhone ExperienceLevel Attend TRANINING COURSE PK CourseID Date Time Location o---Has---+ Uses OWNED PROPERTY PK PropertyID PropertyName Street City State Zip Has SUB_PROPERTY PK PropertyID PK SubPropertyID SubPropertyType SubPropertyName Description EQUIPMENT PK EquipmentID EquipmentType Manufacturer Model DatePurchased -Require--0 EQUIPMENT REPAIR PK RepairID CostOfRepair DateOfCompletion

Understanding Business
12th Edition
ISBN:9781259929434
Author:William Nickels
Publisher:William Nickels
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
icon
Related questions
Question
1. Transform the data model to a physical model (database design). Note:
a. Draw the entity-relationship diagram (ERD) in Crow's foot notation using MS Visio
2019/2021. Use only the crow's foot database notation (template) in MS Visio (10 pts.
penalty is assessed if the wrong template is used).
b. There must be no many-to-many relationships (to place FKs appropriately).
c. The ERD must include not only tables, foreign keys and relationships with cardinalities
but also all columns and their data types (do not use char type only; you need to
choose the appropriate data types for each column instead) and also display data types
in the Visio file (10 pts. reduction if data types are not included or displayed). See
below for instructions on how to enable and modify the display of data types.
d. The names must be the same as provided in the data model; clearly label the primary
keys and foreign keys.
e. All foreign keys are required, i.e., cannot be null.
Transcribed Image Text:1. Transform the data model to a physical model (database design). Note: a. Draw the entity-relationship diagram (ERD) in Crow's foot notation using MS Visio 2019/2021. Use only the crow's foot database notation (template) in MS Visio (10 pts. penalty is assessed if the wrong template is used). b. There must be no many-to-many relationships (to place FKs appropriately). c. The ERD must include not only tables, foreign keys and relationships with cardinalities but also all columns and their data types (do not use char type only; you need to choose the appropriate data types for each column instead) and also display data types in the Visio file (10 pts. reduction if data types are not included or displayed). See below for instructions on how to enable and modify the display of data types. d. The names must be the same as provided in the data model; clearly label the primary keys and foreign keys. e. All foreign keys are required, i.e., cannot be null.
GG_SERVICE
PK ServiceID
ServiceDescription
CostPerHour
I
OWNER
PK OwnerID
OwnerName
OwnerEmail
OwnerType
-+----Has
EMPLOYEE
PROPERTY_SERVICE
PK EmployeelD
PK PropertyServiceID
--Perform--O
o Has H
LastName
FirstName
ServiceDate
HoursWorked
CellPhone
ExperienceLevel
Attend
TRANINING COURSE
PK CourseID
Date
Time
Location
o---Has---+
Uses
OWNED PROPERTY
PK PropertyID
PropertyName
Street
City
State
Zip
Has
SUB_PROPERTY
PK PropertyID
PK SubPropertyID
SubPropertyType
SubPropertyName
Description
EQUIPMENT
PK EquipmentID
EquipmentType
Manufacturer
Model
DatePurchased
-Require--0
EQUIPMENT REPAIR
PK RepairID
CostOfRepair
DateOfCompletion
Transcribed Image Text:GG_SERVICE PK ServiceID ServiceDescription CostPerHour I OWNER PK OwnerID OwnerName OwnerEmail OwnerType -+----Has EMPLOYEE PROPERTY_SERVICE PK EmployeelD PK PropertyServiceID --Perform--O o Has H LastName FirstName ServiceDate HoursWorked CellPhone ExperienceLevel Attend TRANINING COURSE PK CourseID Date Time Location o---Has---+ Uses OWNED PROPERTY PK PropertyID PropertyName Street City State Zip Has SUB_PROPERTY PK PropertyID PK SubPropertyID SubPropertyType SubPropertyName Description EQUIPMENT PK EquipmentID EquipmentType Manufacturer Model DatePurchased -Require--0 EQUIPMENT REPAIR PK RepairID CostOfRepair DateOfCompletion
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Understanding Business
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Management Information Systems: Managing The Digi…
Management Information Systems: Managing The Digi…
Management
ISBN:
9780135191798
Author:
Kenneth C. Laudon, Jane P. Laudon
Publisher:
PEARSON
Business Essentials (12th Edition) (What's New in…
Business Essentials (12th Edition) (What's New in…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
Fundamentals of Management (10th Edition)
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON