The following data elements comprise the conceptual-level schema for a database:

Product code

Product description

Product cost

Quantity on hand

Minimum stock level

Quantity purchased

Invoice number

Supplier code

Supplier name

Supplier terms

Required

a. identify three potential users and design a subschema for each. Justify your design by explaning why each user needs access to the subschema data elements.

b. Use Microsoft Access or another relantional database software to create the schema tables. Specify the primary key(s), foreign key(s), and any other data that might be required for each table. Test your model by entering sample data in each table.