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:

Adult White Men

A demographic group historically granted full citizenship rights, including voting and land ownership, in various societies, often at the expense of women, indigenous peoples, and non-white populations.

Property Qualifications

Requirements that individuals must own a certain amount of property or wealth to be eligible for specific rights or positions, such as voting or holding public office.

Lower Orders

Refers to people of lower social, economic, or political status in a given society, often used historically.