State relationships as implied by foreign keys

Assignment Help Database Management System

Reference no: EM132141161

Suppose that you have designed a database for Morgan Importing that has the following tables:

EMPLOYEE (EmployeeID, LastName, FirstName, Department, Phone, Fax, EmailAddress)

STORE (StoreName, City, Country, Phone, Fax, EmailAddress, Contact)

ITEM (ItemID, StoreName, PurchasingAgentID, PurchaseDate, ItemDescription, Category, PriceUSD)

SHIPPER (ShipperID, ShipperName, Phone, Fax, EmailAddress, Contact)

SHIPMENT (ShipmentID, ShipperID, PurchasingAgentID, ShipperInvoiceNumber, Origin, Destination, ScheduledDepartureDate, ActualDepartureDate, EstimatedArrivalDate)

SHIPMENT_ITEM (ShipmentID, ShipmentItemID, ItemID, InsuredValue)

SHIPMENT_RECEIPT (ReceiptNumber, ShipmentID, ItemID, ReceivingAgentID, ReceiptDate, ReceiptTime, ReceiptQuantity, isReceivedUndamaged, DamageNotes)

1. Do you think STORE should have a surrogate key? If so, create it and make required adjustments in the design. If not, explain why not or make other adjustments to STORE and other tables that you think are appropriate.

2.Specify NULL/NOT NULL constraints for each table column.

3.Specify alternate keys, if any

4.State relationships as implied by foreign keys and specify the maximum and minimum cardinality of each relationship. Justify your choices.

5.Explain how you will enforce the minimum cardinalities in your answer to question 4. Use referential integrity actions for required parents, if any. Refer to your book diagram as a boilerplate for required children, if any.

Reference no: EM132141161

Questions Cloud

Student loan interest deduction : They are married and file a joint return. What is Noel's and Noelle's student loan interest deduction?

What is the total end-to-end delay to send a 2kb packet : Suppose there is exactly one packet switch between a sending host and a receiving host.

Miscellaneous itemized deductions : What is the total value of Sam's miscellaneous itemized deductions?

Benefit of the interest tax shield next year : How much debt can COWCOW issue this year and still receive the benefit of the interest tax shield next year?

State relationships as implied by foreign keys : State relationships as implied by foreign keys and specify the maximum and minimum cardinality of each relationship. Justify your choices.

What is the overall speed-up for the program : What is the overall speed-up for the program? (b) What is the biggest (theoretical) speed-up that could be obtained by speeding up division?

What is the present value of the payments : ppose you are going to receive $14,100 per year for six years. The appropriate interest rate is 6.9 percent.

Define the objective of mobile application : Suppose you have to design a mobile application to control your microwave over internet.

How many total votes can be cast : How many total votes can be cast? (Do not round intermediate calculations and round your answer to the nearest whole number.)

User Account

All Pages