View the step-by-step solution to:

Normalize the following data upto 3 rd Normal Form ( 30 Points ) Project Numbered Project Name Employee Numbers Employee Name Job Class 15+ Evergreen...

K`Y[POWC3NT3PXW0JZ8Y]NO.png

1.     Normalize the following data upto 3rd Normal Form (30 Points)

Project_Number

Project_Name

Employee_Number

Employee_Name

Job_Class

15

Evergreen

103

June E. Arbough

Elect. Engineer

15

Evergreen

101               

John G. News

Database Designer

15

Evergreen

105

Alice K. Johnson

Designer

15

Evergreen

106

William Smithfield

Programmer

15

Evergreen

102

David H. Senior

System Analysist

18

Amber Wave

114

Annelise Jones

Application Designer

18

Amber Wave

118

James J. Frommer

General Support

18

Amber Wave

104

Ann K. Ramors

System Analysist

18

Amber Wave

105

Alice K. Johnson

Designer

Normalize the following data upto 3rd Normal Form

K`Y[POWC3NT3PXW0JZ8Y]NO.png

Normalize the following data upto 3 rd Normal Form ( 30 Points )
Project Numbered Project Name Employee Numbers Employee Name Job Class
15+
Evergreen
103 +
June E Arbought Elect Engineer
SP
Evergreen
101 +
John G. News
Database Designers
15
Evergreen
105#
Alice K. Johnson Designer
5+
Evergreen
06
William Smithfield . Programmers
15 +
Evergreen
102 +
David H Seniore
System Analysist
180
Amber Waves / 114 .
Annelise Jones
Application Designers
18+
Amber Waves / 1 18
James J . Frommere General Supports
18 +
Amber Waves/ 104
Ann K Ramorse
System Analysisto
18 +
Amber Waves 105
Alice K Johnson
Designer

Top Answer

For a table to be in 3NF there are two requirements : i) it has to be in 2NF ii) There cant be any transitive dependencies... View the full answer

1 comment
  • Seems that the formatting of the table got messed up by the website. I have upload the table separately in good format. Please check this link for the image of the table https://i.imgur.com/6Q3a3hM.jpg
    • Algorithm_123
    • Dec 02, 2018 at 2:07am

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online