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 11
Applied Normalization and Design Synthesis
1
Normalizing to 3NF
Given an unnormalized table and its functional dependencies, perform normalization to achieve a set of 3NF tables.
2
Linking 3NF Tables: Identifying Primary and Foreign Keys
Identify the primary and foreign keys required to link the resulting set of 3NF tables.
3
Database Normalization Analysis
Analyze a set of tables to determine their level of normalization (1NF, 2NF, or 3NF) and justify the assessment.
4
Designing 3NF ERDs
Construct a complete ERD that represents a database schema after normalization to 3NF.
End of course,
Back to course
Previous module
Third Normal Form (3NF)
Next module