| Instructor | Kwok-Bun Yue |
| Office & Addresses | Delta 169 Phone: 281-283-3864 E-Mail Address:
yue@cl.uh.edu
URL: http://turquoise.rocks.uhcl.edu/yue/ Course's URL: http://turquoise.rocks.uhcl.edu/yue/advdb/su99 Secretary: Ms. Maxine Galloway, Delta 161, 283-3740 |
| Office Hours | TR 1:15-2:45 and by appointment |
| Teaching Assistant | To be determined. |
| Text Book | None.
A list of recommended reference books will be listed as the course progresses. |
| Course Description | Advanced database development techniques, database modeling, DBMS, rapid application development tools, database performance optimization, SQL development, database application programming interfaces, database web-connectivity, database administration. |
| Course Goals | After completion of the course, students are expected to be able to design and develop more advanced database applications. Students should also be open |
| Prerequisites | CSCI 3233 C++ or CSCI 3134 Java (mandatory: Java is highly preferred)
CSCI 4333 Designs of DB Systems (mandatory) CSCI 4230 Software Tools (highly recommended) CSCI 5333 (recommended) |
| Course Format | Traditional lectures with some classwork. |
| Grading | Project and Homework Assignments: 48%
Two Examinations: 52% (26% each) |
| Calendar | First Examination: June 29, 1999
Last drop date: July 6, 1999 Final Examination: July 29, 1999 |
| (1) | Assignments are due at the beginning of classes. No exception. |
| (2) | Late projects are accepted with a penalty of 20% deduction per week day after the due date. No late project will be accepted one week after the due date. The last project cannot be late. |
| (3) | No make-up exam except in verified emergencies with immediate notification. |
| (4) | No incomplete grade or administrative withdrawal under nearly all situations. |
| (5) | Penalty on cheating will be extremely severe. Standard academic honesty procedure will be followed. |
| (6) | No formal attendance policy. |
| (7) | Class notes will only be distributed in the lecture it is distributed. If you miss a lecture without a satisfactory reason, do not ask me for make-up lecture notes. |
| [90.100] | A |
| [87..90) | B+ |
| [83..87) | B |
| [80..83) | B- |
| [77..80) | C+ |
| [73..77) | C |
| [70..73) | C- |
| [67..70) | D+ |
| [63..67) | D |
| [60..63) | D- |
| [0..60) | F |
The highest grade without turning in a project
is B-.
The highest grade without turning in two projects
is C-.
The highest grade without turning in three projects
is D-.
Tentative Course Content:
Subject to changes based on class progress.
|
|
Date |
|
| 1 | June 1, 3 | Introduction
Object-Oriented DB Modeling using UML and Rational's Rose |
| 2 | June 8, 10 | DB Design using Oracle Designer
An introduction to Oracle Enterprise Server Advanced SQL and an introduction to PL/SQL. |
| 3 | June 15, 17 | PL/SQL |
| 4 | June 22, 24 | PL/SQL
An introduction to Oracle's packages |
| 5 | June 29, July 1 | June 29: Mid-Term Examination
An introduction to Oracle's Developer and other tools |
| 6 | July 6, 8 | An introduction to Oracle's Developer and DBA tools
Web Database Connectivity using PHP |
| 7 | July 13, 15 | PHP
DB API programming in JDBC Embedd SQL programming in SQLJ |
| 8 | July 20, 22 | XML and databases
Data warehousing |
| 9 | July 27, 29 | Data warehousing using MS SQL Server 7.0
Future trends of database systems Review July 29: Final Examination |