Advanced Database Management System - Tutorials and Notes: Normalization - Solved exercises Home
Please visit, subscribe and share 10 Minutes Lectures in Computer Science

Tuesday, 13 January 2015

Normalization - Solved exercises Home

Set of solved exercises in Normalization / Normalization Solved Examples / How to find candidate keys, and primary keys in database? / Sets of examples to find the keys of a tables / Process of finding Key in a database - Examples

INSERT, DELETE, MODIFY Anomalies Identification

Primary key / Candidate key identification

 Primary key / Candidate key identification


Find the functional dependencies that violate a normal form

Normalization Solved Questions

Decomposition - Lossy or lossless

Equivalent Functional Dependencies

normalization solved exercises

how to normalize a relation to second normal form (2nf)
how to normalize a relation to third normal form (3nf)
how to normalize a relation to Boyce-code normal form (BCNF)
find minimal cover
find canonical cover
lossless and lossy join decomposition
find candidate keys and super keys
what is candidate key
find functional dependencies
transitive functional dependency
armstrong's axioms

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents