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:

Union

In set theory, the combination of two sets to form a set that includes any elements that are a member of at least one of the original sets.

Independent Events

Describes two events where the occurrence of one does not affect the probability of the occurrence of the other.

Conditional Probability

The odds of an event taking place assuming another distinct event has occurred previously.

Joint Probability

The probability of two or more events happening at the same time, assuming there is some relationship between the events.