Please put your response under each question.

$$

Drawing a dependency diagram or ER model.

$$

$$

The dependency diagram in Figure below 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.

$$

$$

$$

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.

$$

$$

$$

$$

$$

$$

$$

$$

$$

$$

To keep track of office furniture, computers, printers, and so on$,$ the FOUNDIT company uses the table structure shown in the table below. $3$ points

$$