• Author / Uploaded
• Ferry Dharma

Citation preview

Tugas SIA Kelas Pagi

REA Model - Feinman Computers Jawaban A dan B Reserve

Place Order

Inventory

Take Order

Customer

Process

Sales Clerk

Causes

Reduces Ship

Ship Product

Shipping Clerk

Recieve

Customer

Duality Remits

Process Remittence

Increases

Cash

Receive Cash

Cash Receipt Clerk

Jawaban C Tables, Keys, and Attributes for Feinman Computers Table Name Inventory

Primary Key Item Number

Cash Take Order

Accounts Order

Ship Product

Invoice

Receive Cash

Remittance

Customer

Customer Number

Supplier

Supplier Number

Employee

Employee Number

Foreign Key(s)

Inquiry Number Customer Number Employee Number Order Number Customer Number Employee Number Customer Number Employee number Account Number

Attributes Description, Warehouse Location, Quantity on Hand, Reorder Point, OnOrder Quantity, Available for Sale, Supplier Number, Unit Cost, Retail Price Balance Order Date, Promised Date, Terms Of Trade Invoice Amount, Shipped Date, Due Date, Close Date Customer Check Number, Date, Amount Name, Address, Line of credit, Available Credit, Current Balance, Last Payment Date, Name, Address, Terms of Trade, Vendor lead time, Carrier used, Ontime delivery record, Incomplete shipments record, Damaged shipments record, Price disputes record SSN, Name, Address, Date of Birth, Job Title, Data Hired, Pay Rate, Vacation Time Accrued

Linking Tables Table Name InventoryOrder Link InventoryShip Link

Primary Key Item Number Order Number Item Number Invoice Number

Attributes Quantity Ordered Quantity Shipped, Actual Price

Tugas SIA Kelas Siang

REA Model - K Cannon, Inc, Jawaban A dan B Flags Item

Processes

Inventory

Oder Product

Purchasing Clerk

Recieves

Supplier

Causes Ship

Increases Prepares

Receive Product

Receiving

Recieves

Supplier Duality

Processes

Decreases

Cash

Disburse Cash

Cash Disbursement Clerk

Jawaban C Tables, Keys, and Attributes for Feinman Computers Table Name Inventory

Primary Key Item Number

Cash Order Product

Account Purchase Order

Receive Product

Receiving Report

Disburse Cash

Check Number

Supplier

Supplier Number

Employee

Employee Number

Foreign Key(s)

Supplier Number Supplier Number Employee Number Purch Order Number Check Number Supplier Number Cash Disb Clerk (EMPL) Account Number

Attributes Description, Warehouse Location, Quantity on Hand, Reorder Point, OnOrder Quantity, Available for Sale, Supplier Number, Unit Cost, Retail Price. Turnover rate, Lead time, Usage rate, Economic order quantity, Stockout history, Scrap history Balance Order Date, Expected Delivery Date, Expected Total Price Date Received, Carrier, Total Amount Due, Due

Amount, Date

Name, Address, Terms of Trade, Vendor lead time, Carrier used, Ontime delivery record, Incomplete shipments record, Damaged shipments record, Price disputes record SSN, Name, Address, Date of Birth, Job Title, Data Hired, Pay Rate, Vacation Time Accrued

Linking Tables Table Name Ord-ProdInven Link Rec-ProdInven Link

Primary Key Item Number Purchase Order Number Item Number Receiving Report

Attributes Order Quantity

Quantity Received, Actual Unit Cost, Condition