CS3431. Database Systems I

SQLPlus Commands
A very simple intro to Oracle SQL
Oracle SQL Reference from oracle.com
A Quite Extensi ve SQL + Oracle Tutorial from UCDavis
Introductory Material on Sets, Relations and Functions can be found here.
DB I at other universities
- Stanford
- Wisconsin
ER Model
- The original paper that introduced ER in 1976 can be obtained here
- A write-up by Murali giving mathematical definitions of ER concepts, as well as some extensions are available here.
Example Views can be found here
Example Stored Procedures and Triggers can be found here

With reference to the project

Oracle Documentation is available here
MySQL Documentation is available here

Reference on HTML Forms
http://www.w3.org/TR/REC-html40/interact/forms.html
http://www.w3schools.com/html/html_forms.asp

Handout on Perl/CGI, and how to use Perl DBI with Oracle/mySQLps pdf
Code for the above can be found at: http://www.wpi.edu/~mmani/perlSamples

Simple tutorial on Perl: http://www.tizag.com/perlT/index.php
Extra Reference on Perl DBI: http://search.cpan.org/~timb/DBI/DBI.pm
Reference on DBD::Oracle, including how to call Oracle PL/SQL procedures/functions from Perl: http://cpan.uwinnipeg.ca/htdocs/DBD-Oracle/DBD/Oracle.html

Simple user authentication mechanisms using Perl and examples can be found here. ps pdf

Handout on JDBC ps pdf
Introduction to JDBC with Oracle from Stanford can be found here
Reference on calling procedures/functions using java.sql.CallableStatement: http://java.sun.com/javase/6/docs/api/java/sql/CallableStatement.html

Handout on servlets ps pdf
Extra Reference for Servlets can be found here or here
If you are using servlets, you might bundle up your code as a Web ARchive (WAR). Test your WAR before submitting it. Documentation on how to build your WAR file is available here
Embedded SQL
- More sample code on Pro*C ps pdf
- Extra reference on using SQL with C on Oracle can be found here
- Sample code for using SQL with Java (SQLJ): ps pdf
Some sample pieces of code for building applications can be found here