During normalisation, you must: NOT add surrogate keys to the normalisation.

According to the Appendix below, please develop Unnormalised form (UNF), and perform normalisation to the 3NF.

During normalisation, you must:

1. NOT add surrogate keys to the normalisation.

2. clearly identify the Primary Key in all relations.

3. Clearly identify the partial and transitive dependencies (if exist) in all 1 NF relations.

4. Please also add: author ID and publisher ID to the BOOK entity.

"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!":

Get started