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.