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

question 5

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 name follows the recommendation of capitalizing the first letter of each word and also follows the no spaces recommendation?

---

Definitions:

Census Data

Systematically collected information about populations, usually including demographic, economic, and social data, gathered through a census.

Official Statistics

Data collected, analyzed, and published by governmental agencies to provide quantitative or factual information on the economic, demographic, and social conditions.

Police Crime Reports

Official documents that record incidents and suspected crimes reported to law enforcement agencies.

Sociological Research

The process of conducting systematic studies aimed at understanding or explaining the patterns, behaviors, and structures of human society, using various methods of empirical investigation and critical analysis.