Explain issues to convert relationship for new cardinality

Assignment Help Database Management System

Reference no: EM1370966

After your database was put into production a design flaw was discovered. One of the relationships identified as a 1:N relationship was determined to be a N:M relationship. Using the example of vehicles and drivers, discuss the issues to convert the relationship for the new cardinality including the new relationships and attributes for the tables.

You can Assume that Driver's License number is always unique, even across different states. Also assume that zipcode determines city and state.

Vehicle(VIN, Make, Model, Color, Licence_tag)
Drivers(Driver_license_no, last_name, first_name, middle_name, address, zip, VIN)
Zipcode(Zipcode, City, State)

Reference no: EM1370966

Questions Cloud

Find out how long the train blocked the crossing : Four charges Aq,Bq,Cq, and Dq (q = 5 x 10-07C) sit in a plane at the corners of a square whose sides have length d = 80.0 cm. A charge, Eq, is placed at the origin at the center of the square.

Which nation should specialize in which product : Which nation should specialize in which product. Explain how trading possibilities lines for each nation if actual terms of trade are 1 plum for 2 apples.

Illustrate what would be mark-up ratio : Illustrate what price should firm charge to realize targeted profit. Illustrate what would be its (cost-based) mark-up ratio.

Calculate the afn : Chua Chang & Wu Inc. is considering its operations for next year, and the CEO wants you to forecast the company additional funds needed

Explain issues to convert relationship for new cardinality : Using example of vehicles and drivers, explain issues to convert relationship for new cardinality including new relationships and attributes for the tables.

Explain how does price elasticity of demand for corn oil : Explain how does price elasticity of demand for corn oil influence quantity-demanded of corn oil and Total Revenue earned by sellers of corn oil? Explain, using economic terms, why this is so.

Allocating the budget in order to achieve objective : Suppose you are manager of customer service department at a bank and you want to hire customer service representatives for a newly opened bank branch.

Design premiere products databas-shows relationship : Indicate changes you require to make to design of Premiere Products database to support following situation: There is no relationship between customers and sales reps.

Illustrate what evidence of excess supply or excess demand : Provide two examples of actions taken by a company, government, or organization whose effect is to prevent specific markets from reaching equilibrium. Illustrate what evidence of excess supply or excess demand can you cite in these examples.

User Account

All Pages