Question: Please write in MySQL or according to MySQL. (because some other packages like Oracle commands for SQL are different from MySQL. I want MySQL.) You

Please write in MySQL or according to MySQL. (because some other packages like Oracle commands for SQL are different from MySQL. I want MySQL.)

You have to create the table, Populate with data and run the queries for getting output. Sufficient data need to be entered.

Please create a database with a size which will yield a good result(maybe 10 records, as given in the question), and provide it here.

Please write in MySQL or according to MySQL. (because some other packages

Will upvote if your solution is correct.

Thanks.

1. Consider the following database: CUSTOMER ( Cust_ID, Name, Age, Cust_type) BANKS (Bank_ID, B_name, B_city) BORROWS (B_ID, Cust_ID, Bank_ID, Amount, Borrow_date, Duration, Type) Note: Customer type must be Regular, Corporate, or Priority. Borrows type must be Home, Car, or Personal. Create tables for the above relations through SQL commands clearly specifying the integrity constraints. Specify the following queries in SQL. (Insert at least 10 records in each table so that the queries yield some results) a. List the details of the customers who have borrowed more than rupees 10 lakhs from the Central Bank in Kolkata. b. List the names and ages of customers who have borrowed from the Indian Bank on 12/03/18 for a duration of 15 years or more. List the names of all corporate customers who have not taken any car loan. d. List the details of the customer who has the third-highest borrowed amount. e. List the total loan amount (for all customers) for the different banks located in Kolkata. f. List the loan details of the youngest customer. List the names of all customers who are in their 60s. c

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!