Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
QUESTION
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.
