Read the following requirements of a database that keeps track of automobile sales in a car dealership.• A car is identified by a unique serial number, and has model, manufacturer and price.• An Option refers to some optional equipment installed on automobile. A car can have more than one option.• Option is identified by option_name and price)• A SalePerson is identified by a unique SalesPersonID, and name and phone.• A SalesPerson sales one or more cars. The database also tracks sale date and sale_price.i. Please create relations (tables) for the database car dealership (define the primary and foreign key constraints)ii. Populate the tables that you have created with the appropriate data.iii. List the model of the cars sold last month.iv. Retrieve the number of cars sold by Johnv. What is the average price of Toyota modelvi. List the option installed for BMWvii. Retrieve the name of Salesperson who sold more cars.viii. List SalesPersons whose phone start in 0918..ix. List the number of cars sold from April 2015 to May 2015x. Retrieve the manufacturer of the car that sets the highest sale_price.xi. Increase the price of the care by 10%.

Found something interesting ?

• On-time delivery guarantee
• PhD-level professional writers
• Free Plagiarism Report

• 100% money-back guarantee
• Absolute Privacy & Confidentiality
• High Quality custom-written papers

Related Model Questions

Feel free to peruse our college and university model questions. If any our our assignment tasks interests you, click to place your order. Every paper is written by our professional essay writers from scratch to avoid plagiarism. We guarantee highest quality of work besides delivering your paper on time.

Sales Offer

Coupon Code: SAVE25 to claim 25% special special discount