Accounting Information Systems Probems

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

Billing address

Cost

Credit limit

customer name

date

description

invoice number

item number

price

quantity on hand

quantity sold

shipping address

terms

Required

Identify three potential users and design a subschema for each . Justify your design by explaining why each user needs access to that data element

Answer

A bill may be required to be created and filled by the billing clerk who will require

customer

name and number

billing address

item numbers and quantity sold

terms and the price

Sales order entry clerk - this will be required so as to fill out and generate the sales orders

The sales order should contain the following

item number and description

price and quantity-on-hand

customer name

shipping address

credit limit

account balance

The procurement department will need the information so as to make the right procurement decisions and they will need the following

item number and description

quantity on hand and

cost of the item to be procured

Using any relational database product , such as Microsoft Access , create the set of tables to implement your schema . Specify the primary key (s and foreign key (s ) for each table . Learn how to enforce referential integrity , and test your model by entering sample data in each table

Name of the table Primary Key (s ) Foreign Key (s ) Other characteristics

Stock (inventory ) Item Number

Quantity and item description

Cost price

Customer Customer no . None Customer name and address

Credit Limit and terms

Sales...