How do I normalize these two tables into 3NF? Purchaseltern Phone 206-325-7866 2

Question

How do I normalize these two tables into 3NF?

Purchaseltern Phone 206-325-7866 206-325-7866 206-325-7866 206-325.7866 206-3256755 206.325.6755 206-325.8077 206-325-8977 206-325.6755 206-325-6755 425-7464322 425-746-5433 425-746.5433 206-325-9089 206-325-9088 Antique Desk Antique Desk Antique Candle Holders Antiquo Candlo Holdors Dining Tablo Linons 1,800.00 1,750.00 210.00 7-Nov-13 European Specialties Agure 3-33 7-Nov-13European Specialties Sample Sales Data for The Queen Anne Curiosity Shop 7-Nov-13 European Spacialties LastName FirstName 7-Nov 13 Europoan Spocialtios 14-Nov-13 Linons and Things 14-Nov-13 Linons and Things 4 Nov-13 Lamps and Lighting 14-Nov-13 Lamps and Lighting 21-Nov-13 Linens and Things 21-Nov-13 Linens and Things 21-Nov-13 Harrison, Denise 28-Nov-13 Loo, Andron 28 Nov-13 Loe, Andraw 28-Nov-13 Naw York Brokerage 28-Nov-13 NewYork Brokerage 206-524-2433 14-Dec-13 Antique Desk 3,000.00 249.00 3,249.00 541.50 Goodyoar Kathorine 206-524-3544 15.Doc-13 Dining Table Linans1,000.00 83.00 1,083.00 206-524-2433 14-Dec-13 Antique Desk Chair 500.0041.50 Desk Lamp 150.00 50.00 4.15 54.15 425-635-0788 15-Dec-13 Candles 206-5244655 23-Dec-13 Candles 206-524-2433 5-Jan-14Desk Lamp 425-635-8677 10-Jan-14 Dining Table Linens 45.00 3.74 Dining Table Linens 250.0020.75 270.75 750.00 62.25912.25 Book Shelf 150.00 7566 12-Jan-14 |Book Shef 250.00 20.75 Goodyoar Kathorino 206-524-3544 15 Jan 14 Antiquo Chair 1,250.00103.751,353.75 ,750.00 145.251,895.25 425-635-8677 25-Jan-14 Antique Candle Holders 350.00 29.05 379.05 Antique Desk Chalr Kathorine 206.524-354415-Jan-14 Antique Chair Antique Chair 1,050.00

Explanation / Answer

Dear Student ,

As per the requirement submitted above , here is the solution. Currently as per question there are two tables and these tables needs to be normalized.= in 3NF. So first see what is Normalizatio?

What is Normalization?

Normalization is a process which is used to remove redundent or duplicate data by applying certain techniques.

Forms of Normalization:

1.First Normal Form (1NF):

First Normalization Form (1NF) says that each record in the table should be unique and each row can have only one column value. That means here multivalued columns are not allowed.

2.Second Normal Form (2NF) :

2NF says that each table should be in 1NF and partial dependency should be removed that means all non primary key attributes should depend on primary key value.

3.Third Normal Form (3NF) :

3NF says that a table should be in the 2NF and Transitive functional dependency that means no non-prime attribute is transitively dependent on prime key attribute.

Appart from this check for BCNF (Boyce Codd normal form) ,4NF , 5NF and 6NF.

Following section gives 3NF of the above tables :

In First table column names are ,

Second table column Names are

Here invoice is not having any relation with customer so this to be normalized into

Table 1 :Customer(LastName-Primary Key ,FirstName,Phone)

Here Customer table stores details about customer with LastName as primary key or need to add one more column with name as CustomerID and make that CustomerID as primary key.

Table 2 : VendorDetails (Vendor - Primary Key , Phone)

Here VendorDetails stores details about the vendor with Vendor as primary key along with Phone number.

Table 3 :Invoice(InvoiceItem,Price)

Here Invoice is a new table which stores the details about the InvoiceItem as Primary key and price for that

Item.

Table 4:InvoiceDetails (InvoiceDate,InvoiceItem,,Tax ,Total)

Here InvoiceDetails stores the InvoiceDate , InvoiceItem as foreign key with tax calculated based on price and total amunt.

Table 5 :Purchase(PurchaseItem,PurchasePrice,PurchaseDate,Vendor )

Here Purchase details is stored in purchase table with given attributes with Vendor as foreign key.

NOTE: KINDLY PROVIDE FEEDBACK ABOUT THE SOLUTION.

LastName FirstName Phone InvoiceDate InvoiceItem Price Tax Total

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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