Database 5

7. The dependency diagram in Figure Q6.7 indicates that authors are paid royalties for each book they write for a publisher. The amount of the royalty can vary by author, by book, and by edition of the book.

a. Based on the dependency diagram, create a database whose tables are at least in 2NF, showing the dependency diagram for each table.

b. Create a database whose tables are at least in 3NF, showing the dependency diagram for each table.

8.The dependency diagram in Figure Q6.8 indicates that a patient can receive many prescriptions for one or more medicines over time. Based on the dependency diagram, create a database whose tables are in at least 2NF, showing the dependency diagram for each table.

What is a partial dependency? With what normal form is it associated?

9. Create a plan detailing steps that should be taken to defend against SQL injection exploitation within Web applications