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:

Bonus

A form of additional compensation given to an employee or workers, above their normal pay, for achieving a certain level of performance or for special occasions.

Commission

A fee paid to an agent or employee for facilitating a sale or transaction, typically calculated as a percentage of the sale.

Car Dealer

An organization that specializes in selling new or pre-owned automobiles directly to consumers, operating under a dealership agreement with a car manufacturer or its sales division.

Strike

A work stoppage initiated by employees to protest against working conditions, wages, or company policies, aiming to pressure the employer into negotiations.