Which of the following is a characteristic of a Dimension table in a Star Schema?
Provides descriptive attributes about business entities
Focuses on storing calculated metrics
Contains highly transactional data
Typically has a small number of rows
Which SQL keyword is used to establish a relationship between two entities by referencing the primary key of one table in another table?
FOREIGN KEY
JOIN
RELATIONSHIP
PRIMARY KEY
Which type of dependency does Third Normal Form (3NF) aim to eliminate?
Partial dependency
Multi-valued dependency
Transitive dependency
Join dependency
What is the process of ensuring that data across related tables remains consistent and synchronized called?
Data Warehousing
Data Validation
Data Integrity
Data Normalization
When converting an ER diagram to a database schema, what does an entity typically become?
A database
A column
A table
A row
Which of the following is NOT a characteristic of a table in First Normal Form (1NF)?
A primary key uniquely identifies each row
The table contains a foreign key referencing another table
Each column contains atomic values
There are no repeating groups of columns
You are designing a schema to represent a relationship between 'Students' and 'Courses'. What type of relationship best describes this scenario?
Many-to-one
One-to-one
One-to-many
Many-to-many
In a Star Schema, what is the central table called that contains the key performance indicators (KPIs)?
Fact Table
Dimension Table
Lookup Table
Entity Table
What element in an ER diagram describes the properties or characteristics of an entity?
Entity
Attribute
Relationship
Cardinality
What does the 'ON DELETE CASCADE' constraint do?
It automatically deletes matching records in the child table 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 prevents deletion of records in the parent table if there are matching records in the child table.
It sets the foreign key values in the child table to NULL when a record in the parent table is deleted.