Computer Science Homework Help

Luan’s Boutique has multiple departments. A manager is responsible for various departments and has to ensure that the departments run smoothly. Luan noticed that there were numerous attempts by the customers to file complaints on certain departments. He decided that there needs to be a system put in place to help the clients to file complaints on various departments.

Do the following for the above scenario:

1. Normalize the ER Diagram from 0NF to 3NF (3 marks per NF = 12 marks)
2. Draw a 3rd NF ER Diagram (10 marks)
3. Do the mapping (8 marks)