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
Get step-by-step solutions from verified subject matter experts
