What Is a Potential Problem, If Any, If You Design

question 35

Multiple Choice

What is a potential problem, if any, if you design a database in which the last name of a consultant functionally determines the consultant's address?

• A) There is no problem with this design.
• B) There could be two consultants living at the same address.
• C) There could be more than one consultant with the same last name.
• D) The address will automatically functionally determine the consultant's last name.

---

Definitions:

Grand Total

The sum of all numbers or quantities in a series, often the final total in a table of numbers.

Column Portions

Segments or parts of a column in a table or spreadsheet, often referred to in data analysis.

Two-way Table

A tabular method to represent data that can help in analyzing the relationship between two categorical variables.

Column Percentages

Percentages that represent the portion each category within a column constitutes of the column's total, often used in crosstabulation tables to analyze categorical data.