2. List the functional dependencies in the following table that concern invoicin

Question

2. List the functional dependencies in the following table that concern invoicing (an application TAL Distributors is considering adding to its database), subject to the specified conditions. For a given invoice (identified by the Invoice- Num), there will be a single customer. The customer’s number, name, and complete address appear on the invoice, as does the date. Also, there may be several different items appearing on the invoice. For each item that appears, display the item number, description, price, and number shipped. Each customer that orders a particular item pays the same price. Convert this table to an equivalent collection of tables that are in third normal form.

Invoice (InvoiceNum, CustomerNum, LastName, FirstName, Street, City, State, PostalCode, Date, (ItemNum, Description, Price, NumShipped))

Explanation / Answer

Below is the list of equivalent tables in 3NF form.

(InvoiceNum,CustomerNum,FirstName,LastName,Date)

(InvoiceNum,CustomerNum,Street,City,State,PostalCode)

(InvoiceNum, ItemNum, Description, Price,NumShipped,Date)

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.