Create relational tables that solve the update, insert, and delete anomalies in Table 4-18. TABLE 4-18 Purchase

Create relational tables that solve the update, insert, and delete anomalies in Table 4-18.

Transcribed Image Text:

TABLE 4-18 Purchase Order (PO) Table PURCHASE PURCHASE ORDER ORDER # QUANTITY VENDOR ADDRESS DATE PART # DESCRIPTION UNIT PRICE ORDERED VENDOR VENDOR NAME $30 3/9/2018 334 3/9/2018 231 3/9/2018 44 4/5/2018231 KL Supply 75 Stevens Dr. KL Supply 75 Stevens Dr. KL Supply OSCAN INC 55 Cougar Cir. XYZ 2 75 Stevens Dr. 504 889 $80