Question: Please answer both sheets. Thank you!! Instructions: 1. Draw an ERD diagrams using the Chen method for each of the following exercises. 2. Identify both
Instructions: 1. Draw an ERD diagrams using the Chen method for each of the following exercises. 2. Identify both the primary key(s) and the foreign key(s) in each entity. Exercise #1: College Classes Business Rules: 1. A professor teaches zero, one or many classes and a class is taught by one professor 2. A course may generate zero, one or many classes and a class comes from one course 3. A class is held in one room but a room has many classes 4. A student can enroll in one or more classes Hint: One possible solution could contain 6 entities
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
