What is the role of a column in a database table?
To define a row in the table.
To link the table to another table.
To represent a specific attribute or characteristic of an entity.
To store the entire dataset of the table.
What is the primary goal of database normalization?
Enhancing data security
Improving query performance
Reducing data redundancy and anomalies
Minimizing storage space
In which scenario might a Snowflake Schema be preferred over a Star Schema?
When data integrity is critical, and redundancy needs to be minimized
When query performance is the top priority
When storage space is a major concern
When dealing with small datasets
Why is defining a clear and well-structured schema important in database design?
It eliminates the need for using SQL queries.
It automates the process of data entry.
It makes the database look visually appealing.
It simplifies data management, improves data integrity, and enhances query efficiency.
What is the primary purpose of a Primary Key in a database table?
To define the order in which data is stored.
To ensure that all columns in the table have a value.
To establish a relationship with another table.
To uniquely identify each row within the table.
When converting an ER diagram to a database schema, what does an entity typically become?
A database
A column
A row
A table
What potential drawback might arise from over-normalizing a database?
Reduced query complexity
Increased difficulty in data retrieval and updates
Increased data redundancy
Improved data integrity
In a normalized database, what is the typical relationship between tables?
Tables are organized alphabetically
Tables are completely independent
One table contains all the data, while others are empty
Tables are connected through foreign keys
In which scenario might denormalization be considered acceptable in database design?
To increase data redundancy
To improve query performance by reducing joins
To enforce strict data integrity
To simplify the database schema
What element in an ER diagram describes the properties or characteristics of an entity?
Relationship
Cardinality
Attribute
Entity