Assignment for chapter $6$

From your book, Database System Edition $13.$

Go to page $233$ and $234$ and provide an answer for Review Questions $6,7,8.$

Your answer must be in a Microsoft Word file $($other file types will not be graded, or rejected$).$

Given the dependency diagram shown in Figure Q$6\mathrm{.}6,$ answer Items $6$a$-6$c$.$

FIGURE Q$6\mathrm{.}6$ DEPENDENCY DIAGRAM FOR QUESTION $6$

a$.$ Identify and discuss each of the indicated dependencies.

b$.$ Create a database whose tables are at least in $2$ NF $,$ showing the dependency dia$-$

grams for each table.

c$.$ Create a database whose tables are at least in $3$ NF $,$ showing the dependenc diagrams for each table.

$7.$ The dependency diagram in Figure Q$6\mathrm{.}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

$2$NF$,$ showing the dependency diagram for each table.

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

for each table.

$8.$ The dependency diagram in Figure Q$6\mathrm{.}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 $2$NF$,$ showing the dependency

diagram for each table.