Question

Assume that the primary key of this table consists of two components: Author's ID (AID) and Book number (BNbr). The table includes data regarding authors, books, and publishers. In addition, it tells what an individual author's per book royalty amount is in the case of multi-authored books. Covert the table to a relation if it is not a relation already, Show the functional dependency among all the attributes and covert the relation into the third normal form.

Answer 1

1. this table is relation

2.

Candidate key of the table = (AID, BNbr) Functional Dependencies: - {AID righatrrow, Anth BRoyalty AI name rightarrow AFname, Alnst BNbr rightarrow BName, Bpublish, Bprice Bpublish rightarrow pubcity} This table is not in 2NF. so convert it into 2NF AID rightarrow ALname, AuthBRoyalty BNbr rightarrow BName, Bpublish, B price These two Functional dependencies are partial dependencies. so convert thsu relation into 2NF. 2NF doesn't allow partial dependency. \r\n Convert table into 2NF Find closure property of AID and BNbr AID^+ = {AID, ALname, AuthBRoyalty, AFname, Alnst} BNbr^+ = {BNbr, BName, Bpublish, Bprice, pubcity} Tvale 1: - AID ALname AuthBRoylty AFname Alnst FD of this kable = {AID rightarrow AIname, AuthBRoyality AIname rightarrow AFname, Alnst} This kable is not in 3NF. because {ALname rightarrow AFname, Alnst} doesn't satisfy 3NF condition. Table 2: - BNbr BName Bpublish Bprice pubcity FD = {BNbr rightarrow BName, Bpublish, Bprice spublish rightarrow pubcity} Thus kable is not 3NF. Bpublish rightarrow pubcity is not satisfying 3NF condition

********************END*************PLS GIVE ME GOOD RATING***************************************************