Region Table

Jobs Table

Write a program specification that describes all specifications and functions properly producing the correct input and output for the HR subsystem tables (REGIONS, JOBS). A program specification are simple requirements that describe what you need to do for this assignment.

Write PL/SQL code that INSERTS, UPDATES, and DELETES from REGIONS and JOBS and is understandable and well organized containing no errors. The guided practice assignment provided the basics on how to do this. Also, pay attention to particular coding standards. Also, make sure you are validating any user input in your code. Please adopt those in your application. Please refer to the guided practice assignment for guidance.

Document your PL/SQL code with appropriate comments embedded in your code. Include comments throughout your code to explain what you are doing. Do it sparingly and only where you need someone else to understand what you are doing. Review the basic comment structure for your code. Use following header for your PL/SQL code:

Run, debug, and submit your PL/SQL code

Submit a screenshot of your running code

REGION IDREGION NAME 1 Europe 2 Americas 3 Asia 4 Middle East and Africa