Question: create the ERD MUST USE VISIO . ( NOTE : ERDs must use the Crows Foot.) Once complete, please submit 1 Visio file with your

create the ERD MUST USE VISIO. (NOTE: ERDs must use the Crows Foot.) Once complete, please submit 1 Visio file with your completed diagram in Canvas. The file should have 4 pages one for each diagram. Please draw 4 different diagrams for the problem below: 1. High level relationship (entity names only with relationships including M:N) 2. Mid-level 1 relationship (assign primary keys) 3. Mid-level 2 relationship (convert M:N relationships to 1:M relationships) 4. Low level relationship (add assumed attributes make sure to mark keys as well) Problem 1: Please use the below rules to complete the ERD. A state can have zero to many sales offices, but a sales office can be in only one state. A sales office has one or more employees, but an employee can work at only one sales office. A sales office has one employee who is a manager, however, a particular employee can only manage one sales office. A sales office may list zero or more properties for sale, and a property for sale may be listed by only one sales office. A property for sale may have one or more owners, and an owner may own one or more properties.

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 Databases Questions!