SQL assignment question 2
- Create your own schema as a copy of HR schema. [create tables with only copying the structure of tables ] [14 Marks]
- Insert 10-15 records for each table.[10 Marks]
- Write a PL/SQL code to retrieve the employee details whose employee number is input by the user.[2 Marks]
- Write a PL/SQL code to display employee details along with region and country name of 5 highest paid employees.[3 Marks]
- Write a PL/SQL function that accepts department number and returns the total salary of the department. Also write a function to call the function. [3 Marks]
- Write a trigger on the employee table which shows the old values and new values of first name after any updations on first name on Employee table.[3 Marks]
- Generate star schema Employees. The grain of the schema should be the combination of hire year, location, region and country. [10 Marks]
- Create a process to Load the data to the star schema from the central Employee repository. [10 Marks]
Note:
You must submit work distribution report [individual involvement] within a team for the project.
Subjects List
Database (48)
Accounting (39)
Economics (34)
Finance (54)
Programming (122)
Management (69)
Marketing (25)
Report Writing (52)
Engineering (79)
Statistics (39)
Business Studies(45)
Case Studies (15)
Networking (26)
UML (9)
Science (23)
Nursing (11)
MATLAB (17)
Psychology (6)
Math (20)
Data Structure (9)
Python (15)
HRM (25)
IT (21)
Computer Science (57)
Law (4)
Essay (3)
Data Analysis (2)
Big Data (3)
Philosophy (2)
History (1)