Question: Project: Database Design for a Human resource - Project Management You're appointed as Database administrator to Shark Solutions. Your first assignment is to advise your

Project: Database Design for a Human resource -Project: Database Design for a Human resource -

Project: Database Design for a Human resource - Project Management You're appointed as Database administrator to Shark Solutions. 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. 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.) 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. 6) Display department name with Number of employees less than 5 Numbers 7) Create a stored procedure in the name Finance_SP. The procedure is to display how many employees in Finance Department ote: Use SQL software, Do Joins in query wherever applicable. All the tables with data and SQL query along with its output for each task should be provided in word file

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!