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:

Tight Junction

A tightly sealed point of contact between two cells, preventing the passage of substances between the cells.

Plasma Membranes

A pair of lipid layers that forms a barrier around the cell's cytoplasm, controlling the import and export of cellular materials.

Adhesion Belt

A protein complex located just below the tight junctions in epithelial cells, contributing to the formation of an adhesive junction that holds cells together.

Apocrine

A type of gland that secretes substances (such as sweat) by shedding part of the cell, found in various parts of the body including armpits and groin.