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
Convert the following ER - diagram (Entity Relationship Diagram) into a relational database (the primary keys are underlined):       Ans:  The relational database schema f

What are domain constraints?  A  domain is  a  set  of  values  that  might  be  assigned to an attribute  .all  values that appear in a  column of a relation must be taken fro

Explain the term High level DML? High level DML A high-level or non-procedural DML permit the user to specify what data is needed without specifying how it is to be acquired.

as a customer service employee, explain five measures you would recommend a displeased student to patronise a school canteen

What Is Sql?  Structured Query Language (SQL) is a standard query language. It is usually used with all relational databases for data manipulation and definition. All the re

How persistent programming languages differ from traditional programming languages? Database languages vary from traditional programming languages in that they directly manipul

In the first unit of this block, you have been given with the details of the Database Management System, its structure, advantages etc. This unit is an attempt to give you informat

Given the following relations TRAIN (NAME, START, DEST) TICKET (PNRNO., START, DEST, FARE) PASSENGER (NAME, ADDRESS, PNRNO.) Write SQL expressions for the following queries: No

Define union compatibility? Explain why INTERSECTION of two relations cannot be performed if they are not union compatible? Two relations R(A1, A2,-------, An) and S(B1, B2,--

Differentiate between Key and superkey? Key and superkey - A key a single attribute or a combination of two or more attributes of an entity set in which is used to identify o