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
Object Oriented model :An object has values stored in instance variables within the object. An object also has bodies of code that execute on the object. These bodies of code are

It can be easily defined as: The database must not have any unmatched foreign key values. The term "unmatched foreign key value" means a foreign key value for which there doe

Change the city of First Bank Corporation to ‘New Delhi' UPDATE COMPANY SET CITY = ‘New Delhi' WHERE COMPANY_NAME = ‘First Bank Corporation';

Data independence seems that "the application is independent of the access strategy and storage structure of data". In other words, the ability to change the schema definition in o

What is the used of specifying alias? Specifying alias: is used to rename column or attribute in a table.

Explain the two types of participation constraint. 1. Total: The participation of an entity set E in a relationship set R is said to be total if each entity in E participates i


Explain how the associations are implemented as classes. A general approach in this case is to transform an association class into a simple class linked to two original classes

Secondary Indexes Let consider the student database and its clustering index and primary (only one will be applicable at a time). Now consider the state when the database is to

Describe the shadow paging technique.