Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Ramjohn Hunte wants to store the following data about Helsinki Company's purchases of inventory: item number date of purchase vendor number vendor address vendor name
Ramjohn Hunte wants to store the following data about Helsinki Company'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 1. Design a set of relational tables to store this data. Name each table and field in accordance with good database design. Do all 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? (14 marks) 2. Identify the primary key for each table. ( 3 marks) Identify the foreign keys needed in the tables to implement referential integrity. ( 3 marks) Ramjohn Hunte wants to store the following data about Helsinki Company'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 1. Design a set of relational tables to store this data. Name each table and field in accordance with good database design. Do all 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? (14 marks) 2. Identify the primary key for each table. ( 3 marks) Identify the foreign keys needed in the tables to implement referential integrity. ( 3 marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started