Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(b) Consider the Purchase Table below Purchaseltem Antique Desk Antique Desk Antique Candle Holders Antique Candle Holders Dining Table Linens Candles Desk Lamp Floor Lamp

image text in transcribed

(b) Consider the Purchase Table below 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, Denise 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 Purchaseltem and PurchaseDate 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. [3 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_2

Step: 3

blur-text-image_step3

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

More Books

Students also viewed these Databases questions

Question

What are the different techniques used in decision making?

Answered: 1 week ago

Question

LO5 Illustrate the steps in developing a base pay system.

Answered: 1 week ago

Question

LO3 Outline strategic compensation decisions.

Answered: 1 week ago