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
Get step-by-step solutions from verified subject matter experts
