Question: Can anyone answer the second question using visio only pls ERD LAB 1 Using the business rules below, create the ERD (on Visio). (NOTE: ERDs

Can anyone answer the second question using visio only pls

Can anyone answer the second question using visio
ERD LAB 1 Using the business rules below, create the ERD (on Visio). (NOTE: ERDs must use the Crow's Foot.) Once complete, please submit a picture of your completed diagram in Canvas (one picture for each problem (all 4 diagrams for 1 problem in 1 picture so 2 pictures total). Please draw 4 different diagrams for each problem below: 1. High level relationship (entity names only with relationships including M:N) 2. Mid-level 1 relationship (assign primary keys) 3. Mid-leve12 relationship (convert M:N relationships to 1:M relationships and 1:1 relationships can add foreign keys here or in next step) 4. Low level relationship (add foreign keys, add 'assumed' attributes make sure to mark keys as well) Please include your rules as part of the diagram and make sure you 'x' the rules to make them clearer. Problem 1: The University of Colorado Denver needs a database to keep track of student activities. Data needs to be kept on each activity (activity name, type, etc.), and each student (student name, contact information, etc.). ' A student can engage in one or more activities and an activity can involve one or more students. Problem 2: A newly established pet rescue organization needs a database to keep track of pets and their owners. Data needs to be kept on the new owners (names, contact info, etc.), pets (names, breed, etc.), and services (service type, cost, etc.) ' An owner can have many pets, and a pet can have multiple owners. 0 A pet can have many services and services can be performed on many pets. ERD LAB 1/17/2022 Page 1 ofl

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 General Management Questions!