CSCI 5931A Advanced Database Development

Course Syllabus, Policies and Calendar.
Discussion Board for the course: for posting messages and questions. I will check and respond very frequently.

Current Grade: You can find your grade so far here.

Here is a list of recommended books for the course. More will be added.

Homework:

• Homework #1
  
• Homework #2
  
• Homework #3
  
• Homework #4: due on November 19 (Thursday).
  
• Homework #5 : due on December 3 (Thursday).
  

Suggested Solution to Homework:

• Partial suggested Solution to Homework #1.
• Comments on Homework #1 result.
• Comments on Homework #2.
  
• Suggested Solution for Homework #3.
  
• Comments on Homework #3.
  
• Comments on Homework #4.
  

Course Materials:

• SQL
  • Additional SQL problems in the class.
  • Solution to the additional SQL problems.
• Stuffs from CSCI 4333
  • Mapping from UML to the relational models.
  • Executing SQL statements for the Northwind database.
  • Executing SQL statements for the database for the classroom exercise.
  • SQL Solution to worksheet.
    
• ASP:
  • Documentation to Active Server Pages
    
• Oracle:
  • Oracle and ODBC:
    • Executing SQL through Oracle.
    • Executing SQL on the Northwind Database in Oracle.
  • PL/SQL:
    • SQL Script for creating sample table used in the class: from the McGraw-Hill book on PL/SQL programming.
    • Print student course counts.
    • Print student majors.
    • Incorrect record comparion.
    • Correct record comparison.
    • Table example #1.
  • Triggers in PL/SQL
    • InsertStudentsSetMajorStats.sql.
    • UpdateStudentsSetMajorStats.sql.
    • DeleteStudentsSetMajorStats.sql.
    • AddStudentAfter.sql.
    • AddStudentIncorrect.sql.
    • AddStudent.sql.
    • UpdateStudent.sql.
    • LimitMajors.sql (incorrect version.
    • LimitStudentMajors.sql.
    • PrepareMajorCount.sql.
• PHP
  • Show a select month option: source.
  • Using odbc_result_all to list all student records: source.
  • Using a php hit count (HitTest.php3): source.
    • Sql commands to create the hit table.
    • Hits.php3: Included file to update the hit count.
  • Set voting question (SetVote.php3): source.
  • Executing SQL: source.
• JDBC Examples:
  • FindMajorAlt.java: using PreparedStatement.
  • SetGpa.java: updating table.
  • UpdateMajor.java: updating table.
  • create_a_table.java: creating table.
  • ConvertToGradePoint.java: using CallableStatement.
  • sqlplus.java: simulating SQL* Net.
  • TableLister.java listing table, solution to HW#5, question (2).

Projects

• Project #1: due on September 29, 1998 (Tuesday)
  
• A possible UML Diagrams solution for the project #1 in Rational Rose, 224KB.
  
• Comments for Project #1.
• Project #2 .
• A partial suggested Solution to Project #2
  
• Comments for Project #2.

Examinations and Suggested Solutions:

• Mid-Term Examination.
  
• Suggested Solution to Mid-Term Examination.
  
• Final Examination: MS Word
  

Useful external links:

• Raional's UML center: containing references of the Unified Modeling Language at the Rational site.
• OO Info: Object-Oriented Information Sources.
  

Yue's home page yue@cl.uh.edu 281-283-3864

Since August 14, 1998, you are visitor #: