Share
Explore BrainMass

Database Normalization: 3 NF

For each of the following relations, indicate the normal form of the relation. Put each relation in the 3NF.

a. COURSE (course_id, lab_id, equipment_type), primary key = {course_id,
lab_id}.

b. COURSE (course_id, lab_id, equipment_type, software_type), primary key =
{course_id, Lab_id}, equipment_type-> software_type.

c. COURSE (course_id, lab_id, course_title, equipment_type, software_type),
primary key = {course_id, lab_id}, Course_id->course_title,
equipment_type->software_type.

Solution Preview

a. COURSE (course_id, lab_id, equipment_type), primary key = {course_id, lab_id}.

Relation Schema a) is in 3 NF. It doesn't need any changes

b. COURSE (course_id, lab_id, equipment_type, software_type), primary key =
{course_id, Lab_id}, equipment_type-> software_type.

Relation Schema b) is only in 2NF. because according to 3NF all relations should be with primary key but here the relation equipment_type-> software_type is among two NON-KEY attributes so it only in 2NF but not in 3 NF.
This can be brought into 3 ...

Solution Summary

Solution clearly explains the process of Database Normalization using an example, it explains the process to Noramlize a schema into 3 NF (Third Normal Form), that is it explains requirements for 1 NF, 2 NF as well.

$2.19