The Whole Purpose of Separating Data into Separate Tables in a Relational

question 48

Multiple Choice

The whole purpose of separating data into separate tables in a relational database is to

• A)provide the data in a format that can be analyzed using Excel.
• B)enable the data to be cleansed.
• C)simplify the process of importing data.
• D)avoid redundancy.

---

Definitions:

Caption

A brief explanation or description accompanying an illustration, photo, or diagram.

Delete Field

The act of removing a column or data field from a database table or data structure.

Remove Field

Refers to the action or process of eliminating a particular field or data entry point from a database or form.

Delete Column

A function in spreadsheet or database software that permanently removes a column and its data from the table.