Ashton wants to store the following data about S&Ss purchases of inventory: Item number Date of purchase
Fantastic news! We've Found the answer you've been seeking!
Question:
Ashton wants to store the following data about S&S’s purchases of inventory:
Item number
Date of purchase
Vendor number
Vendor address
Vendor name
Purchase price
Quantity purchased
Employee number
Employee name
Purchase order number
Description
Quantity on hand
Extended amount
Total amount of purchase
Required
a. Design a set of relational tables to store this data. Do all of the data items need to be stored in a table? If not, which ones do not need to be stored, and why do they not need to be stored?
b. Identify the primary key for each table.
c. Identify the foreign keys needed in the tables to implement referential integrity.
Related Book For
Business Statistics A First Course
ISBN: 978-0321979018
7th edition
Authors: David M. Levine, Kathryn A. Szabat, David F. Stephan
Posted Date: