Instructions $($Cont$.)$:

List each database table required to implement the logical model complete with required primary keys,

foreign keys and non$-$key attributes to track the following data elements on Resource and Agent tables:

a$.$ Inventory Items: Item Description, Price, BQOH, BQOH Date, Standard Cost, $[$At Least One

More Field Specific to Your Industry$]$

b$.$ Sales Clerk: Sales Clerk Name, Sales Clerk SSN#

c$.$ Ship Clerk: Ship Clerk Name, Ship Clerk SSN#

d$.$ Customer: Customer Name, Customer Street Address, Customer City, Customer State,

Customer Zip, Customer Phone #$,$ Customer Segment, $[$At Least One More Field Specific to

Your Industry$]$

Also, make sure you put Date and Quantity fields properly on Event tables. Also, make sure you add

an SH Fee $($Shipping and Handling Fee$)$ field to the proper table.

Use proper notation as instructed during the lessons.

Organize your model based on maintenance$/$master tables and operating event$/$transaction tables.The company has developed the following conceptual $($REA$)$ model in relation to its revenue process.

Instructions:

Based on the generic REA model above and your knowledge of the industry you've been assigned, convert the conceptual model into the logical model for this process. This part of the requirement needs to be typewritten using word processing software, such as Microsoft Word, and uploaded to our course site in PDF file format. Make sure your name is on the face of the document. You will not complete this assignment in Microsoft Access or other database software although this logical model will form the basis for the AIS that you will build in your AIS Project.

Instructions continued on the next page.