Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
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 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started