index_004

index_004 - CS348: Project #3 Overview You are going to use...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
CS348: Project #3 Overview You are going to use PL/SQL (Oracle's procedural extension to SQL) to write a few functions and procedures to process data. The result of the work should be a file named your_login.sql which contains all the PL/SQL statements you used to handle the data processing tasks listed below. Your grade depends on how you use the PL/SQL statements and the result of running the resulting .sql file. Due date : Nov 8, 2011 @11:59 pm. Step 1: Setup You will use the same schema as you did for Project #2 . Do not forget to create the PKs and FKs to test your code. This step is necessary to build the PL/SQL procedures and functions but it will NOT be included in your your_login.sql. Your task: 1. Create the 5 tables. 2. Execute the file ( data.sql ) to insert the test data into the tables you created in the previous step. Top Step 2: PL/SQL Overview Setup Procedure: pro_department_report Procedure: pro_faculty_stats Procedure: pro_student_stats Procedure: pro_histogram
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Procedure: pro_insert_class Setup Refer to Step 1. Important : The first line of your .sql file should be the following: set serveroutput on size 32000 ... otherwise don't come complaining to me when dbms_output isn't printing anything
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

index_004 - CS348: Project #3 Overview You are going to use...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online