Which type of dependency does Third Normal Form (3NF) aim to eliminate?
Multi-valued dependency
Partial dependency
Transitive dependency
Join dependency
What is the primary difference between a Star Schema and a Snowflake Schema?
Snowflake Schemas don't use fact tables.
Star Schemas are used for real-time analytics.
Snowflake Schemas normalize dimension tables.
Star Schemas have more joins.
When designing a schema for a library, what is the most appropriate primary key for the 'Books' table?
Book Title
ISBN
Publication Year
Author Name
Which statement is TRUE regarding the different normal forms?
1NF is the most desirable normal form for all databases
Normalization guarantees perfect database design
A table in 3NF is also automatically in 2NF and 1NF
2NF automatically implies 3NF
Which of the following is NOT a valid action for cascading actions in SQL?
ON UPDATE CASCADE
ON SELECT CASCADE
ON INSERT CASCADE
ON DELETE CASCADE
Which of the following is a key benefit of using a well-designed schema for a data warehouse?
Reduced need for data modeling and analysis
Increased data redundancy for backups
Improved query performance and efficiency
Simplified data loading from various sources
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?
Second Normal Form (2NF)
Third Normal Form (3NF)
None of the above
First Normal Form (1NF)
Which of the following best illustrates a table violating First Normal Form (1NF)?
An "Employee" table with EmployeeID as the primary key
A "Product" table with a ProductID, Name, and Price
An "Order" table with an OrderID and separate columns for each item ordered (e.g., Item1, Item2, Item3)
A "Customer" table with columns for CustomerID, Name, and Address
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
PRIMARY KEY
RELATIONSHIP
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 color scheme of the user interface.
The username of the person creating the table.