Database Normalization Quiz

What is a key made up of more than one attribute called?

• Composite key

• Foreign key

• Primary key

• Candidate key

Which of the following is NOT a property of a relation in Third Normal Form (3NF)?

• It depends on the key.

• It depends on the whole key.

• It depends on nothing but the key.

• It must have a composite key.

What is the purpose of normalizing a database?

• To make the database more visually appealing.

• To ensure the database is compatible with all operating systems.

• To prevent unnecessary duplication of data and maintain data integrity.

• To reduce the complexity of SQL queries.

A database table contains repeating attributes. Which normal form does it violate?

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

• Fourth Normal Form (4NF)

How are the tables Student and StudentSubject related in a database?

• Through a common attribute name.

• Using a linking table.

• Using a primary key in Student and a foreign key in StudentSubject.

• They are not related.

What does 1NF state about attributes within a table?

• They must be numerical.

• They can be partially dependent on the primary key.

• They must be atomic and contain no repeating groups.

• They must be dependent on the whole primary key.

A table is in 2NF if it fulfills which conditions?

• It is in 3NF and contains no non-key dependencies.

• It contains no repeating attributes or groups of attributes.

• It is in 1NF and contains no partial dependencies.

• It has a composite primary key.

In a relational database, how is data organized?

• As a hierarchical tree structure.

• In a network of interconnected nodes.

• In tables with rows and columns.

• As a flat file.

What does one row in a database table represent?

• An attribute

• A relationship

• A record

• An entity

What is the purpose of normalization in database design?

• To make the database visually appealing.

• To reduce the complexity of SQL queries.

• To organize tables and minimize data duplication.

• To ensure compatibility with various database management systems.