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

Please answer both sheets. Thank you!!  Please answer both sheets. Thank you!! Instructions: 1. Draw an ERD
diagrams using the Chen method for each of the following exercises. 2.

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

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 Databases Questions!