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.
