Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Purchaseltem Antique Desk Antique Desk Antique Candle Holders Antique Candle Holders Dining Table Linens Candles Desk Lamp Floor Lamp Dining Table Linens Candles Book Shelf

image text in transcribed
Purchaseltem Antique Desk Antique Desk Antique Candle Holders Antique Candle Holders Dining Table Linens Candles Desk Lamp Floor Lamp Dining Table Linens Candles Book Shelf Antique Desk Antique Desk Chair Antique Chair Antique Chair Purchase Price Purchase Date 1,800.00 7-Nov-18 1,750.00 7-Nov-18 210.00 7-Nov-18 200.00 7-Nov-18 600.00 14-Nov-18 30.00 14-NOV-18 150.00 14-Nov-18 300.00 14-Nov-18 450.00 21-Nov-18 27.00 21-Nov-18 150.00 21-Nov-18 1,000.00 28-Nov-18 300.00 28-Nov-18 750.00 28-Nov-18 1,050.00 28-Nov-18 Vendor European Specialties European Specialties European Specialties European Specialties Linens and Things Linens and Things Lamps and Lighting Lamps and Lighting Linens and Things Linens and Things Harrison, De Lee, Andrew Lee, Andrew New York Brokerage New York Brokerage Phone 206-325-7866 206-325-7866 206-325-7866 206-325-7866 206-325-6755 206-325-6755 206-325-8977 206-325-8977 206-325-6755 206-325-6755 425-746-4322 425-746-5433 425-746-5433 206-325-9088 206-325-9088 PurchasePrice and Pursbase Rate together form a composite primary key. Also, the phone attribute is Vendor's phone numbers and is dependent on the Vendor attribute. Describe and illustrate the process of normalizing the data shown in this table to third normal form (3NF)? Basically design the tables with its attributes and keys which will be formed as a result of the table converted to a 3NF. Show the resulting tables below. You can use crows foot notation if needed to display the tables Displaying data is not mandatory Proper display of the resulting #NF normalised Table Schema is what is needed. 13 Marks]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Visual Basic 6 Databases

Authors: Charles Williams

1st Edition

1861002025, 978-1861002020

More Books

Students also viewed these Databases questions