What is the main advantage of achieving higher normal forms in database design?
Slower query processing
Increased data redundancy
Improved data integrity and reduced anomalies
More complex database structure
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?
Third Normal Form (3NF)
First Normal Form (1NF)
Second Normal Form (2NF)
None of the above
What SQL statement is used to add a new column to an existing table?
UPDATE TABLE
ADD COLUMN
MODIFY TABLE
ALTER TABLE
Which type of dependency does Third Normal Form (3NF) aim to eliminate?
Multi-valued dependency
Partial dependency
Join dependency
Transitive dependency
Which statement is TRUE regarding the different normal forms?
2NF automatically implies 3NF
Normalization guarantees perfect database design
1NF is the most desirable normal form for all databases
A table in 3NF is also automatically in 2NF and 1NF
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
What is the primary difference between a Star Schema and a Snowflake Schema?
Star Schemas have more joins.
Snowflake Schemas don't use fact tables.
Star Schemas are used for real-time analytics.
Snowflake Schemas normalize dimension tables.
A table has a composite primary key (using two columns). What condition must be met for it to be considered in Second Normal Form (2NF)?
No non-key attribute should be dependent on only part of the primary key
It must already be in 1NF
It must have no transitive dependencies
All columns must have unique values
In a normalized database, what is the typical relationship between tables?
Tables are completely independent
Tables are organized alphabetically
Tables are connected through foreign keys
One table contains all the data, while others are empty
In which scenario might denormalization be considered acceptable in database design?
To enforce strict data integrity
To improve query performance by reducing joins
To simplify the database schema
To increase data redundancy