Question

Database Normalization

Please if you don't know the answer don't comment as "Need More Information."
Please answer it in a table form with the data included as per table A and table B.

Introduction:
This lab is designed to help you with practicing normalization concepts implementation.

Submission:
After finishing the task below, convert the word file to a PDF document and submit it to Brightspace.

Task:
Using this file, normalize the following tables to be in the third normal form. Remember to consider having the data when you do the normalization.

Course_Title	Course_Credit_Hours	Professor_ID	Professor_Name	First_day_work	Professor Specialization_ID	Professor Specialization
Accounting, Finance	3,3	234	Patric	14/2/2008	7	Accounting
Marketing, Business administration	3,2	564	Mary	15/4/2010	5	Business Management

Notes: • Every course can be taught by more than one professor and each professor can teach more than one course.

Table B

Employee_ID (P.K)	Project_ID (P.K)	E_Name	P_Name	E_Assigned_Hours
100	101	Cedric	Acct.	13
200	110	Natali	Finance	15
300	111	Maria	BD	12

Marking Criteria:
• Entities titles
• Attributes:
• PKs:
• FKs:
• Relationships:
• Handling data:

Answer 1