Database Design for the Acquisition/payment Process
Specify the Fields That

question 53

Essay

Database design for the acquisition/payment process
Specify the fields that should be included in a database table for each item listed below; underline primary keys and [bracket] foreign keys. Some cells in the table may be left blank. $$\begin{array} { | l | l | l | } \hline \text { Inventory table } & \text { Disburse cash table } & \text { Purchase / inventory table } \\\hline & & \\\hline & & \\\hline & & \\\hline & & \\\hline & & \\\hline & & \\\hline & & \\\hline & & \\\hline & & \\\hline & & \\\hline\end{array}$$

---

Definitions:

Average Variable Cost

The total variable cost divided by the quantity of output produced, representing the cost of producing one more unit.

Market Price

The contemporary pricing at which a good or service is available for trading in a market context.

Purely Competitive Market

An economic setup marked by the presence of numerous small-sized companies, identical products, and straightforward market entry and exit, culminating in firms accepting prevailing market prices.

Cost Data

Information related to the expenses incurred in the production of goods or services, including materials, labor, and overhead costs.