logo
+1-617-874-1011 (US)
+61-7-5641-0117 (AU)
+44-117-230-1145 (UK)
Live Chat

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.

Improve Your Grades with Custom Writing Help
Homework Help
Writing Help
Editing Services
Plagiarism check
Proofreading services
Research Project help
Custom writing services
scanner
E learning blogs

Disclaimer : The study tools and academic assistance/guidance through online tutoring sessions provided by AssignmentHelp.Net is to help and enable students to compete academically. The website does not provide ghostwriting services and has ZERO TOLERANCE towards misuse of the services. In case any user is found misusing our services, the user's account will be immediately terminated.