What is the primary purpose of a Primary Key in a database table?
To ensure that all columns in the table have a value.
To define the order in which data is stored.
To uniquely identify each row within the table.
To establish a relationship with another table.
How is a one-to-many relationship represented in an ER diagram?
A line with a crow's foot symbol on one end and a single line on the other
A diamond connecting two entities
A single line connecting two entities
Two lines connecting two entities
In which scenario might denormalization be considered acceptable in database design?
To enforce strict data integrity
To simplify the database schema
To improve query performance by reducing joins
To increase data redundancy
Which of the following is a characteristic of a Dimension table in a Star Schema?
Focuses on storing calculated metrics
Typically has a small number of rows
Provides descriptive attributes about business entities
Contains highly transactional data
Which of these is crucial to consider when choosing data types for columns?
The kind of data the column will store and its expected size.
The type of storage device used by the database server.
The username of the person creating the table.
The color scheme of the user interface.
When converting an ER diagram to a database schema, what does an entity typically become?
A table
A database
A row
A column
What is the role of cardinality in an ER diagram?
It defines the data type of an attribute
It determines the primary key of an entity
It specifies the name of the relationship between entities
It indicates the number of instances of one entity that can be associated with instances of another entity
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)
First Normal Form (1NF)
Second Normal Form (2NF)
None of the above
What is the role of a column in a database table?
To define a row in the table.
To represent a specific attribute or characteristic of an entity.
To link the table to another table.
To store the entire dataset of the table.
In a Star Schema, what is the central table called that contains the key performance indicators (KPIs)?
Dimension Table
Entity Table
Lookup Table
Fact Table