We have to design the database for the Oman Air flight booking system. Do the following tasks:. Write the case study for the above - given scenario based on your understanding. [ 1 mark ] 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 ] Convert the ER diagram created in step 2 to relational tables with primary and foreign keys. [ 3 Marks ] Normalize the tables created in steps 2 3 up to the 3 rd normal form. [ 3 Marks ]