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

Billing address

Cost

Credit limit

Customer name

Customer number

Description

Invoice number

Item number

Price

Quantity on hand

Quantity sold

Shipping address

Terms

Required

a. Identify three potential users and design a subschema for each. Justify your design by explaining why each user needs access to the subschema data elements. Specify the type of rights you would give to your potential user for each data element in their subschema. Address the rights of Create, Read, Update, and Delete.

b. Use Microsoft Access or some other relational database product to create the schema tables, or just draw it. Specify the primary key(s), foreign key(s), and other data for each table. Test the model by entering sample data in each table.