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
ODU Email account
All Video Playlists
online and zipped
Resources for each Module
All SAs and Review
Oracle Login Problems
Master List of Oracle
HTML and PDF
(11g r2) Documentation
Puget Sound Oracle
User's Group Library
Dia drawing tool for
Getting Started link available on left side.
Relational Algebra UtilitiesRelational 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
SQL UtilityBrowser Based Interface to SQL. Alternate version for those who prefer to type everything.
How to use SQLPLUS
SQL examples -- the CVM questions
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
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.