Case: Inventory Management Database The consultant of the Inventory Management System has decided to create a database t

[answerhappygod]

Case: Inventory Management Database The consultant of the
Inventory Management System has decided to create a database to
capture the required data using Microsoft Access database. The
purpose of the database is to manage the inventory of various
health products sold by the company. (a) You are required to design
and show the three basic tables with the relevant fields. Show the
data view of the three tables in your answer file (Do not create
the tables using Microsoft Access). For each table below, you
should specify the appropriate MS Access data type for each field.
You should also define the relevant primary key and foreign keys
(if any) for the three tables below. (i) Daily Transaction Table
The purpose of this table is to store information relating to each
transaction captured by the point-of-sale system. Some key fields
are Record No, Transaction ID, Transaction Date, Product Code,
Quantity. You should show the data view of minimum five records by
creating your own data. Your data should show how a transaction can
have more than one product. (6 marks) (ii) Inventory Table The
purpose of this table is to show the product available in the
inventory. The key fields are Product Code, Product Description,
Price, Stock Quantity and Supplier ID. You should show the data
view of minimum five records with your own data. (6 marks) (iii)
Additional Table Proposed an additional table with relevant fields
that can provide relevant data for this system. Show the data view
with at least three records. (6 marks) (b) Explain the reasons for
having both the Record No and Transaction ID fields in the Daily
Transaction Table. (3 marks) (c) Provide TWO (2) reasons for not
including the Product Description and Price field in the Daily
Transaction Table.