Normalize and ERD For each relation, you need to: Normalize the relation based on the functional dependencies

Normalize and ERD

Transcribed Image Text:

For each relation, you need to: Normalize the relation based on the functional dependencies [FD] given; o Q1. ROYALTY relation FIGURE Q6.7 BOOK ROYALTY DEPENDENCY DIAGRAM 1NF: Please normalize them step by step, i.e. first write the relational schema in 1NF, then in 2NF, and finally in 3NF. o Please draw the ERD for normalized relations. 2NF: Please provide your answers in the table below: # 3NF: ISBN Book Title Author Num LastName Publisher Royalty Edition Note: you need to write the database relational schema for each of the normalized tables!! That means, you will need table name and PK for each table! Please do NOT improve the design here. Some students are distracted by the column names listed in the diagram. If that is the case for you think of them as C1, C2, C3 ... For each relation, you need to: Normalize the relation based on the functional dependencies [FD] given; o Q1. ROYALTY relation FIGURE Q6.7 BOOK ROYALTY DEPENDENCY DIAGRAM 1NF: Please normalize them step by step, i.e. first write the relational schema in 1NF, then in 2NF, and finally in 3NF. o Please draw the ERD for normalized relations. 2NF: Please provide your answers in the table below: # 3NF: ISBN Book Title Author Num LastName Publisher Royalty Edition Note: you need to write the database relational schema for each of the normalized tables!! That means, you will need table name and PK for each table! Please do NOT improve the design here. Some students are distracted by the column names listed in the diagram. If that is the case for you think of them as C1, C2, C3 ...