Question: 1 5 Points: Draw a database diagram ( ERD ) using Vertabelo, Visio, or MySQL Workbench for the Garden Glory database schema described below. Use
Points: Draw a database diagram ERD using Vertabelo, Visio, or MySQL Workbench for the Garden Glory database schema described below. Use Crows feet notation.OWNER OwnerID OwnerName, OwnerEmail, OwnerTypeOWNEDPROPERTY PropertyID PropertyName, PropertyType, Street, City, State, Zip, OwnerIDGGSERVICE ServiceID ServiceDescription, CostPerHourEMPLOYEE EmployeeID LastName, FirstName, CellPhone, ExperienceLevel PROPERTYSERVICE PropertyServiceID PropertyID, ServiceID, ServiceDate, EmployeeID, HoursWorkedThis table uses a surrogate key instead of composite keyThe referential integrity constraints are:OwnerID in OWNEDPROPERTY must exist as OwnerID in OWNERPropertyID in PROPERTYSERVICE must exist as PropertyID in OWNEDPROPERTY ServiceID in PROPERTYSERVICE must exist as ServiceID in GGSERVICE EmployeeID in PROPERTYSERVICE must exist as EmployeeID in EMPLOYEE
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
