You Receive the Following Requirements for a Caterer's Database: for a Customer

question 26

Multiple Choice

You receive the following requirements for a caterer's database: For a customer, store a customer ID, last name, first name, billing address, and phone number
For an order, store an order number, order date, event date, customer ID, description of services, and total price for services
When designing this database, which step do you take first?

• A) Identify the customer ID and order number as unique identifiers.
• B) Identify and name the entities CUSTOMER and ORDER.
• C) Identify customer ID, last name, first name, billing address, and phone number as attributes.
• D) Create a CUSTOMER table that includes all the customers' attributes as columns.

---

Definitions:

Expense Account

An account where businesses track costs incurred during operations, often related to employees' business-related expenses.

Chart of Accounts

The Chart of Accounts is a systematic list of all accounts used by an organization, essential for classifying and organizing financial transactions within the general ledger.

Expense Account

An account where costs associated with the operations of a business, such as rent, utilities, and salaries, are recorded.

Asset Account

An account that represents a tangible or intangible item of value owned by a company, such as cash, inventory, or equipment.