What is the primary benefit of using cascading actions in database design?
Improved query performance
Simplified data manipulation
Enhanced security
Reduced storage space
What issue does Third Normal Form (3NF) primarily address?
Repeating groups of data
Lack of a primary key
Transitive dependencies between non-key attributes
Partial dependencies on the primary key
In which scenario might denormalization be considered acceptable in database design?
To enforce strict data integrity
To simplify the database schema
To increase data redundancy
To improve query performance by reducing joins
Which of the following best describes a partial dependency in a database table?
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 non-key attribute is dependent on another non-key attribute
A primary key is dependent on a foreign key
Which of the following best illustrates a table violating First Normal Form (1NF)?
A "Customer" table with columns for CustomerID, Name, and Address
An "Employee" table with EmployeeID as the primary key
An "Order" table with an OrderID and separate columns for each item ordered (e.g., Item1, Item2, Item3)
A "Product" table with a ProductID, Name, and Price
Which statement is TRUE regarding the different normal forms?
Normalization guarantees perfect database design
2NF automatically implies 3NF
A table in 3NF is also automatically in 2NF and 1NF
1NF is the most desirable normal form for all databases
Which normal form acts as the foundation for higher levels of normalization?
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce-Codd Normal Form (BCNF)
First Normal Form (1NF)
What potential drawback might arise from over-normalizing a database?
Increased difficulty in data retrieval and updates
Increased data redundancy
Improved data integrity
Reduced query complexity
What is the primary difference between a Star Schema and a Snowflake Schema?
Star Schemas are used for real-time analytics.
Snowflake Schemas don't use fact tables.
Star Schemas have more joins.
Snowflake Schemas normalize dimension tables.
What SQL statement is used to add a new column to an existing table?
ADD COLUMN
ALTER TABLE
UPDATE TABLE
MODIFY TABLE