Eliminate columns not dependent on key, Database Management System

Assignment Help:

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.


Related Discussions:- Eliminate columns not dependent on key

What is the use of integrity constraints, What is the use of integrity cons...

What is the use of integrity constraints? Integrity constraints make sure that changes made to the database by authorized users do not result in a loss of data consistency. The

Which model is record based logical model, Which model is record based logi...

Which model is record based logical model? Network Modelis basically known as record based logical model.

Using literal character string-data manipulation language, Using Literal Ch...

Using Literal Character String Example: To print IS A as one string with column name employee SELECT ENAME || ' IS A ' || JOB AS "EMPLOYEE" FROM EMP;

What is a candidate key, What is a candidate key? Minimal super keys ar...

What is a candidate key? Minimal super keys are known as candidate keys.

Availability-data replication, Availability: A site having the copy of a r...

Availability: A site having the copy of a replicated relation fails, even then the relation may be found in another site. Therefore, the system may carry on to process at least th

Define the traditional system analysis and design, Define the Traditional S...

Define the Traditional System Analysis and Design Traditional System Analysis and Design (SAD) have three basic life cycle models. A typical software lifecycle consists of the

Illustrate the cardinality of relationship, Cardinality of Relationship ...

Cardinality of Relationship One-to-One Only one entity of the first set is linked to only one entity of the second set. E.g. A teacher teaches a student. Only one teacher

Which data manipulation command combines the records, Which data manipulati...

Which data manipulation command combines the records from one or more tables ? JOIN data manipulation command combines the records from one or more tables.

Define data independence, Data independence seems that "the application is...

Data independence seems that "the application is independent of the access strategy and storage structure of data". In other words, the ability to change the schema definition in o

Rules of data normalisation, Rules Of Data Normalisation  Let us now su...

Rules Of Data Normalisation  Let us now summarise Normalisation with the help of various clean rules. The following are the necessary rules for the Normalisation process: 1.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd