Problem

DATA ATTRIBUTES Drawing from your basic accounting knowledge, list the relevant data...

DATA ATTRIBUTES

Drawing from your basic accounting knowledge, list the relevant data attributes that constitute the record types below. Identify which attribute is the primary key for the record.

Accounts Payable record

Inventory record

Customer Sales Orders record

Purchase Orders to vendors

Cash Receipts (checks) from customers

Employee Payroll Earnings records

Step-by-Step Solution

Solution 1

Data Attributes

Data attributes are the fields contained in a record such as name, address, quantity, products sold etc.

1. Accounts Payable Record

This record contains the basic information of each supplier like its name, address and contact details. Each supplier is uniquely identified by a supplier number.

The Data attributes of Accounts Payable Record along with its primary key are mentioned as follows:

Picture 1

2. Inventory Record

This record contains the details of every item that is used in the organization.

The Data attributes of Inventory Record along with its primary key are mentioned as follows:

Picture 2

3. Customer Sales Orders Record:

This record type records the header information of every sales order that is placed on the organization by its customers.

The Data attributes of Customer Sales Record along with its primary key are mentioned as follows:

Picture 3

4. Purchase Order to vendors

This records the header information of every purchase order raised by the organization to its suppliers. Some purchase orders may be based on requisitions raised by the various departments.

The Data attributes of Customer Sales Record along with its primary key are mentioned as follows:

Picture 4

5. Cash Receipts (checks) from customers

This records the payments received from the customers.

The Data attributes of Cash Receipts along with its primary key are mentioned as follows:

Picture 6

6. Employee Payroll Earnings Records:

Assuming that payroll is processed once a month for each employee, the earning records can be uniquely identified by the employee number + month of payroll processing.

The Data attributes of Employee Payroll Record along with its primary key are mentioned as follows:

Picture 7

Add your Solution
Textbook Solutions and Answers Search
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT