Please answer it with a screenshot as soon as possible?

1. Create both the tables Buyer and Loan with appropriate attribute names, primary key, foreign key and data type. [3 marks]
2. Insert the above records into Buyer and Loan tables. [2 marks]
3. Display all the records from Buyer and Loan (Separately) [0.5 mark]
4. Display all the details of typeofloan and amount for the amount more than 2200. [1 mark]
5. Display the number of buyers from every branch [1 mark]
6. Write a PL/SQL program to display all details from the table for L13. [1.5 marks]
7. Write a PL/SQL program to display the name and branch of buyers who are from Ibri. [2 marks]
8. Update city as Suhar for the buyer named Viba. [1 mark]
9. Write a Procedure to receive a Loan Id as Input and display all the related values of that Loan. (Also write the calling program.) [2 marks]

10. Include Phone column into the Buyer table.

Buyer BID Name Branch Loan TypeofLoan Amount LID BID 123 Jane Ibri LII Car 2000 123 124 Ann Sohar L12 Personal 1500 124 125 Mary Ibri L13 Car 5000 124 126 1Viba Nizwa L14 Home 3200 127 127 Sam Sohar L15 Study 4700 123