Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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. image text in transcribed

*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 depends

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Big Data Concepts, Theories, And Applications

Authors: Shui Yu, Song Guo

1st Edition

3319277634, 9783319277639

More Books

Students also viewed these Databases questions

Question

What is the purpose of the Salary Structure Table?

Answered: 1 week ago

Question

What is the scope and use of a Job Family Table?

Answered: 1 week ago