Tuesday, 13 January 2015

Normalization - Solved exercises


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










CREATE TABLE statement in Oracle SQL with CHECK constraints

CREATE TABLE statement in Oracle SQL with CHECK constraints with CHECK constraint Syntax: CREATE TABLE < tablename> (...