We have to design the database for the UTAS CIMS

Question
We have to design the database for the UTAS CIMS system for advising and registration of courses. Do the following tasks:. 1. Write the case study for the above-given scenario based on your understanding. [1 mark] 2. Create an ER diagram with at least 3 entities, different types of attributes, and 3 relationships based on the case study you have created in step 1. [3 Marks] 3. Convert the ER diagram created in step 2 to relational tables with primary and foreign keys. [3 Marks] 4. Normalize the tables created in steps 2-3 upto 3 normal form. [3 Marks]
Question image 1