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...
-
Refer to this chapters opening feature about Facebook. Assume that Mark Zuckerberg decides to open a new Website devoted to social networking for accountants and those studying accounting. This new...
-
It is unlikely that the company has released information about its efficiency variances. In general, though, what could cause this companys material efficiency variances to be favourable? What could...
-
The comparative balance sheet of Fidelity Medical Supply at December 31, 2008, reported the following: Fidelity's transactions during 2008 included the following: Requirements 1. Prepare the...
-
Stacey Ball, vice president of operations for Clinton County Bank, has instructed the banks computer programmer to use a 365-day year to compute interest on depository accounts (liabilities). Stacey...
-
Courtney has decided that she wishes to travel to Malaysia for 4 months when she finishes university. Courtney has estimated that her trip expenses will be $1500.00 per month of travel, and she will...
-
In the figure above, if Mac and Izzie each initially start at point a and then both completely specialize and trade with each other what are the gains from trade? 24 computers and 24 TV sets per...
-
Johnson Ltd. determined that the net present value of an investment in technological improvements at its plant in France would be 12,000,000 if pending litigation was resolved in the company's...
-
On September 28, 2019, a fire destroyed the entire merchandise inventory of Carroll Corporation. The following information is available: Sales, January 1-September 28, 2019 $570,000 Inventory,...
-
In September, Paul went on holiday & left his bedroom furniture sales business in the care of Agnes. Paul gave a badge with the title "Manager" to Agnes for her to wear at the business. Before...
-
A snowmobile pulls a 10 kg sled across the snow with an acceleration of 3.0 m/s 2 for a distance of 25 m, calculate the amount of work that the snowmobile does on the sled.
-
What is a critical consideration in selecting a Qualified Intermediary for a 1031 Exchange? The speed of transaction processing by the Intermediary. The safety and management of funds held by the...
-
Describe the role of a process control block (PCB) in an operating system and what information it typically contains .
-
Computer Science A painting company wants a program to print the cost of painting based on the size of the room. Writea program that prompt the user to enter the length and width of the room in...
-
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...
-
A simple pendulum is set into oscillation from its rest position by giving it an angular velocity of \(1 \mathrm{rad} / \mathrm{s}\). It is found to oscillate with an amplitude of \(0.5...
-
Derive an expression for the natural frequency of the simple pendulum shown in Fig. 1.10. Determine the period of oscillation of a simple pendulum having a mass \(m=5 \mathrm{~kg}\) and a length...
-
One of the blades of an electric fan is removed. The steel shaft \(A B\), on which the blades are mounted, is equivalent to a uniform shaft of diameter \(25 \mathrm{~mm}\) and length \(150...
Study smarter with the SolutionInn App