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 the Employee Name that belongs to the department either IT or Finance

3) Count No Employees whose Hourly Rate is above 50

4) Find employee names starting with ‘S’

5) Display the Department Name and Sum of Hourly Rate for each Department. Sample Output: Department Name Total Hourly Rate Finance $125 HR $110 IT $175

6) Display department name with Number of employees less than 5 Numbers

7) Display Employee name and Department name, who has maximum and minimum salary

8) Display No of employees , Department name in each department.

9) Create a procedure to display Employee Name and Department Name whose Hourly rate is above