Hi! I need help with this normalization/SQL database task (I´ll make sure to giv

Question

Hi! I need help with this normalization/SQL database task (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

First normal form (1NF) is a property of a relation in a relational database.It should contains atomic value for Every columns in the table.DEPT is in First Normal Form where as EMP is not

A database is in second normal form if it should follow conditions:It is in first normal form and All non-key attributes are fully functional dependent on the primary key.

EMP is not in first normal form because empty value in the "COMM" and "MGR" attribute

In third Normal fomal ,it should satisify first and second normal form .So DEPT and EMP Doesn't meet them.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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