Database Design and Normalization Quiz

What is the main objective of database design in DBMS?

• To create user interfaces

• To produce logical and physical design models

• To manage network security

• To develop software applications

Which model is concerned with developing a database model based on requirements?

• Physical model

• Relational model

• Conceptual model

• Logical model

What does normalization aim to minimize in a database?

• Data retrieval time

• Data complexity

• Data security

• Data redundancy

Which normal form requires that all non-key attributes are fully functional dependent on the primary key?

• 1NF

• 3NF

• 2NF

• BCNF

What is a trivial functional dependency?

• When there is no dependency

• When the dependent is a subset of the determinant

• When the dependent is not a subset of the determinant

• When there are multiple dependencies

Which of the following is a feature of a physical data model?

• Does not include foreign keys

• Focuses on user requirements

• Only includes primary keys

• Specifies all the columns and tables

What is the main purpose of functional dependencies in DBMS?

• To maintain data quality

• To establish relationships between tables

• To enhance application performance

• To improve user interface design

Which normal form is known as Boyce Codd's normal form?

• 3NF

• BCNF

• 2NF

• 1NF

What does a multivalued functional dependency indicate?

• There are no dependencies

• Multiple values of one attribute exist independently

• One attribute depends on another

• All attributes are dependent on the primary key

Which of the following is NOT an advantage of normalization?

• Enhances database organization

• Increases data consistency

• Minimizes data redundancy

• Improves performance in all cases