Question

Kitchen World is changing its inventory system from a file-oriented system to a relational database system. Identify and design at least three tables that would be needed to capture data for Kitchen World's inventory. Each table should include a primary key, three non-key attributes, and foreign keys as necessary. Make up data values for two records within each table. Create an excel spreadsheet with this data. Download it to Access and do a query for the name of the largest inventory item. Submit a Screen shot this query showing the date and time.

Answer 1

Answer to the question

Table Name	Primary Key	Foreign Keys	Other Attributes
Inventory	Item Number		Description Quantity on Hand
Purchases	Purchase order number	Vendor number Purchasing Agent (employee number)	Date of purchase Total amount of purchase
Purchases-Inventory	Item number Purchase order number		Quantity purchased Unit cost (actual) Extended amount
Vendor	Vendor number		Vendor name Vendor address
Employees	Employee number		Employee name