Question: Consider the following elements needed to produce a purchase order (see figure below): Purchase order number Purchase order date Vendor code Vendor name Vendor
Consider the following elements needed to produce a purchase order (see figure below): Purchase order number Purchase order date Vendor code Vendor name Vendor address Purchase Agent Name PURCHASE ORDER Purchase order number. Purchase order date: TO: Vendor Code Name Address Purchase Agent Name Product number Product description Quantity purchased Unit cost Total ordered Total due Unit Product No Description Price Quantity Total Thank you for your order! Total Determine the tables needed and put the data in third normal form. Be sure to identify primary, foreign, and/or composite (concatenated) keys as necessary. Primary keys and composite keys should be underlined, while foreign keys should be identified with an asterisk (*). LIST ALL TABLES FOR THIRD normal forms.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
