Question

In: Computer Science

All records in a file must be uniquely identifiable in at least one attribute, which is its primary key. Drawing on your general knowledge of accounting,

All records in a file must be uniquely identifiable in  at least one attribute, which is its primary key.  Drawing on your general knowledge of accounting,  identify the primary key for the following types of  accounting records. To illustrate, the first record is  done for you.

Accounts Receivable 

Accounts Payable 

Inventory 

Customer Sales Orders 

Purchase Orders to vendors 

Cash Receipts (checks) from 

Customers 

Cash Disbursements (checks) 

to vendors 

Employee Payroll Earnings 

Records

Solutions

Expert Solution

Characteristics of Useful Information

Record Type

Primary Key

Accounts Receivable

Customer Number

Accounts Payable

Vendor Number

Inventory

Part Number

Customer Sales Order

Sales Order Number

Purchase Orders to vendors

Purchase Order Number

Cash Receipts from customers

Receipt Number

Cash Disbursements to vendors

Check Number

Employee Payroll Earnings records

Employee Number


Related Solutions

Based on your general knowledge of vertical or horizontal restructuring: which one do you generally recommend?...
Based on your general knowledge of vertical or horizontal restructuring: which one do you generally recommend? Provide one argument in favor of your choice and one argument against the other form of restructuring.
Your faceted search item will have at least one categorical attribute. For example a clothing store item could have an attribute called colour, its values could be red, white, black etc.
(a) Define a class for your item including a constructor.(b) Write a function that loads csv text(the function up to you) then creates an array of items using the above class’s constructor.(c) Add a print method to your class. Write test code that prints your item array using this method.Your faceted search item will have at least one categorical attribute. For example a clothing store item could have an attribute called colour, its values could be red, white, black etc.Your...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT