rd
1. Normalize the following data upto 3 Normal Form
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
2. Normalize the following data upto 3rd Normal Form (
ISBN
Title
Publication Cost Retail Category Publisher
Contact Author
Date
8843172113 Data
04-JUN-17 80 100 Computer AA Publish
David
T. Peterson
Systems
J. Austin
J. Adams
1792545224 Data
05-JUL-17
Analytics
80 120 Analysis International Davidson W. White
L. White
Publication