Question: 1 5 Points: Extend and modify the database diagram using Vertabelo, Visio, or MySQL Workbench to meet Garden Glorys new requirements above. Start by writing
Points: Extend and modify the database diagram using Vertabelo, Visio, or MySQL Workbench to meet Garden Glorys new requirements above. Start by writing out the entities as they are described with the columnsattributes needed in each entity. Use Crows feet notation. Create appropriate identifiers primary keys and attributes columns for each entity. Here are the relationship rules that need to be shown in the database diagram to meet the new requirements: One owned property can be comprised of one or more subproperties. One subproperty can be involved in zero or more property services. One property service can involve zero or many pieces of equipment. One piece of equipment can be used for zero or many property services. One piece of equipment can be the basis of zero or many training courses. One employee can attend zero or many training courses. One training course can be attended by zero or many employees. One piece of equipment can have zero or many repairs.Use Vertabelo, Visio, or MySQL Workbench to create separate database diagrams for Part A and Part B Export your database diagrams as png files or take a screenshot of the diagrams. Attach and submit the complete images under the link for Project # You should attach a separate image file for each Part A and Part B Note: any image format is fine, PNGs are autogenerated
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
