Write a program specification that describes all specifications and functions properly producing the correct input and output for the HR subsystem tables $($EMPLOYEES$,$ DEPARTMENTS, JOBS$).$ A program specification is just a simple requirement that describes what you need to do for this assignment. Use this $($Links to an external site.$)$ as a guide for your program specifications.

Write PL$/$SQL code that INSERTS, UPDATES, and DELETES from each of the tables and make sure to handle the relationships 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.EMPLOYEES

$\backslash$table$[[$ COLUMN$\_$NAME,$$ DATA$\_$TYPE,$$ NULLABLE,DATA$\_$DEFAULT,$$ COLUMN$\_$ID $|$ COMMENTS$],[1$ EMPLOYEE$\_$ID$,$NUMBER $(6,0),$No$,($null$),1$ Primary key of employees table.$],[2$ FIRST$\_$NAME,VARCHAR$2(20$ BYTE$),$Yes,$($nu$11),2$ First name of the employee. A not $n$