Advanced Database Management System - Tutorials and Notes: Normalization - Solved exercises Home

Search Engine

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

  Normalization

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