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 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
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
Get step-by-step solutions from verified subject matter experts
