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.

 

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

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 the full answer