Question: 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
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-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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
