Question: Q2: Create relational tables that solve the update, insert, and delete anomalies in Table 4-18. Create all the relational tables with PK, FK (labeled) and

Q2: Create relational tables that solve the update, insert, and delete anomalies in

Table 4-18. Create all the relational tables with PK, FK (labeled) and with the records for each table.

Purchase

Order #

Purchase Order Date

Part #

Description

Unit

Price

Quantity Ordered

Vendor #

Vendor Name

Vendor Address

2

3/9/18

334

XYZ

$30

3

504

KL Supply

75 Stevens Dr.

2

3/9/18

231

PDQ

$50

5

504

KL Supply

75 Stevens Dr.

2

3/9/18

444

YYM

$80

6

504

KL Supply

75 Stevens Dr.

3

4/5/18

231

PDQ

$50

2

889

Oscan Inc

55 Cougar Cir.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!