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.

Question

Quizplus · Accepted Answer

The first step in designing a database based on the given requirements is to identify and name the entities, which in this case are CUSTOMER and ORDER. This step is fundamental before defining unique identifiers or attributes, as it establishes the main objects the database will manage.

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