CS610 / CS710 Resources (11/21/2003)

I. Syllabus

II. Class notes

• week1 (8/22/2003)
• week2 (8/29/2003), assignment 1 (due 9/12)
• week3 (9/5/2003) , assignment 1B (due 9/12 - submit together with assignment 1)
• week4 (9/12/2003)
• week5 (9/19/2003) Review Exercise 1
• week6 (9/26/2003)
• week7 (10/3/2003)
• week9 (10/17/2003) Review Exercise 2
• week10 (10/24/2003) Review Exercise 2 - sample solution
• week11 (10/31/2003)
• week12 (11/7/2003)
• week13 (11/14/2003)
• week14 (11/21/2003)
• week15 (12/5/2003)

III. Oracle usage instructions on our system

You have been notified that your accounts are ready.

• Instructions for login and change password
• Oracle material
• Note: Oracle JDBC examples from Oracle are on the SUN in directory: /hd/oracle/jdbc/demo/samples/oci8/basic-samples. More examples are available in the Example section below.
• Attention: add the oracle.cshrc that you receive from the instructor when you want to use JDBC to connect to Oracle. Copy the file to your dir, and do the 'source oracle.cshrc' command. Don't forget to do the source oracle.env command described in the "Instructions for login and change password".

IV. Exercises

Review exercise 1 - ER model, relational model, relational algebra, Datalog Review exercise 1 example solution

Review exercise 2 - Decomposition, SQL

V. Assignment material

assignment 1 (due 9/12)

assignment 1B (due 9/12 - submit together with assignment 1)

VI. References

Books:

• "SQL Instant Reference" - Gruber, Martin. March 2000, SYBEX INC. ISBN: 0782125395
• "A Guide to Oracle8" Morrison, Joline; Morrison, Mike. 2000, Thomson Learning
• "Oracle8i: The Complete Reference (Book/CD-ROM Package)" - Loney, Kevin ; Koch, George. May 2000. McGraw-Hill Professional. ISBN: 0072123648
• "Java & XML" - McLaughlin, Brett; Loukides, Mike (Editor), September 2001,2nd edition, O'Reilly & Associates, Incorporated. ISBN: 0596001975

  Web resources:

• JAVA 2 Platform (J2SE)
• Thinking in Java by Bruce Eckel
• An introduction to JDBC by Ullman and his students.
• JDBC Short course from SUN
• Oracle JDBC documentation (detail)
• SUN's XML tutorial
• World Wide Web Consortium (W3C) XML Recommendation 6
• An introduction to Oracle by Ullman and his students (The additional Oracle information!)
  • If you are not familiar with Oracle, you should read their section on "Oracle 9i SQL versus Standard SQL " .

  Examples:

• JDBC using Oracle : EmployeeQueryUpdate.java, LoginName.java, CreateEmp.java
• J2EE examples
• JAXP example

VII. Class Project

	Email instructor: wong@cis.uab.edu
	Email TA: chenyh@cis.uab.edu

UAB Department of Computer and Information Sciences