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
In E-R Diagram how relationship type is represented ? In E-R Diagram relationship type is represented as a Diamond.

What disadvantage of ODBC does OLE DB overcome? By breaking the features and the methods of a DBMS into COM objects, OLE DB characteristic overcomes a main disadvantage of ODBC

How does a query tree represent a relational algebra expression?  Discuss any three rules for query optimisation, giving example as to when should each rule be applied.     Ans

what problems are raised by the database? why is it so controversial? why is data quality an issue?

A relationship set is a set of relationships of the similar type. For example, let consider the relationship among two entities sets course and student. Collection of all the in

Saving Derived Attributes to Avoid Re-computation   As discussed, "redundancy means duplication of exact data". But, if multiple copies of same data are present in the system,

client server architeutre

Sequences Sequences: Automatically produce unique numbers Are sharable Are typically used to make a primary key value Replace application code Speed up t

The JOIN operation is applied on two relations. When we want to choose related tuples from two given relation join is used. The join operation need that both the joined relations m

intent locking