Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please answer it with a screenshot as soon as possible? Create both the tables Buyer and Loan with appropriate attribute names, primary key, foreign key
Please answer it with a screenshot as soon as possible?
- Create both the tables Buyer and Loan with appropriate attribute names, primary key, foreign key and data type. [3 marks]
- Insert the above records into Buyer and Loan tables. [2 marks]
- Display all the records from Buyer and Loan (Separately) [0.5 mark]
- Display all the details of typeofloan and amount for the amount more than 2200. [1 mark]
- Display the number of buyers from every branch [1 mark]
- Write a PL/SQL program to display all details from the table for L13. [1.5 marks]
- Write a PL/SQL program to display the name and branch of buyers who are from Ibri. [2 marks]
- Update city as Suhar for the buyer named Viba. [1 mark]
- 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]
- Include Phone column into the Buyer table.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started