Transcript Lab

Lab COSC 3480
Fall 2000
COSC 3480 Projects, Christoph F. Eick
1
ODL/OQL
basics
Database
Design
VMS
Oracle 8 ObjectRelational features
Learn how to load Learn how to
an Oracle database
define user views
from files
Learn how to
access Oracle
Learn how to write
SQL Queries
Learn how to
define tables
Learn PL/SQL
basics
PL/SQL
Cursors
Learn how to
update a database
Generate SQL Plus
reports
Developer
2000 reports
Developer 2000
PL/SQL
Datablock Forms
Triggers
PL/SQL Functions
Procedures and Packages
COSC 3480 Projects, Christoph F. Eick
Embedded SQL
PRO*C
OLAP
2
PROJECTS FALL 2000
Project1: Design a Relational Database, Fill it with
Data, Write Queries --- Group Project; what is
learnt: Database Design and E/R, Database
Loading, Define Relational Schema, Write SQLQueries, Define Views) T=4/W=3
Projects2: Updating a Relational Database using
PRO*C --- Individual project. T=3/W=4
Project3: Using PL/SQL --- Individual Project
T=5/W=6
Project4: ODL/OQL --- Group Project T=1/W=2
COSC 3480 Projects, Christoph F. Eick
3
Lab Lecture Schedule
 Sept. 11: Lab Information; Account Access; Oracle Basics; Explanation of
Project1
 Sept. 13: Introduction to Oracle; Create Tables; Loading Tables
 Sept. 18: Writing SQL Queries
 Sept. 20: Views
 Sept. 25: More on SQL Queries / PRO*C Interface Discussion Project2
 October 2: PRO*C
 October 11: PRO*C
 October 16: Introduction to PL/SQL
 October 23: Cursors in PL/SQL
 October 25: PL/SQL Functions and Queries; Project3
 October 30: Writing Complex Queries in Oracle
 November 1: Constraints and Triggers in Oracle
 November 8: Constraint and Triggers in Oracle; Project4
COSC 3480 Projects, Christoph F. Eick
4