Case 1-3 Main Street Catering Has Created a Database with One Table

question 37

Short Answer

Case 1-3

Main Street Catering has created a database with one table containing customer information. When creating the table, Marissa did not follow recommendations for naming fields in a table. There are a number of changes that would make the field names more useful and follow field naming recommendations. Using the accompanying figure, answer the following questions about the CustomerTable.Which field is the primary key (unique identifier) in the Customer Table?

---

Definitions:

Coastal Dunes

Natural accumulations of sand or sediment found along coastlines, formed by the wind and protecting inland areas from sea surges.

Equity Method

An accounting technique used to record investments in other companies, where the investment gives the investor significant influence over the investee, typically reflected as a percentage of the investee's net income or loss on the investor's balance sheet.

Consolidated Financial Statements

Financial statements that aggregate the financial position and operating results of a parent company and its subsidiaries, presenting the group as a single economic entity.

Common Shares

Equity securities that represent ownership interest in a corporation, giving holders voting rights and a share in the company's profits via dividends.