all records in a file must be uniquely identiied in at least one attribute which is its primary key.

identify primary key

Record Type:

Accounts payable
Inventory
Customer Sales Orders
Purchase Orders to Vendors
Cash Receipts (checks) from Customers
Cash Disbursements (checks) to Vendors
Employee Payroll Earnings Records

EX. Record Type ----Primary Key

Accounts Rec.--- Customer Number

To identify the primary key for each record type, you need to understand the purpose and structure of the data in each record type. The primary key is a unique attribute assigned to each record, ensuring that no two records have the same value for that attribute.

Here are some possible primary keys for each record type:

1. Accounts Payable: Vendor ID or Invoice Number
2. Inventory: Item ID or Product Code
3. Customer Sales Orders: Order Number or Customer Order ID
4. Purchase Orders to Vendors: Purchase Order Number or Vendor Order ID
5. Cash Receipts (checks) from Customers: Receipt Number or Customer Payment ID
6. Cash Disbursements (checks) to Vendors: Disbursement Number or Vendor Payment ID
7. Employee Payroll Earnings Records: Employee ID or Payroll Record ID

In each case, the primary key should uniquely identify each record. It is usually a single attribute, but in some cases, it can be a combination of attributes if necessary. The primary key is critical for data integrity and efficient data access in a database or file system.