DOC PREVIEW
UB MGE 302 - Practice ERD Quiz

This preview shows page 1 out of 2 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 2 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 2 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

1. Find three errors in the accompanying ERD and explain why they are errors. Your answers should be in complete sentences.Additional Questions: 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 relationshipe. It cannot be determined from this diagram3. 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 depends4. 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 dependsCourse • Course ID (e.g. 085122)• Registration ID• Department (e.g. MGS)• Level (e.g. 351)•Instructor Name• Course DescriptionStudent • Person Number• First Name• Last Name• Major• Minor• Quality Points• Credit Hours• GPA• Birth Date• GenderRegistration • Registration ID• Person Number• Course ID• Building• Room• Grade (e.g. A-)*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 onlyone record for


View Full Document

UB MGE 302 - Practice ERD Quiz

Download Practice ERD Quiz
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Practice ERD Quiz and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Practice ERD Quiz 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?