WorksheetsDatabase Design and Normalization Quiz
Total questions: 30
Worksheet time: 15mins
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
What is the first step in achieving the first normal form (1NF)?
Ensure all attributes are single-valued
Create foreign keys
Normalize to 2NF
Establish primary keys
Which type of dependency is characterized by indirect dependency?
Multivalued dependency
Trivial dependency
Non-trivial dependency
Transitive dependency
What is a lossless-join decomposition?
A way to simplify database queries
A technique to combine multiple databases
A method to ensure no information is lost during decomposition
A process that loses data during decomposition
Which of the following describes a decentralized design approach?
Multiple teams work on different modules
One person designs the entire database
Only one module is verified
All data is stored in a single location
What is the main focus of database design?
Software application development
User interface development
Data management and relationships
Network security
What is the primary goal of using a conceptual data model?
To enforce data integrity constraints
To optimize query performance
To represent the data requirements and relationships
To define the physical storage of data
Which of the following is a characteristic of a relational database?
Data is organized in tables with rows and columns
Data relationships are defined by physical storage
Data is stored in flat files
Data is stored in hierarchical format
What is the purpose of a primary key in a database?
To improve query performance
To enforce data integrity
To establish relationships between tables
To uniquely identify each record in a table
What is the purpose of a foreign key in a relational database?
To improve data retrieval speed
To uniquely identify each record in a table
To establish a link between two tables
To enforce data integrity within a single table
Which of the following is a disadvantage of normalization?
Increases data redundancy
Can lead to complex queries
Improves data integrity
Enhances database performance
What is the primary benefit of using a surrogate key in a database?
It ensures data integrity
It improves data retrieval speed
It simplifies relationships between tables
It is always a natural key
Which of the following best describes a composite key?
A key that is unique to a single table
A key that is used only for indexing
A key that is generated automatically
A key that consists of multiple attributes
What is the purpose of indexing in a database?
To create relationships between tables
To speed up data retrieval operations
To normalize the database structure
To enforce data integrity
Which of the following is a characteristic of a well-designed database schema?
Multiple primary keys in a table
Clear relationships between entities
Complex data retrieval processes
Redundant data storage
What does the term 'referential integrity' mean in the context of databases?
Allowing duplicate records in a table
Improving the performance of data retrieval
Ensuring that all foreign keys point to valid records
Maintaining data consistency across multiple tables
What is the role of an index in a database?
To store large amounts of data
To enforce data integrity
To speed up data retrieval
To create relationships between tables
Which of the following is a benefit of using a relational database?
Data is stored in a flat file
Supports complex queries
Data redundancy is increased
Data is not easily accessible
What does the term 'data normalization' primarily aim to achieve?
To reduce data anomalies
To increase data redundancy
To enhance data security
To simplify data retrieval
What is the main advantage of using a composite key in a database?
It simplifies data retrieval
It allows for unique identification of records across multiple attributes
It enhances data redundancy
It reduces the need for foreign keys
Which of the following best describes a foreign key?
A key that is used for indexing purposes only
A key that is automatically generated by the database
A key that links two tables together
A key that uniquely identifies a record in a table
