You are on the wrong server! The CS450 site is now supported by the cs450 server only and not secweb. Get me on the right server.

Latest Course Information Spring 2019

Loaded: 10:15, Sun Mar 24 2019

PLSQL and PHP due: Mar 31, 2019. That is fewer than 8 days from now.
Oracle is Up!
Self Assessments Set 5 due: 3/24/2019. That is less than one day from now.
C S Dept. Account

Course Signup

ODU Email account


All Video Playlists

Presentations (PDF)
online and zipped

Resources for each Module

All SAs and Review

Getting started

Oracle Account

Oracle Login Problems

Master List of Oracle
(11g r2) Documentation

Puget Sound Oracle
User's Group Library

PHP Manual

Dia drawing tool for
ER Diagrams


Getting Started link available on left side.

Relational Algebra Utilities

Relational Algebra Online
An integrated environment where you can create and test your relational algebra queries against a database.
After choosing your device, click on the or button for a tour.
Once you have learned the language, you may prefer typing everthing in. You can use this alternate version. It does not insert anything for you, but removes a few annoyances.
Examples from the CVM PowerPoints suitable for copy-and-pasting into Relational Algebra Online
PL/SQL Examples See Assignment for many more resources.
• How this system knew you had performed the DML operations or not: The trigger on the DML self-assessment.
• The database procedure that checks the audit table
PHP Processing Diagram
An example of a project similar to yours: PHP Notes includes tutorial that explains the above Example
A stripped down version of the file you have to submit to help clarify the assignment: PHP Requirements Skeleton

Returned Assignments

January 24, 2019: Syllabus assignment recorded. See ✔Grades.
January 28, 2019: First set of review questions graded. See ✔Grades.
February 4, 2019: Check Oracle account exercise recorded. See ✔Grades.
February 4, 2019: First survey submissions recorded. See ✔Grades.
February 11, 2019: Second set of review questions graded. See ✔Grades.
February 20, 2019: First Assignment, Relational Algebra recorded. See ✔Grades. Grading has been sent to your ODU email.
February 26, 2019: Third set of review questions graded. See ✔Grades.
February 26, 2019: Second survey submissions recorded. See ✔Grades.
March 5, 2019: Second Assignment, SQL recorded. See ✔Grades. Grading has been sent to your ODU email.
March 11, 2019: Midterm Exam has been graded. See ✔Grades. For more details go to the course in ; pick Tools | My Grades; click the test name | Calculated Grade
March 11, 2019: Midterm Standing now available. Some students have comments. See ✔Grades.
March 20, 2019: Fourth set of review questions graded. See ✔Grades.
Scroll to the bottom of ✔Grades for a discussion of the answers to the review questions.
March 20, 2019: Third survey submissions recorded. See ✔Grades.
See the anonymous responses of survey number 3. Answers in random order. I have answered your questions and made some comments on your answers. Please have a look.