1. Apply MySQL Workbench to create the following car dealer data model. A person has many...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Apply MySQL Workbench to create the following car dealer data model. A person has many cars. The person has an identification, lastname and firstname. The car has an identification, car cost, car sell, and car type. (25 points) PERSON "personid persfname persiname CAR "carid carcost carsell cartype Save as BMIS320L_Your Name_Model_A1.mwb 2. Write the create table statements for the car dealer data model. (25 points) Save as BMIS320L_Your Name Tables_A1.sql 3. Answer the following queries based on the database for a car dealer. a. What was the maximum selling price of any car? (10 points) b. Report the number of cars sold of each type. (10 points) c. List details of all sales showing the gross profit (i.e. selling price minus cost price). (10 points) d. What is the average selling price of cars sold by Sue Lim? (10 points) e. Report the gross profit made by each salesperson who sold at least three cars. (10 points) 1. Apply MySQL Workbench to create the following car dealer data model. A person has many cars. The person has an identification, lastname and firstname. The car has an identification, car cost, car sell, and car type. (25 points) PERSON "personid persfname persiname CAR "carid carcost carsell cartype Save as BMIS320L_Your Name_Model_A1.mwb 2. Write the create table statements for the car dealer data model. (25 points) Save as BMIS320L_Your Name Tables_A1.sql 3. Answer the following queries based on the database for a car dealer. a. What was the maximum selling price of any car? (10 points) b. Report the number of cars sold of each type. (10 points) c. List details of all sales showing the gross profit (i.e. selling price minus cost price). (10 points) d. What is the average selling price of cars sold by Sue Lim? (10 points) e. Report the gross profit made by each salesperson who sold at least three cars. (10 points)
Expert Answer:
Answer rating: 100% (QA)
To create the car dealer data model in MySQL Workbench you can follow these steps Step 1 Open MySQL Workbench and connect to your database server Step ... View the full answer
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these programming questions
-
To create the following data we started with the same sample means and variances that appeared in problem 10 but increased the sample size to n = 25. a. Predict how the increase in sample size should...
-
Use the data in Table 16-3 to create the following graphs: a. Sales b. Sales and Gross Margin c. Earnings per share d. Which principles of graph design, if any, did you have to manually implement to...
-
3. Propose a synthetic scheme to create the following product. Clearly denote each intermediate and the conditions that are used to generate them. (25 points total) a. (5 points) OH CH, CH3 H,0 CH,...
-
Class Median Midpoint, x Income, I 19.5 $12,965 An individual's income varies with age. The table shows the median income I of individuals of different age groups within the United States for a...
-
During peak periods, Temporary Employment Corporation (TEC) places temporary workers in companies. TECs manager gives you the following description of the business: TEC has a file of candidates who...
-
Wayne-Martin Electric Inc. (WME) has just developed a solar panel capable of generating 200 percent more electricity than any solar panel currently on the market. As a result, WME is expected to...
-
Larry Riley formed a rental agreement for a self-storage unit with Iron Gate Self Storage in December 2003. The agreement stated that a maximum of \($5,000\) of personal property could be stored in...
-
C.S. Lewis Company had the following transactions involving notes payable. July 1, 2014 Borrows $50,000 from First National Bank by signing a 9-month, 8% note. Nov. 1, 2014 Borrows $60,000 from Lyon...
-
On a winter day, a psychrometer has a dry-bulb reading of 35F and a wet-bulb reading of 31F. (Use the data in this table as necessary.) (a) What is the actual moisture content of the air? (Enter your...
-
A Y-connected load, with Z A = 10 0 , Z B = 10 60, and Z C = 10 60 , is connected to a three-phase, three-wire, ABC system having effective line voltage 141.4 V. Find the load voltages V AO , V BO...
-
Based on Mr. Martins prediction for 1996 sales of $28,206,000, and for 1997 sales of $33,847,000 and relying on the other assumptions provided in the Tire City case, prepare complete pro forma...
-
Changala Primary School (CPS) Parents and Teachers Association (PTA) intend to introduce a Local Area Network (LAN) at the school to improve communication and learning among key stakeholders. The PTA...
-
Read the PEW Research article on Police Officer Opinions found in this Lesson. Summarize the findings of the article and highlight at least two things that stood out to you and explain why.
-
Edward made a contribution of $5,000 to his RRSP account this year. He has a marginal tax rate of 41% and an average tax rate of 26%. What dollar amount of tax savings / refund should he expect from...
-
Personal Reflexion 4 ethics on privacy essay Researching and Decision Making over Auditors' Responsibilities 1) Research an auditor's responsibilities for detecting, investigating and reporting on a...
-
When you get the report from billing, you panic; you have billed only 300 hours. You are 75 hours behind where you should be (1500 divided by four [i.e., one-fourth of the way through the year]...
-
You have the following information for Alpha plc: Equity: 500,000 shares. The company just paid a dividend of 2 and the dividends are expected to grow by 3% per year indefinitely. The current share...
-
What are current assets and current liabilities? How are they different from non-current assets and non-current liabilities?
-
What is recovery?
-
What is an OODBMS?
-
In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21 through 1-25 in Chapter 1. (If you use a computer to complete these exercises, use a...
-
What are presumptions, and why are they important?
-
What is the burden of proof in a criminal trial? How does it compare to the burden of proof in a civil trial?
-
Distinguish between adversarial and inquisitorial justice.
Study smarter with the SolutionInn App