Midterm Quiz2 - Information Management

What is an unnormalized data?

• Data with redundant data

• Data with only one table

• Data with no anomalies

• Data with no primary key

What is the main objective of normalization?

• To increase data redundancy

• To eliminate data anomalies

• To store data in multiple tables

• To have nonprime attributes independent of the primary key

Which normal form ensures that each table represents a single subject?

• Boyce-Codd normal form

• First normal form

• Second normal form

• Third normal form

What is the highest level of normalization considered necessary for most applications?

• First normal form

• Second normal form

• Third normal form

• Fourth normal form

What is the example of an unnormalized table provided in the text?

• STU_NUM STU_NAME

• ADV_ID SUBJ_CODE STU_NUM

• ADV_ID ADV_NAME

• ADV_NAME SUBJ_CODE SUBJECT STU_NUM STU_NAME

Which normal form ensures that there are no non-key attributes determined by another non-key attribute?

• Boyce-Codd normal form

• Third normal form

• Second normal form

• First normal form

What is the reference book mentioned in the text for database systems?

• Introduction to Programming

• Fundamentals of database systems

• Database systems: design, implementation, and management

• Data Structures and Algorithms