Task 2 25 Marks
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 the Employee table and other tables any number of records)
2) Display the Employee Name belongs to the 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. 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 tate is above 100.
10) Demonstration of Task1 and Task 2 for 5 minutes by Lesson 9/ Lesson10 in class.
Note: 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.
Stuck with a lot of homework assignments and feeling stressed ?
Take professional academic assistance & Get 100% Plagiarism free papers
The post Key in appropriate records for all the tables. (Sample. take from the project report given: Database Design and Modelling Course Work, NTU appeared first on Singapore Assignment Help.
