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. This question are related to ITM211 course!
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
