Attached is a data model design for the Garden glory questions. • 2. Use this data model to complete the following tasks: -. 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, you can only use the crow's foot database notation (template) in MS Visio. 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; choose the appropriate data types for each column instead) and also display data types in the Visio file. 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
Attached is a data model design for the Garden glory questions. • 2. Use this data model to complete the following tasks: -. 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, you can only use the crow's foot database notation (template) in MS Visio. 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; choose the appropriate data types for each column instead) and also display data types in the Visio file. 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
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
Related questions
Question
Transcribed Image Text:Attached is a data model design for the Garden glory questions.
• 2. Use this data model to complete the following tasks:
-. 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, you can
only use the crow's foot database notation (template) in MS Visio.
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; choose the appropriate
data types for each column instead) and also display data types
in the Visio file.
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: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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
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…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON