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 identification

Primary key identification

Normalization

Find the functional dependencies that violate a normal form

Normalization Solved Questions












2 comments:

  1. Normalize the following table. Show all work and clearly indicate the primary and foreign
    keys.
    R(elevator_no,building_no,building_name,capacity, staff_no, first_name, last_name,
    date_examined)
    Functional Dependencies:
    1. elevator_no  building_no,capacity
    2. building_no building_name
    3. staff_no first_name,last_name
    4. elevator_no,staff_no date_examined
    Normalize table R up to BCNF

    ReplyDelete
    Replies
    1. Your question is solved and available here - http://www.exploredatabase.com/2017/02/normalization-solved-exercise-bcnf-1.html

      Delete