Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Database Systems Management
·
Module 9
Second Normal Form (2NF)
1
Understanding Partial Dependencies
Define partial dependency and identify partial dependencies in a table with a composite primary key.
2
Second Normal Form (2NF) Requirements
State the requirements for a table to be in Second Normal Form (2NF).
3
Identifying 2NF Violations
Identify violations of 2NF in a given table.
4
Achieving 2NF: Eliminating Partial Dependencies
Convert a 1NF table into 2NF by removing partial dependencies into separate tables.
Previous module
Introduction to Normalization
Next module
Third Normal Form (3NF)