Eliminate columns not dependent on key, Database Management System

Eliminate Columns Not Dependent On Key

The Employee Relation satisfies -

First normal form - As it has no repeating groups.

Second normal form - As it do not have multi-attribute key.

The employee relation is in 2NF but not 3NF. So we take this table only later than adding the required attributes.

 

Employee Relation

Emp-ID

Emp-Name

Department

Department-Loc

1

Gurpreet Malhotra

A

N-Delhi

2

Faisal Khan

A

N-Delhi

3

Manisha Kukreja

B

Agra

4

Sameer Singh

C

Mumbai

The key is Emp-ID, and the Dept-Name and location defines only about Department, not an Employee. To get the third normal form, they must be moved into a individual relation. Since they define a department, therefore the attribute Department becomes the key of the new "Department" relation.

The motivation for this is the similar for the second normal form: we want not to use or avoid update, insertion and deletion anomalies.;

Department-Relation

Dept-ID

Department

Department Loc

1

A

N-Delhi

2

B

Agra

3

C

Mumbai

 

Employee-List

Emp-ID

Emp-Name

1

Gurpreet Malhotra

2

Faisal Khan

3

Manisha Kukreja

4

Sameer Singh

The rest of the Relation remains similar.

The last two steps: Isolate Semantically Related Multiple Relationships and Isolate Independent Multiple Relationships, changes the relations to higher normal form and are thus not discussed here. They are not even needed for the current example.

Posted Date: 3/7/2013 2:33:42 AM | Location : United States







Related Discussions:- Eliminate columns not dependent on key, Assignment Help, Ask Question on Eliminate columns not dependent on key, Get Answer, Expert's Help, Eliminate columns not dependent on key Discussions

Write discussion on Eliminate columns not dependent on key
Your posts are moderated
Related Questions
What is the difference between SQL Server 2000 complete and differential backups? A complete backup makes a copy of the whole database. A differential backup creates a copy of

Command Line Interfaces: These are interactive interfaces, character-based that let you use the complete power and functionality of the DBMS query language directly. They permit yo

Define canonical cover? A canonical cover Fc for F is a set of dependencies like F logically implies all dependencies in FC and Fc logically shows all dependencies in F.

Demonstrate the UML model Using UML, it is possible to generate code in any of the programming language from UML model (called forward engineering) and rebuild a model from an

Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department.

Index And Tree Structure Let us talk about the data structure that is used for creating indexes. Can we use Binary Search Tree (BST) as Indexes? Let us initial reconsider

What is an object ID? Each class-derived table has an ID for primary key, one or more object IDs form primary key for association derived tables. An object ID is equivalent dat

Differentiate between strict two-phase and rigorous two-phase with conversion protocol Ans:  Strict two-phase locking holds all its exclusive that is write locks until commit t

Explain Domain calculus Domain calculus is one of the types of the relational calculus. The formal specification of the domain calculus was planned after the development of the

Define the terms 1) physical schema 2) logical schema. Physical schema: The physical schema explains the database design at the physical level, which is the lowest level of abs