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
Write short notes on transaction state? A transaction may not always complete its implementation successfully such a transaction is termed aborted A transaction must be in o

Describe five main functions of a database administrator. Ans: A database administrator (DBA) is a person who is accountable for the environmental aspects of a database. Genera

Express the subsequent query in SQL assumes which the data is stored within EMPLOYEE table with relevant fields (i) Display name, job, salary, and hire date of employee who are

What is Cardinality Ratio? Cardinality Ratios - The cardinality ratios for relationship kinds specifies the maximum number of relationship instances in which an entity can pa

Consider the relations City (city_name, state) Hotel (name, address) City_hotel (hotel_name, city_name, owner) Answer the following queries in relational algebra (i) Find

Serialisability: Any schedule that makes the similar results as a serial schedule is known as a serialisable schedule. But how can a schedule are determined to be serialisable or n

What is meant by the degree of relationship set? The degree of relationship type is the number of participating entity types.

Database Recovery And Security Introduction In this part we will introduce two main issues relating to database management systems. A computer system suffers from dissi

a method named WonGame that checks each letter in the word is matched by its label

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4