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