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
Differentiate between join and outer join? Outer joins return all rows from at least one of the tables or views mentioned within the FROM clause, as long as those rows get toge

Q.  Define a weak entity set and its identifying relationship. List the necessary conditions for a meaningful identifying relationship set of a weak entity set.    Entity is a t

Consider the following relational schema: Doctor(DName,Reg_no) Patient(Pname, Disease) Assigned_To (Pname,Dname) Give expression in both Tuple calculus and Domain calculus for

i need to submit in this topic.

Create centralized relational database using Top down method- Construction of Logical Model: Translation EERD into Relational Schema: Use the 8 steps algorithm of converting EERD

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,

Explain in detail about Collaboration Diagrams Collaboration diagrams are interaction diagrams which emphasize structural organisation of an object that transmit and receive m

Explain the Cartesian product:  The Cartesian product operation does not need relations to union-compatible.  The meaning of this is that the involved relations may have dissim

The Transactions- A transaction is definite as the unit of work in a database system. Database systems that deal with a huge number of transactions are also termed as transaction p

What is Nested Trigger? A trigger can also having INSERT, UPDATE and DELETE logic within itself, so when the trigger is fired because of data modification it can also cause ano