Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!


Get assignment help service to meet the high expectations of your professors

GET ASSIGNMENT HELP

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.

Assignment Help Features
Assignment Help Services
  • Assignment Help
  • Homework Help
  • Writing Help
  • Academic Writing Assistance
  • Editing Services
  • Plagiarism Checker Online
  • Proofreading
  • Research Writing Help
QR Code Assignment Help
elearningfeeds