Normalization Exercises 1: Normalize the tables below. Show the resulting tables

Question

Normalization Exercises 1:

Normalize the tables below. Show the resulting tables.

Exercise 1:

You are given the following table:

EMP_PROJ(ssn, pnumber, hours, ename, pname, plocation)

And you are given the following functional dependencies:

(i)(ssn, pnumber) hours

This means: hours in dependent on ssn and pnumber.

(ii)(ssn) ename

This means: ename in dependent on ssn.

(iii)pnumber (pname, plocation)

Exercise 2:

You are given the following table:

EMP_DEPT(ename, ssn, bdate, address, dnumber, dname, dmgrssn)

And you are given the following function dependencies:

(i)ssn (ename, bdate, address, dnumber)

(ii)dnumber (dname, dmgrssn)

Explanation / Answer

Exercise 1:

Functional Dependancies are as given

hours->ssn,pnumber

ename->ssn

pnumber->pname,plocation

So depending on above functional dependancie we get

candidate key={hours,ename}

First table will be :

HoursTable(hours,ssn,pnumber)

Second table

Ename_Table(ename,ssn)

Third Table:

With candidate key (hours,ename)

Table(hours,ename)

Exercise 2

Functional dependancies as given

ssn->ename,bdate,address,dnumber

dnumber->dname,dmgrssn

According to normalizatopn we get the candidate key is

Candidate key is =>(ssn)

First Table is

First_Table(ssn,ename,bdate,address,dnumber)

Second Table is

Second_Table(dnumber,dname,dmgrssn)

Third Table will be

with candidate key =>ssn

Table(ssn,dnumber)

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.