The Process of Taking a Logical Data Model and Transforming

question 63

Multiple Choice

The process of taking a logical data model and transforming it into a physical model that is efficient for the most often used tasks is called:

• A) referential integrity.
• B) normalization.
• C) denormalization.
• D) data warehousing.
• E) online analytic processing.

---

Definitions:

Date/Time

A data type or function in programming and database management that records both the date and the time of an event.

AutoNumber

A feature in database systems that automatically generates a unique number for each new record or entry.

Relational Database

A database structured to recognize relations among stored items of information according to a pre-defined schema.

Spreadsheet

A digital worksheet that organizes data in rows and columns, making it easy to store, calculate, and analyze numerical information.