What is the highest normal form of the table - normalization, Database Management System

In problems 1 - 4, you are given the columns of a table, and a set of functional dependencies.  Determine the normal form of this table.  Remember that the normal form is the HIGHEST normal form for the table (e.g. if a table is in both 1st NF and 2nd NF, then what you report is 2nd NF).  Always start by identifying the candidate keys.

1. What is the highest normal form of the table with columns
                                    A B C D E
            and the following functional dependencies?

A → B

B → A C D E

2.   What is the highest normal form of the table with columns
                        M N O P Q R S T
            and the following functional dependencies?

N → O

P → M N Q R

Q→S T

3.  What is the highest normal form of the table with columns
                        A B C D E F G
            and the following functional dependencies?

A E → D

D → C G

E → B F

4.   What is the highest normal form of the table with columns
                        A B C D E F G H
            and the following functional dependencies?

A → H

B → A C D E F

Posted Date: 3/29/2013 2:20:05 AM | Location : United States







Related Discussions:- What is the highest normal form of the table - normalization, Assignment Help, Ask Question on What is the highest normal form of the table - normalization, Get Answer, Expert's Help, What is the highest normal form of the table - normalization Discussions

Write discussion on What is the highest normal form of the table - normalization
Your posts are moderated
Related Questions
What is the use of keyword ISA? The use of keyword ISA is to show that a class is a specialization of another class.

What are referential integrity constraints? A value that appears in single relation for a given set of attributes also appears for a particular set of attributes in another rel

Discuss the types of integrity constraints in which must be checked for the update operations - Insert and Delete. Give examples. Insert operation can violet any of the subse

I need help with data warehousing and business intelligence course project about designing a data warehouse for a jewelry company that does not have one

Sequences Sequences: Automatically produce unique numbers Are sharable Are typically used to make a primary key value Replace application code Speed up t

Fifth Normal Form (5NF) These relations still have a difficulty. While defining the 4NF we mentioned that all the attributes depend upon each other. Whereas creating the two ta

Benefits of Sequential File Organisation It is quick and efficient when dealing with huge volumes of data that require being processed periodically (batch system). Dra

Define the terms i) Entity set ii) Relationship set Entity set: The set of all entities of the similar type is termed as an entity set. Relationship set: The set of all rela

What is Relational DBMS This is our subject of study. A DBMS is relational if the data is organized into relations, that is, tables. In RDBMS, all data are kept in the well-kno

What are temporary tables? Temporary tables exist solely for a particular session or whose data persists for the duration of the transaction.