**********EXAMPLE OF WHAT IM LOOKING FOR**************** If I was given the foll

Question

**********EXAMPLE OF WHAT IM LOOKING FOR****************

If I was 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)

*****I would expect the answer to be*****

Create table EMP

(ssn int NOT NULL PRIMARY KEY,

ename varchar (50),

bdate date,

address varchar(255),

dnumber int FOREIGN KEY REFERENCES DEPT(dnumber))

Create table DEPT

(dnumber int NOT NULL PRIMARY KEY,

dname varchar(50),

dmgrssn int)

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: (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) **********EXAMPLE OF WHAT IM LOOKING FOR**************** If I was 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) *****I would expect the answer to be***** Create table EMP (ssn int NOT NULL PRIMARY KEY, ename varchar (50), bdate date, address varchar(255), dnumber int FOREIGN KEY REFERENCES DEPT(dnumber)) Create table DEPT (dnumber int NOT NULL PRIMARY KEY, dname varchar(50), dmgrssn int)

Explanation / Answer

Hope it will helps you very much....

This is not normalized, as explained. A normalized form could look like

Here, the Employee table is only responsible for one set of data. So where do we store which department the employee belongs to? In another table

This is not optimal. What if the department name changes? (it happens in the US government all the time). Hence it is better to do this

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

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