Database Normalization: 3 NF
Not what you're looking for?
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.
Purchase this Solution
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.
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 ...
Purchase this Solution
Free BrainMass Quizzes
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Javscript Basics
Quiz on basics of javascript programming language.