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?

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?

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

Step: 3

blur-text-image

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

Beyond Big Data Using Social MDM To Drive Deep Customer Insight

Authors: Martin Oberhofer, Eberhard Hechler

1st Edition

0133509796, 9780133509793

More Books

Students also viewed these Databases questions

Question

Why can the P/E ratio be viewed as a type of payback period?

Answered: 1 week ago

Question

What are the three basic categories of reports? [LO-1]

Answered: 1 week ago