Assignment 2: Final Project-Core Components of PL/SQL This assignment is due for online students by midnight Sunday of Week 11 and for on-ground students before the Week 11 class. On-ground students will share their projects with the class.
1. This assignment allows you to pick your own subject in which you do the following:
Code a Package Header that contains the following:
a. Global Variable Specification
b. Type
c. Four (4) Procedure Specifications
d. Two (4) Function Specifications
2. Code a Package Body that contains the implementation code for the following:
a. Four (4) Global Procedures
b. One (1) Private Procedure
c. Two (2) Functions
d. Code to Implement the Type
e. Three (3) Application Triggers that are related to your project
f. Three (3) Database Triggers that are related to your project
3. Code triggers, trigger calls, and implementation code for the following:
a. Four (4) Global Procedures
b. One (1) Private Procedure
c. Two (2) Functions
Prepare the following documentation for your project:
1. Submit your code in a series of Notepad or Wordpad documents. Include the code for the assignment and the output that is realized from running the code.
2. Create a technical document using Microsoft Word that describes the purpose and major logical features of each of the components such as the Package Header, the Package Body, the Implementation code for the procedures and functions, the triggers and invoking calls of the project.
3. Create a PowerPoint Presentation that documents the major components and their interrelationships. As a minimum, this documentation should provide a PowerPoint slide for each of the project components. Use the notes section on each slide to provide a brief narration of what you want to say when presenting that slide.
4. Submit all your documentation to the course shell under Week 10.
Note: You are responsible for creating the database on which the project will run. This includes the responsibility for loading the database with sufficient data. Grading for this assignment will be based on answer quality, logic/organization of the project to include the compilation, and execution of the project code.