Create All Necessary Database Specifications (Table Names and Field Names)

question 60

Essay

Create all necessary database specifications (table names and field names) for PTW Corporation's acquisition/payment process based on the following narrative.Indicate primary keys by underlining and foreign keys with brackets.PTW Corporation sells computer peripherals and related devices, such as printers, ink, flash drives and cables.PTW has a staff of three purchasing agents, each of whom is in charge of a specific set of inventory items.Each purchasing agent uses his/her discretion in making decisions about when to order inventory, how much inventory to order and which vendor to purchase from.When ordered inventory arrives at PTW, one of two receiving clerks matches the items, quantities and vendors against a copy of the purchase order, then either stocks the merchandise on the shelves or puts it in the storeroom.PTW's accountant receives a copy of the invoice from the vendor, as well as an e-mail from one of the receiving clerks indicating that merchandise has been received.The e-mail also includes the relevant purchase order number.The accountant files the invoice by date in a filing cabinet; once a week, the accountant removes invoices from the filing cabinet and pays them by check.To cut down on clutter in the office, the accountant shreds the vendor invoice after the check has been paid by the bank.The accountant also completes a bank reconciliation within two weeks of receiving the bank statement in the mail.

---

Definitions:

Computer-operated Pump Meter

A device controlled by a computer that measures the flow of liquids or gases through a pump, often used for accuracy in dispensing fuels or chemicals.

Cash Discount

A reduction in the price paid for goods or services that is offered to customers who pay in cash rather than using credit.

Net Profit

The amount of money remaining after all operating expenses, taxes, and interest are deducted from total revenue.

Cell Phone Usage

Refers to how individuals use their mobile phones, encompassing a range of activities including calling, texting, internet browsing, and app usage.