Post a New Question

college

posted by .

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

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. System Analysis &Design

    What should my entities be? Consider the following situation. A manufacture of computers receives orders from customers through its sales office. Each order can have several products in it (different types of computers, lap tops, monitors,
  2. Accounting

    13-22 Martin Shoes, Inc. (Planning a Database Using REA and E-R Methodology) Martin Shoes, Inc., manufactures and distributes orthopedic footwear. To sell its products, the marketing department requires sales personnel to call on the …
  3. college

    Problem 2: For each journal entry, prepare an explanation of the business event that is being represented: a. Loan payable $57,000 Cash $11,400 Inventory $45,600 b. Accounts payable $13,450 Cash $13,450 a. The company borrowed $57,000 …
  4. Finance

    Imagine the CFO of a company has asked you, the auditor, to review the internal controls for cash receipts and to evaluate its cash management of accounts. Prepare a one page letter to the CFO addressing the following questions: 1. …
  5. accounting

    Capwell Corporation uses a periodic inventory system. The company's ending inventory on December 31, 2011, its fiscal-year end, based on a physical count, was determined to be $326,000. Capwell's unadjusted trial balance also showed …
  6. Finance

    Calculate the accounts receivable period, accounts payable period, inventory period, and cash conversion cycle for the following firm: Income statement data: Sales 5,000 Cost of goods sold 4,200 Balance Sheet Data: Beginning of Year …
  7. accounting

    Given the case assignment, do items 1 – 4 1. Draw a partial REA diagram of the XYZ Company’s revenue cycle to model there events: taking customer orders, deliveries, and the use of vehicles. Be sure to include cardinalities 2. …
  8. bookkeeping

    a store purchased 500 in merchandise on account.using the periodic inventry system,how would you record your entry?
  9. Accounting

    The beginning inventory of Merchandise at Waldo Co. and data on purchases and sales for a three-month period are as follows: Date Transaction Number of Units Per Unit Total March 3 Inventory 60 $1500 $90,000 8 Purchase 120 1800 216,000 …
  10. programming

    Design a program and write program that will read a file of sales records and produce a sales report. Each record in the file contains a customer's number and name, a sales amount and a tax code. The tax code is to be applied to the …

More Similar Questions

Post a New Question