Branch BId BName Supervisor City SID Sid Name Salary DI Operations 1234 1234 Jone Muscat 2340 D2 Engg 1345 1345 Ann Muscat 1200 D3 Operations 1567 1567 | Mary Dubai 1345 D4 Computer 1234 1655 Viba Dubai 1290 DS Operations 1733 1733 Jack Abudhabi 1360 1. Create both the tables Branch and Supervisor with appropriate attribute names, primary key, foreign key and data type. [3 marks] 2. Insert the above records into Branch and Supervisor tables. [2 marks] 3. Display all the records from Branch and Supervisor (Separately) [0.5 mark] 4. Display all the details of Name, City and Salary [1 mark] 5. Display the total salary for every city in the supervisor table. [1 mark] 6. Write a PL/SQL program to display BName from the Branch table for D5. [1.5 marks]