Normalization Practice assignment: Please normalize the following table.

DATABASE SYSTEMS

Design, Implementation, and Management

12e

Carlos Cornonel & Steven Morris

Cengage Learning

PROJ_NUM	PROJ_NAME	EMP_NUMBER	EMP_NAME	JOB_CLASS	CHARGE_HOUR	ASSIGNED_HOURS
15	Evergreen	103 101 105 106 102	June Arbough John News Alice Johnson William Smithfield David Senior	Elect. Engineer Database Designer Database Designer Programmer Systems Analyst	84.50 105.00 105.00 35.75 96.75	23.8 19.4 35.7 12.6 23.8
18	Amber Wave	114 118 104 112	Annelise Jones James Frommer Anne Ramoras Darlene Smithson	Applications Designer General Support Systems Analyst DSS Analyst	48.10 18.36 96.75 45.95	24.6 45.3 32.4 44.0
22	Rolling Tide	105 104 113 111 106	Alice Johnson Anne Ramoras Delbert Joenbrood Geoff Wabash William Smithfield	Database Designer Systems Analyst Applications Designer Clerical Support Programmer	105.00 96.75 48.10 26.87 35.75	64.7 48.4 23.6 22.0 12.8
25	Starflight	107 115 101 114 108 118 112	Maria Alonzo Travis Bawangi John News Annelise Jones Ralph Washington James Frommer Darlene Smithson	Programmer Systems Analyst Database Designer Applications Designer Systems Analyst General Support DSS Analyst	35.75 96.75 105.00 48.10 96.75 18.36 45.95	24.6 45.8 56.3 33.1 23.6 30.5 41.4