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]

Fig: 1