Answered step by step
Verified Expert Solution
Link Copied!

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

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information Systems

Authors: Marshall B. Romney, Paul J. Steinbart

13th edition

133428532, 978-0133428537

More Books

Students also viewed these Accounting questions

Question

3 8 . .

Answered: 1 week ago