In LAU the ERD diagram representing the Professor entity " teaching " student entity is many to many. Attributes for the " professor entity " are : Prof.ID , Prof.Name , Prof.Address and Prof.DOB, Course time and course location. The attributes for the student entity are: Student ID , Student Name , Student Address , Student Major , Exam1_Grade , Exam2_Grade , course schedule , course location and total_grade. Business Rule 1: Many Professor may teach none , one or Many students a) Draw the ERD Diagram as described above. b) After starting the three rules of normalization , what are consideration you may want to follow to maintain a proper design of the database ? Show the new design by re-drawing the proper design according to the normalization rules.
In LAU the ERD diagram representing the Professor entity " teaching " student entity is many to many. Attributes for the " professor entity " are : Prof.ID , Prof.Name , Prof.Address and Prof.DOB, Course time and course location. The attributes for the student entity are:
Student ID , Student Name , Student Address , Student Major , Exam1_Grade , Exam2_Grade , course schedule , course location and total_grade.
Business Rule 1: Many Professor may teach none , one or Many students
a) Draw the ERD Diagram as described above.
b) After starting the three rules of normalization , what are consideration you may want to follow to maintain a proper design of the
This question are related to ITM211 course!
Step by step
Solved in 2 steps with 2 images
