Please if you don't know the answer don't comment as "Need More Information."

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

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

A)

Student Name	Course_Title	Course_Credit_Hours
David	Accounting, Finance	3,3
Sally	Marketing, Business administration	3,2

B)

Employee name	Specializations	Dept. 1	Dept. 2
Cedric	Accounting	Accounting	---
Natali	Finance	Accounting	Finance
Maria	IT	IT	Marketing

Marking Criteria: 1) Entities titles (6 Marks) 2) Attributes: (13 Marks) 3) PKs: (4 Marks) 4) FKs: (4 Marks) 5) Relationships: (6 Marks) 6) Handling data: (13 Marks)