Question: 2. (30 point) Consider the following relations for a database thatkepa track of sales in a car dealership: CAR(Serial no., Manufacturer, Price) CAR. SPAREPARTS(Serial no.,

2. (30 point) Consider the following relations for a database thatkepa track of sales in a car dealership: CAR(Serial no., Manufacturer, Price) CAR. SPAREPARTS(Serial no., Spareparts name, Price) SALE(Sal SALESPERSON Salesperson id., Name, Phone) id., Serial no., Date, Sale price a. (10 pts) Specify the foreign keys for this schema, stating any assumptions you make. b. (8 pts) Populate each relations with two sample tuples. c. (12 pts) Give an example of an insertion in the SALE and SALESPERSON relations that violates the referential integrity constraints and of another insertion that does not

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!

Show intermediate steps to get your final answers, if applied. Problem 2. (Data Integrity) (20 Points) Consider the following relations for a database that keeps track of automo- bile sales in a car...

Consider the following relations for a database that keeps track of automobile sales in a car dealership: CAR(Serial_No, Model, Manufacturer, Price) OPTION(Serial_No, Option name, Price)...

Consider the following relations for a database that keeps track of automobile sales in a car dealership ( OPTION refers to some optional equipment installed on an automobile ) : CAR ( Serial _ no ,...

Consider the following relations for a database that keeps track of automobile sales in a car dealership (OPTION refers to some optional equipment installed on an automobile): CAR (Serial_no, Model,...

these pictures are the figures that are mentioned in the passage Specialty Imports Specialty Imports is an automobile dealership located on the "auto strip" in North-West Brampton (where several...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

Problem 2 Specify the following queries in relational algebra on the database schema below: Consider the relations for a database that keeps track of automobile sales in a car dealership (OPTION...

BMGT 380 - Final Exam Questions for E-resources - Fall 2014 Multiple Choice: 1 point each 1. Sam orally agreed to sell Jamie some land for $500,000. Jamie paid Sam the $500,000; Sam gave Jamie the...

View the 2013 Annual Report for the Ford Motor Company, a Fortune 50 company, linked here as well as on the Course Information page. Using this report, answer the following questions: Does the...

Questions are as follows. Case is attached below Detailed steps you will take to achieve your discount, normal, or luxury strategy (examples are as follows) ? Business Model: How will you generate...

The following data relate to labor cost for production of 20,000 cellular telephones: Actual: 8,450 hrs. at $22.50 Standard: 8,400 hrs. at $23.00 a. Determine the direct labor rate variance, direct...

Respond that the following statements are TRUE or FALSE: 1) The first step in developing an activity-based costing system is to identify the activities that will be used to assign the manufacturing...

ANSWER The final preparations for cell division occur In the phase of Interphase. Fill in the blank |

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Did the person take the initiative to understand the issue and gather needed information?

Was the person thoughtful about the alternatives, and did he or she make a reasonable and appropriate choice given the information available?

Is the person willing to deal with the consequences?