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 are the purposes of dbms in details

Describe different steps of the object-oriented design process.  The broad steps of the object-oriented design process are: a. Define context and modes of use of the system

Synonyms and Indexes Some of the essential properties of indexes are: An Index is a schema Object Indexes can be formed explicitly or automatically Indexes are m

Benefits of Hashed file Organisation 1.      Insertion or search on hash-key is quick. 2.      Best if equality search is required on hash-key. Drawbacks of Hashed file

Define Shared locks? Ans: Shared lock: Throughout concurrent execution of transactions, earlier than a transaction can access a data item, it has to obtain a lock on it. Now he

An important first step to the statistical analysis of data is to "get to know your data".  The following tasks should contribute to this. (a)   To the right of the dataset cons

A distributed transaction consists of subtransactions that execute at different sites and access local DBMSs at those sites. For example, a distributed transaction that transfers m

What is called query processing? Query processing refers to the range of activities included in extracting data from a database.

differences between a classified catalog and a dictionary catalog

What is Enterprise Resource Planning (ERP), and what kind of a database is used in an ERP application? Enterprise Resource Planning (ERP) is an information system used in manuf