Quiz 4 INFO 4707

When designing a database you should ____.

make sure entities are in normal form before table structures are created.

All relational tables satisfy the ____ requirements.

1NF

Following is an incomplete dependency diagram draft for a CLASS table in an academic database system. Which of the statements is correct?

Incorrect: It is in 2NF

Which of the following statements is correct?

Incorrect: Normalization should be used separately from the ER modeling process.

In order to convert the figure shown in question 3 into a higher normal form, we divide the entity into three entities: CLASS (CLASS_CODE, CLASS_NAME) STUDENT (STU_ID, STU_LNAME, STU_FNAME) ENROLLMENT (CLASS_CODE, STU_ID, STU_GRADE) After this conversion, which of the following statements is WRONG?

Incorrect:Now they are in 3NF.

Which of the following definitions is correct?

Incorrect : second normal form (2NF) includes no partial dependencies and transitive dependencies.

Which of the following statement about normalization is correct?

Normalization is a process to help minimize data redundancies, thus eliminate data anomalies.