1. This dependency diagram reflects a table that is in
a. 1NF
b. 2NF
c. 3NF
d. Can't Be Determined
2. This dependency diagram reflects a table that is in
a. 1NF
b. 2NF
c. 3NF
d. Can't Be Determined
3. This dependency diagram reflects a table that is in
a. 1NF
b. 2NF
c. 3NF
d. Can't Be Determined
4. This dependency diagram reflects a table that is in
a. 1NF
b. 2NF
c. 3NF
d. Can't Be Determined
5. This dependency diagram reflects a table that is in
a. 1NF
b. 2NF
c. 3NF
d. Can't Be Determined
Questions 6 - 9
The dependency diagram indicates that authors are paid royalties for each book that they write for a publisher. The amount of the royalty can vary by author, by book, and by edition of the book.
Book royalty dependency diagram
6. This dependency diagram reflects a table that is in
a. 1NF
b. 2NF
c. 3NF
d. No Normal Form
7. What are the Partial Dependencies (more than one may apply)?
a. ISBN -> BookTitle
b. ISBN -> Author_Num
c. ISBN -> LastName
d. ISBN - > Publisher
e. ISBN -> Royalty
f. ISBN -> Edition
g. BookTitle -> Author_Num
h. BookTitle -> LastName
i. BookTitle -> Publisher
j. BookTitle -> Royalty
k. BookTitle -> Edition
l. Author_Num -> LastName
m. Author_Num -> Publisher
n. Author_Num -> Royalty
o. Author_Num -> Edition
8. What are the Transitive Dependencies (more than one may apply)?
a. ISBN -> BookTitle
b. ISBN -> Author_Num
c. ISBN -> LastName
d. ISBN - > Publisher
e. ISBN -> Royalty
f. ISBN -> Edition
g. BookTitle -> Author_Num
h. BookTitle -> LastName
i. BookTitle - > Publisher
j. BookTitle -> Royalty
k. BookTitle -> Edition
l. Author_Num -> LastName
m. Author_Num -> Publisher
n. Author_Num -> Royalty
o. Author_Num -> Edition
9. How many tables would be required to make this complete ERD 3NF?
a. 2 Tables
b. 3 Tables
c. 4 Tables
d. 5 Tables
Questions 10 - 12
For the two tables in the ERD below, view the dependency diagrams below the ERD.
Business Rule: A doctor can schedule many appointments, but an appointment is scheduled by one and only one doctor. The "APPOINTMENT" table includes the App_Num, as well as the doctors Emp_ID, the appointment time, date, Patient_ID, and patient information.
Note that in the "APPOINTMENT" table, the attribute "App_PatientID" is a patients ID number, and can be used to uniquely identify all other patient attributes, including App_Name to App_Zip.
10. The "Doctor" dependency diagram reflects a table that is in
a. 1NF
b. 2NF
c. 3NF
d. Can't Be Determined
11. The "Appointment" dependency diagram reflects a table that is in
a. 1NF
b. 2NF
c. 3NF
d. Can't Be Determined
12. How many tables would be required to make this complete ERD 3NF?
a. 2 Tables
b. 3 Tables
c. 4 Tables
d. 5 Tables
Attachment:- Chapter 6 Exercise 1 (1) (1).pdf