Question: 1 5 Points: Draw a database diagram ( ERD ) using Vertabelo, Visio, or MySQL Workbench for the Garden Glory database schema described below. Use

15 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, OwnerType)OWNED_PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, State, Zip, OwnerID)GG_SERVICE (ServiceID, ServiceDescription, CostPerHour)EMPLOYEE (EmployeeID, LastName, FirstName, CellPhone, ExperienceLevel) PROPERTY_SERVICE (PropertyServiceID, PropertyID, ServiceID, ServiceDate, EmployeeID, HoursWorked)[This table uses a surrogate key instead of composite key]The referential integrity constraints are:OwnerID in OWNED_PROPERTY must exist as OwnerID in OWNERPropertyID in PROPERTY_SERVICE must exist as PropertyID in OWNED_PROPERTY ServiceID in PROPERTY_SERVICE must exist as ServiceID in GG_SERVICE EmployeeID in PROPERTY_SERVICE must exist as EmployeeID in EMPLOYEE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!