Question
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
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:
Region Table
Jobs Table
-- Author: Name Create date: -- Description: - Version: ?ChangesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started