Instructions:

$1.$ 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.

$2.$ Use proper notation as instructed during the lessons.

$3.$ Organize your model based on maintenance$/$master tables and operating event$/$transaction tables.