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:

Psychoanalysis

A therapeutic approach and theory of psychological disorders founded by Sigmund Freud, emphasizing unconscious processes and unresolved past conflicts.

Free Association

A psychoanalytic technique that involves encouraging individuals to say aloud whatever comes to mind, no matter how trivial or embarrassing.

Dream Interpretation

The process of assigning meaning to dreams, often seen as a way to understand subconscious thoughts or feelings.

Transference

A client’s relating to the psychoanalyst in ways that reproduce or relive important relationships in the client’s life.