Basic Information:
| Instructor | Kwok-Bun Yue |
| Office & Addresses | Delta 169 Phone: 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/csci4333/f98 Secretary: Ms. Maxine Galloway, Delta 161, 283-3740 |
| Office Hours | TR1:15 - 2:15, T4:15-5:15, or by appointment. |
| Teaching Assistant | None |
| 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 and CSCI 4333 (or equivalent)
CSCI 4230 and CSCI 5333 (recommended) |
| Course Format | Traditional lectures with some classwork. |
| Grading | Project and Homework Assignments: 40%
Two Examinations: 60% (30% each) |
| Calendar | First Examination: October 15 (Thursday)
Last drop date: October 26 (Monday) Final Examination: December 10 (Thursday) 2:30 pm |
| (1) | Assignments are due at the beginning of classes. No exception. |
| (2) | All homework assignments are due on Tuesday. No late homework will be accepted. |
| (3) | Late projects are accepted with a penalty of 10% 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. |
| (4) | No make-up exam except in verified emergencies with immediate notification. |
| (5) | No incomplete grade or administrative withdrawal under nearly all situations. |
| (6) | Penalty on cheating will be extremely severe. Standard academic honesty procedure will be followed. |
| (7) | No formal attendance policy. |
| (8) | 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 |
Tentative Course Content:
This is a very tentative schedule, subjecting
to major changes.
|
|
Date |
|
| 1 | August 25, 27 | Introduction.
Object-Oriented DB Modeling using UML (1) |
| 2 | September 1, 3 | Object-Oriented DB Modeling using UML (2)
DB Modeling CASE Tools: UML and Rational Rose (1) |
| 3 | September 8, 10 | DB Modeling CASE Tools: UML and Rational Rose (1)
An introduction to Oracle Enterprise Server (1) |
| 4 | September 15, 17 | An introduction to Oracle's Enterprise Server (2)
DB Design Tools: Oracle Designer 2000 (1) |
| 5 | September 22, 24 | DB Design Tools: Oracle Designer 2000 (2)
Object-Oriented DB Modeling usig UML (3) |
| 6 | September 28,
October 1 |
RAD tools: Oracle Developer 2000 |
| 7 | October 6, 8 | Advanced SQL: PL/SQL (1) |
| 8 | October 13, 15 | Advanced SQL: PL/SQL (2)
Mid-Term Examination (October 15, Thursday) |
| 9 | October 20, 22 | Advanced SQL: PL/SQL (3) |
| 10 | October 27, 29 | Advanced SQL: PL/SQL (4)
An introductino to Oracle Packages |
| 11 | November 3, 5 | Web Database Connectivity |
| 12 | November 10, 12 | DB API Programming: ODBC and JDBC |
| 13 | November 17, 19 | An Introduction to three-tiered DB Architecture |
| 14 | November 24, 26 | Data Warehousing: Oracle's Discover 2000 (1)
Happy Thanksgiving Holiday, November 26 |
| 15 | December 1, 3 | Data Warehousing: Oracle's Discover 2000 (2)
Additional Topics: Microsoft's SQL Server, Query Optimization, Cold Fusion, Gemstone/J, etc. |
| 16 | December 8, 10 | Final Examination Week |