Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Purchase order # Purchase Date Item Purchased Item Desc Unit Price Quantity Vendor Vendor # Vendor Phone Purchased by Employee ID Office Phone 1 3/3/18

Purchase order # Purchase Date Item Purchased Item Desc Unit Price Quantity Vendor Vendor # Vendor Phone Purchased by Employee ID Office Phone
1 3/3/18 AAA Equitment $300 10 ABC Corp A1 111-222-3333 JACK 2 9802
1 3/3/18 BBB Equitment $402 20 ABC Corp
2 1/1/18 CCC Supply $12 30 DEF Corp B1 888-123-456 TOM 3 9803
2 1/1/18 DDD Equitment $405 10 DEF Corp
3 2/14/18 EEE Supply $76 5 DEF Corp JACK 2 9802
4 12/1/18 FFF Equitment $180 4 GHI Corp C1 713-000-1111 EMMA 4 9804
5 7/18/18 GGG Computer $2,000 1 GHI Corp EMMA
Does this data set need to be normalized? What is its 3NF? Please design the new database.

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

Databases Illuminated

Authors: Catherine Ricardo

2nd Edition

1449606008, 978-1449606008

More Books

Students also viewed these Databases questions

Question

Describe how parent-infant attachment bonds form.

Answered: 1 week ago

Question

Explain the relationship between thoughts, feelings, and actions.

Answered: 1 week ago

Question

Explain the purposes of managing performance.

Answered: 1 week ago

Question

List 4 methods to evaluate training.

Answered: 1 week ago