What is the primary purpose of a Primary Key in a database table?
To uniquely identify each row within the table.
To ensure that all columns in the table have a value.
To define the order in which data is stored.
To establish a relationship with another table.
When converting an ER diagram to a database schema, what does an entity typically become?
A column
A row
A database
A table
In a table with a composite key, a non-key attribute depends on only one part of the key. Which normal form is violated?
Third Normal Form (3NF)
None of the above
Second Normal Form (2NF)
First Normal Form (1NF)
Which of the following relationships is typically NOT implemented directly in a database but is often represented using an intermediary table?
One-to-One
One-to-Many
All of the above
Many-to-Many
What is the role of a column in a database 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.
To define a row in the table.
Why is data redundancy undesirable in a database?
It can lead to data inconsistencies and anomalies
It complicates data retrieval and manipulation
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
Focuses on storing calculated metrics
Contains highly transactional data
Provides descriptive attributes about business entities
Which normal form acts as the foundation for higher levels of normalization?
Boyce-Codd Normal Form (BCNF)
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 determines the primary key of an entity
It defines the data type of an attribute
It specifies the name of the relationship between entities
What is the process of ensuring that data across related tables remains consistent and synchronized called?
Data Integrity
Data Warehousing
Data Validation
Data Normalization