Project: Database Design for Human Resource – Project Management
You’re appointed as a Database administrator to Harvest Consulting. Your first assignment is to advise your client on how to manage human resources for projects.
Your ideas include how to analyze the logical database design, and physical data model, establish relationships, 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.
Hire a Professional Essay & Assignment Writer for completing your Academic Assessments
Native Singapore Writers Team
100% Plagiarism-Free Essay
Highest Satisfaction Rate
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.
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
1) Key in appropriate records for all the tables. (Sample, take from the project report given and add further meaningful records in the derived tables. Note: Minimum 20 records in Employee table and other tables any number of records)
2) Display Employee Name belongs to department either IT or Finance
3) Count No of Employees whose Hourly rate above 50
4) Find employee names starts with ‘S’
5) Display Department Name and Sum of Hourly Rate for each Department.
Stuck with a lot of homework assignments and feeling stressed ?
Take professional academic assistance & Get 100% Plagiarism free papers
The postappeared first on .