CSCI 4333 Design of Database Systems
Course Syllabus
Spring 2007

TEXT BOOK

	Database Management Systems By Raghu Ramakrishnan, UNIV OF WISC - MADISON Johannes Gehrke, Cornell University McGraw-Hill Higher Education ISBN: 0072465638 1104 pp. Published: 2003
	Oracle 9i Programming: A Primer By Rajshekhar Sunderraman. Published by Addison Wesley Professional. ISBN: 0321194985 334 pp. Published: 2003 Download code.

Recommended Website:
Online Learning Center of textbook 'Database Management Systems'.
Safari Tech Books Online by O'Reilly provides more than 300 free technical books.

• On-Campus Access: You can access Safari from any PC inside UHCL campus network.
• Off-Campus Access: From the library’s World Wide Web Homepage, click on Research a Topic, then Find Articles & More, and then either Sciences or S. Click on the Safari Tech Books hyperlink. Please read the patron authentication instructions for Off-Campus database access.

COURSE GOALS

1. Understand the database development process, and how it fits into the broader concept of systems analysis, design, and implementation.
2. Understand and use techniques and tools for developing data models, as part of a database analysis and design effort.
3. Acquaint the student with the fundamentals of an Relational Database construction and manipulation.
4. Learn the process of determining requirements and detailed design using Entity-Relationship diagrams.
5. Gain exposure and experience in Structured Query language (SQL), Procedural Language/Structured Query Language (PL/SQL), and Relational Algebra (RA) for Manipulation and construction of Relational Database tables.
6. Learn the process of Normalization of database tables to enhance consistent upgrading and altering of databases.

COURSE DESCRIPTION

Design and implementation of database applications, design of database systems, relational model, relational algebra,  SQL and PL/SQL, normalization theory.

METHODOLOGY

Lecture and interactive problem solving.

APPRAISAL

Participation: 5% of the total
Individual Homework: 18% of the total
Term Project: 17% of the total
Midterm Exam: 28% of the total
Final Exam: 32% of the total

GRADING

91+ = A; 89+ = A-;
87+ = B+; 83+ = B; 80+ = B-;
77+ = C+; 73+ = C; 70+ = C-;
67+ = D+; 63+ = D; 60+ = D-;
0+ = F;

READING

We will read from the recommended text book, various sources on the web, and slides that will be made available on the web site. The schedule for the readings are given on the schedule web page.

OTHER POLICIES

1. Homework:
   • All homework must be typed not hand-written and must be submitted with an envelope attached with the given cover page ( section 01 & section 02).
   • Homework is due exactly at the prescribed time. No late homework is accepted.
   • In the event you are running late for the class, you may email the softcopy of the assignment in one ZIP file to both the instructor and the TA to secure your submission time and turn in the full package of the same version to the instructor within one day. Your homework will not be graded until the instructor received the full package.
   • Any questions or complaints regarding the grading of an assignment or test must be raised within one week after the score or the graded assignment is made available (not when you pick it up).
2. Providing answers for any examination when not specifically authorized by the instructor to do so, or, informing any person or persons of the contents of any examination prior to the time the examination is given is considered cheating.
3. Penalty for cheating will be extremely severe. Use your best judgment. If you are not sure about certain activities, consult the instructor. Standard academic honesty procedure will be followed for cheating and active cheating automatically results F in the final grade. Please check University of Houston - Clear Lake's Online Policies Web site for additional information.
4. You are expected to come fully prepared to every class.
5. No incomplete grade under nearly all situations.
6. There is no formal attendance policy. However, you are responsible for everything discussed in class. You may receive a zero for lack of participation.
7. Pay very careful attention to your email correspondence. It reflects your communication skills. Avoid use non-standard English such as "how r u?" in your email message. In addition, I recommend you put the class number 4333 and a brief summary of your question in your email subject. For example,

   Subject: CSCI4333 A question on E-R Diagram.

8. I immediately discard anonymous emails.
9. The ringing, beeping, buzzing of cell phones, watches, and/or pagers during class time is extremely rude and disruptive to your fellow students and to the class flow. Please turn off all cell phones, watches, and pagers prior to the start of class.

© Wei Ding, 2002-2007, all rights reserved. This document is made available for use by the students of CSCI 4333 at the University of Houston-Clear Lake. Copying, distribution or other use of this document without express permission of the author is forbidden. You may create links to pages in this web site, but may not copy all or part of the text without permission of the author.