When Transforming an E-R Data Model into a Relational Database

question 96

Multiple Choice

When transforming an E-R data model into a relational database design,the key of the parent entity should be placed as part of the primary key into the child entity ________.

• A)when the child entity is ID-dependent
• B)when the child entity is non-ID-dependent
• C)when the child entity has a 1:1 relationship with the parent entity
• D)when the child entity has a 1:N relationship with the parent entity
• E)when the child entity has a recursive relationship with the parent entity

---

Definitions:

Goodness-of-fit Test

A statistical test used to determine how well observed data fit a specific distribution or model.

Test of Independence

A statistical method used to determine if there is a significant association between two categorical variables.

Nonparametric Tests

Statistical tests that do not assume a specific distribution in the data and are used for ordinal or nominal data.

Spearman Rank

A non-parametric measure of rank correlation that assesses how well the relationship between two variables can be described using a monotonic function.