ERD Errors (Solutions) 1.In Student, GPA is a calculated field and shouldn’t be in the table because the parts of it's calculation are also stored (Quality Points , Credit Hours)2.In Course, Registration ID should not appear there. Foreign keys only appear on the many side of a relationship3.In Course, Instructor Name should be broken into its smallest parts (Instructor Fname and Instructor Lname)Additional Questions (Solutions highlighted) 1. According to the ERD, what is the relationship between Student and Course?a. One-to-one (1:1)b. One-to-many (1:M)c. Many-to-many (M:N)d. There is no relationshipe. It cannot be determined from this diagram2. If the Person Number field is an AutoNumber data type in the Student entity, what is its correct data type in the Registration entity?a. AutoNumberb. Numberc. Textd. None of the abovee. It depends3. In the context of this class, in a correctly drawn ERD with four (4) entities and three (3) one-to-many relationships, how many foreignkeys in TOTAL would you expect to be in the entire database? (An example is presented below, although it is NOT the only correctlydrawn ERD that meets these criteria).a. 2b. 3c. 4d. 5e. It
View Full Document
Unlocking...