What potential drawback might arise from over-normalizing a database?
Increased difficulty in data retrieval and updates
Improved data integrity
Increased data redundancy
Reduced query complexity
Why is defining a clear and well-structured schema important in database design?
It eliminates the need for using SQL queries.
It simplifies data management, improves data integrity, and enhances query efficiency.
It automates the process of data entry.
It makes the database look visually appealing.
What does the 'ON DELETE CASCADE' constraint do?
It sets the foreign key values in the child table to NULL when a record in the parent table is deleted.
It prevents deletion of records in the parent table if there are matching records in the child table.
It has no impact on the child table when a record in the parent table is deleted.
It automatically deletes matching records in the child table when a record in the parent table is deleted.
In a database table, what does a 'row' represent?
A column header describing the data type.
A specific attribute or characteristic of an entity.
A relationship between two different tables.
A unique record or instance within the table.
Which data validation technique prevents invalid data from being entered into the database by checking it against predefined rules?
Data Transformation
Data Masking
Check Constraints
Data Scrubbing
What is a potential drawback of using a Snowflake Schema compared to a Star Schema?
Slower query performance due to denormalization
Limited ability to model complex relationships
More complex queries due to normalization
In which scenario might denormalization be considered acceptable in database design?
To improve query performance by reducing joins
To increase data redundancy
To simplify the database schema
To enforce strict data integrity
Which of the following is NOT a good practice when designing a simple schema for a single entity?
Choosing appropriate data types for columns
Defining primary keys to uniquely identify each row
Storing redundant data in multiple columns
Using descriptive names for tables and columns
What is the primary benefit of using cascading actions in database design?
Simplified data manipulation
Reduced storage space
Improved query performance
Enhanced security
Which type of dependency does Third Normal Form (3NF) aim to eliminate?
Multi-valued dependency
Transitive dependency
Join dependency
Partial dependency