Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Find THREE errors in the accompanying ERD and explain why they are errors . Your answers should be in complete sentences. 2. According to
1. Find THREE errors in the accompanying ERD and explain why they are errors. Your answers should be in complete sentences.
2. 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 relationship e) It cannot be determined from this diagram
3. 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) AutoNumber b) Number c) Text d) None of the above e) It depends
4.
*Note: Assume ALL relationships have been identified and drawn correctly. *Note: Assume each record in the Course entity refers to a single course. For example, there is only one record for MGS351. In the context of this class, in a correctly drawn ERD with four (4) entities and three (3) one-to-many relationships, how many foreign keys in TOTAL would you expect to be in the entire database? An example is presented below, although it is NOT the only correctly drawn ERD that meets these criteria. 2 3 4 5 It dependsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started