1. Create both the tables Branch and Supervisor with appropriate attribute names, primary key, foreign key and data type.
2. Insert the above records into Branch and Supervisor tables.
3. Display all the records from Branch and Supervisor (Separately)
4. Display all the details of Name, City and Salary.
5. Display the total salary for every city in the supervisor table.
6. Write a PL/SQL program to display BName from the Branch table for D5.
7. Write a PL/SQL program to display all the details of Supervisor who is getting more than 1250 salary using cursor.
8. Update city as Suhar for Supervisor named Jack.
9. Write a Procedure to receive a Supervisor SId as Input and display all the related values of that Supervisor. (Also write the calling program.)

10. Delete all the branch details of operations.

Branch BId BName SID Sid Supervisor City Salary Name 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 5 Operations 1733 1733 Jack Abudhabi 1360