Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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-level 2 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 'fix 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. A pet can have many services and services can be performed on many pets. ERD LAB 1/17/2022 Page 1 of 1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing

Authors: David J. Auer David M. Kroenke

13th Edition

B01366W6DS, 978-0133058352

More Books

Students also viewed these Databases questions