Test Cases for Normalization Algorithms


Relation 1:

R = CGHRST

F = { C --> T , CS --> G , HR --> C , HS --> R , HT --> R }


Relation 2:

Address, Course, Department, Grade, Hour, Level, Name, Phone, Room, STudent-id, Teacher, Units

R = ACDGHLNPRSTU

F = { C --> TU , S --> NAP , T --> LD , CS --> G , CS --> G , HS --> R , HT --> R }


Relation 3:

R = ABCDE

F = { AB --> C , CD --> B , BC --> E }


Relation 4:

R = ABCDEG

F = { CD --> B , BE --> A }


Relation 5:

Create your own test case4.