Which type of dependency does Third Normal Form (3NF) aim to eliminate?
Join dependency
Multi-valued dependency
Partial dependency
Transitive dependency
Why is data redundancy undesirable in a database?
It increases storage space requirements
All of the above
It complicates data retrieval and manipulation
It can lead to data inconsistencies and anomalies
What is the role of cardinality in an ER diagram?
It determines the primary key of an entity
It indicates the number of instances of one entity that can be associated with instances of another entity
It defines the data type of an attribute
It specifies the name of the relationship between entities
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
Two lines connecting two entities
A single line connecting two entities
Which of the following best describes a partial dependency in a database table?
A non-key attribute is dependent on another non-key attribute
A foreign key is dependent on the primary key of the same table
A non-key attribute is dependent on only part of a composite primary key
A primary key is dependent on a foreign key
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
Contains highly transactional data
Focuses on storing calculated metrics
Which of these is crucial to consider when choosing data types for columns?
The type of storage device used by the database server.
The username of the person creating the table.
The kind of data the column will store and its expected size.
The color scheme of the user interface.
What type of relationship typically exists between a fact table and a dimension table in a Star Schema?
Many-to-many
One-to-many
One-to-one
Many-to-one
A Foreign Key in a database is used to...
Create a primary key for a related table.
Define a new data type for a column.
Enforce data validation rules on a column.
Establish a link between two tables based on a common column.
You have a table with columns for StudentID, StudentName, CourseID, and CourseName. StudentID determines StudentName, and CourseID determines CourseName. What normal form is this table in?
First Normal Form (1NF)
Third Normal Form (3NF)
Second Normal Form (2NF)
None of the above