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:

Acceptance

In therapeutic contexts, refers to the act of acknowledging and embracing thoughts, feelings, or reality without judgment, often a central component of mindfulness and acceptance-based therapies.

Genuineness

Authenticity and sincerity in one's behavior and interactions, considered essential in various psychotherapeutic approaches.

Untreated Individuals

People who have not received appropriate medical treatment or therapy for their health conditions or disorders.

Effect Sizes

Statistical measures that quantify the strength of a phenomenon or the magnitude of differences or relationships within research findings.