Read the following requirements of a database that keeps track of automobile sales in a car dealership

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%.

find the cost of your paper

determine and argue whether OpenTable was a sound acquisition for Priceline using the concepts from this and other courses

OpenTable was the first mover in the world of booking orders for restaurants around the globehttps://www.vox.com/2018/10/19/17698428/resy-restaurant-reservations-startup-opentable. After obtaining notoriety, they issued a massive IPOhttps://www.reuters.com/article/us-opentable-idUSTRE5464CJ20090507 andhttps://press.opentable.com/news-releases/news-release-details/opentable-inc-prices-initial-public-offering/ resulting in a stock price….

Internal and External Stakeholder Analysis

MGT501_Assessment_2_Brief_Internal and External Stakeholder Analysis_Module Due 5.2 Page 1 of 6 Assessment Task Critically analyse stakeholder theory in a real-life business or a project setting, with specific emphasis on relevant….

SUPPLY CHAIN MANAGEMENT

YOU ONLY HAVE TO DO SUPPLY CHAIN MANAGEMENT PARTABOUT 1 – 1.5 PAGES OR MORE WALMART READ ALL THE INFORMATION FIRST. YOU HAVE TO DO SUPPLY CHAIN MANAGEMENT PART ONLY….