You Work for a Small Pet Shop and the Store

question 9

Essay

You work for a small pet shop and the store manager asks you to convert some of his paper records to an online system. A simple database exists and the owner wants to add to the existing database.
Assuming that the existing database does not contain information related to sales in the table, how can you extend the database to track the purchases for each customer?

---

Definitions:

Relationship

The way in which two or more concepts, objects, or people are connected, or the state of being connected.

Income Statement

A financial statement that shows a company's revenues, expenses, and profits over a specified period of time, indicating the financial performance of the business.

Gross Profit

The difference between sales and the cost of goods sold, representing the fundamental earning efficiency of a company's core activities.

Payroll Expense

The total amount of money a business pays to its employees as wages or salaries, including taxes and benefits, for a specific period.