ASSIGNMENT REQUIREMENT

Project: Database Design for Human Resource $-$ Project Management

You're appointed as Database administrator to Harvest consulting. Your first assignment is to

advise your client on how to manage human resources for projects. Your ideas to include how to

analyze the logical database design $,$ physical data model, establish relationship, create tables,

and manipulate records using Data definition and data manipulation language

You and your team are highly advised to conduct some research and to get better

understanding on human resource data in relation to project management. You may refer to

advised reference books in the course and internet resources.

Below is the Project Management Report, which describes projects being worked upon by

employees.

Task $1-$ Convert the Report from un$-$normal form into third normal form. Provide appropriate

name for each Entities and attributes. Find the primary, Foreign and composite keys. $15$ Marks

Note:

Find Un$-$Normalized form data

Convert un$-$normalized set to $1NF$

$1NF$ to $2NF$

$2NF$ to $3NF$

In between the process of normalization find out Primary, foreign and Composite keys.

Discuss the steps of normalization while carrying each NFs$.$

Use appropriate tool to do the task