Hi! I need help with this normalization/SQL database task. I`m not sure how to n

Question

Hi! I need help with this normalization/SQL database task. I`m not sure how to normalize it. (I´ll make sure to give you a "thumbs up"):

Consider the database below:

a) Is it on first normal form? If not, normalize it

b) Is it on second normal form? If not, normalize it

c) Is it on third normal form? If not, normalize it.

In the tasks a) to c) you need to motivate (prove) your answer and not just write YES/NO.

The table DEPT:

The table EMP

DEPTNO DNAME LOC 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON

Explanation / Answer

The tables DEPT and EMP are in first normal form because   all fields contains atomic values(i.e. no multiple values)

The table EMP also in first normal form:

b) The table DEPT is in second normal form    because there is no partial dependency

The table EMP is not in second   normal form

empID                     comm

7499                                 300

7521                                 500

7654                                 1400

7844                                   0

3. Now the above tables are in 3rd normal form.

DEPTNO DNAME LOC 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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