What type of relationship typically exists between a fact table and a dimension table in a Star Schema?
Many-to-one
Many-to-many
One-to-many
One-to-one
Which type of dependency does Third Normal Form (3NF) aim to eliminate?
Partial dependency
Transitive dependency
Join dependency
Multi-valued dependency
What is the role of cardinality in an ER diagram?
It indicates the number of instances of one entity that can be associated with instances of another entity
It specifies the name of the relationship between entities
It defines the data type of an attribute
It determines the primary key of an entity
What potential drawback might arise from over-normalizing a database?
Increased data redundancy
Increased difficulty in data retrieval and updates
Improved data integrity
Reduced query complexity
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 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.
It prevents deletion of records in the parent table if there are matching records in the child table.
Why is data redundancy undesirable in a database?
It complicates data retrieval and manipulation
All of the above
It can lead to data inconsistencies and anomalies
It increases storage space requirements
Which of the following is a characteristic of a Dimension table in a Star Schema?
Typically has a small number of rows
Provides descriptive attributes about business entities
Focuses on storing calculated metrics
Contains highly transactional data
In a database table, what does a 'row' represent?
A unique record or instance within the table.
A relationship between two different tables.
A column header describing the data type.
A specific attribute or characteristic of an entity.
What element in an ER diagram describes the properties or characteristics of an entity?
Entity
Attribute
Cardinality
Relationship
What is the PRIMARY purpose of using indexes in a database?
To enforce data integrity constraints
To improve data security
To speed up data retrieval operations
To reduce disk space consumption