Question: Help with additional attributes in the AIS logical model tables. Attached is the REA model, need help identifying the additional attributes of the tables. I'm

Help with additional attributes in the AIS logical model tables. Attached is the REA model, need help identifying the additional attributes of the tables. I'm missing the inventory table at the bottom as it got cut off in the screenshot, so keep that in mind. The job is to complete all tables with the primary keys, foreign keys, and additional attributes from the REA model.

Table Name Primary Key Foreign Key Additional Attributes Request Items Order Items Receive Items Pay Vendors Request # OrderRequest Items + Store Manager Purchase Clerk Inventory Order Items Vendor Receive Items Warehouse Worker Cashier Cash HT Pay 

Table Name Request Items Order Items Receive Items Pay Vendors Return Items Return-Inventory Receive-Inventory Order-Inventory Request-Inventory Request-Order Receive-Pay Store Manager Purchase Clerk Vendor Warehouse Worker Cashier Primary Key Request # Order # Receipt # Payment # Return # [Return # - Item #] [Reciept # - Item [Order # Item #] [Request # - Item #] [Request #- Order #] [Receipt # - Payment #] Manager # Clerk # Vendor # Worker # Cashier # Foreign Key [Manager #] [Clerk #], [Vendor #] [Vendor #], [Clerk #] [Cashier #], [Vendor #], [Account #] [Receipt #]. [Worker #], [Vendor #] Additional Attributes

Step by Step Solution

3.36 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Table Name Primary Key Foreign Key Additional Attributes Request Items Request Manager Item Quantity Date Requested Order Items Order Clerk Vendor Item Quantity Date Ordered Vendor Price Receive Items ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!