Normalization Exercises Normalize the tables below Show the

Normalization Exercises Normalize the tables below. Show the resulting tables. Exercise You are given the following table: EMP_PROJ(ssm pnumben hours: ename: pname: plocation) And you are given the following functional dependencies: (ssn: pnumber) rightarrow hours This means: hours in dependent on ssn and pnumber. (ssn) rightarrow ename This means: ename in dependent on ssn. pnumber rightarrow (pname: plocation)

Solution

In the given table \"EMP_Proj\" the data may be redundant(i.e ename,pname,pnumber,plocation,hours) for each \"ssn\".hence we need to normalize.

When doing normalization we need to maintain the functional dependencies to avoid loss of data.

For the 1st dependency

We create new table called

Emp_Proj_Alloc(ssn,pnumber,hours)

ssn + pnumber is primary key(composite)

For the 2nd dependency

Emp_details(ssn,ename)

ssn is primary key

For the 3rd dependency

Proj_details(pnumber,pname,plocation)

pnumber is primary key