neural networks Dr. Gary D. Boetticher Software Metrics
software economics

Return to the home page of Dr. Boetticher
University of Houston Clear Lake - About the University
School of Science and Computer Engineering - Info about SCE
Research Areas - Info about Dr. Boetticher's research
Dr. Boetticher's publications
Courses taught by Dr. Boetticher
Dr. Boetticher's professional experiences

 

CSCI 5333 -- Database Management Systems

SWEN 5931 -- Database Management Systems
Updated October 22, 2009

Office and Address

Delta 171 Phone 281.283.3805
email: boetticher@uhcl.edu
Secretary: Ms. Kim Edwards, Delta 161 281.283.3860

Face-to-Face Class Hours

Thursdays 7:00 - 9:50, Delta 241

Office Hours

Thur. 1 - 4, Friday 12 - 1, or by appointment. If the suite door is locked, then call my extension (last 4 digits) using the phone in the hallway.

Teaching Assistant

Dawood Moazzem, email: moazzemd3722@uhcl.edu
Office Hours: Monday 5 to 10, Wednesday 1 to 6, and Thursday 12 to 4

WebCT link

Required Textbook

 

Elmasri, R., Navathe, S., Fundamentals of Database Systems Benjamin Cummings, Fifth Edition, 2006.

 

 

Reference Materials

Proc. of SIGMOD Conf: ACM-Special Int Grp on Mgmt. of Data (1974-)
Proc. of the Very Large DB(VLDB) Conf. (Morgan Kaufmann) (1975-)
Proc. of IEEE Data Engineering Conf.(1984-)
TODS: ACM Transactions on Database Systems.(1976-)
IEEE /KDE: IEEE Trans. on Knowledge and Data Engineering (1990-)
TOIS: ACM Transactions on Office Information Systems.
Website for database publications by author and topics: http://dblp.uni-trier.de/ maintained by Dr. M. Lay at Univ of Trier, Germany
ORACLE Documentation

Tools/Software

Visio, SmartDraw, mySQL

Course Description

This course uncovers a spectrum of topics involved with current approaches to modeling and design of databases and the design of DBMSs to manage databases. The first half of the course focuses on databases from the perspective of a database programmer. The second half of the course focuses on databases from the perspective of a database administrator. The traditional graduate student load is 3 courses. Be prepared to commit 15 to 20 hours per week to this course! 

Course Goals

Upon completion of the course, students are expected to be able to: design and develop database applications proficiently and understand the fundamental structure of various database systems.

Prerequisites

The prerequisites for this course are CSCI4333 (or an undergraduate database course) and CSCI3532 (or some advanced data structures course). If you do not meet the prerequisites, then you need to drop this course!

Methodology

Web-based supplemented with lecture and interactive problem solving.

Appraisal

 5 Homework/Projects:  15% of the total
 Quizzes: 

  5% of the total

 Participation

  5% of the total

 Midterm:  35% of the total
 Final: 40% of the total

Grading Scale

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

My motto:

Seek the Truth.

Show altruistic love.

Appreciate beauty.

Schedule

Aug 27 Unit 1: Overview, Syllabus, Intro, DB Lifecycle

 

FOR THIS WEEK (IF NOT SOONER)  

·   Read:  Syllabus

 

·   Read:  Orientation

 

                    

               ·   Read:  Unit One of the online notes  The first set of notes

                 will be distributed during the first day of class.

                 See the online orientation document below

                 which explains how to get the password for the notes.

                 For the remainder of the semester it is

                 the student's responsibility to download the notes,

                 print the notes, and bring them to class.

 

     

 

·   Take:  Syllabus Quiz (You may take the syllabus quiz many times.

             No time limit for this quiz. You will need to get a perfect

             score of 100% on the syllabus quiz in order to take

                 other quizzes)

 

·   Take:  Quiz on Unit One Notes  (9/3/09)

                (This quiz, and all the remaining quizzes:

                   ·   may only be taken one time;

                  ·   has a time limit;

                  ·   has a due date (in parenthesis above); and

                  ·   a due time (the beginning of class.)

·   Skim Chapters One and Two of the Elmasri textbook

·   Take:  Quiz on Chapters One and Two of Elmasri  (9/3/09)

·   Read:  Chapter 12.1, 12.2 of the Elmasri textbook

·   Take:  Quiz on Chapter 12.1, 12.2 of Elmasri (9/3/09)

 

FOR NEXT WEEK (IF NOT SOONER)  

·   Read:  Chapter Three of the Elmasri textbook

·   Read:  Chapter Four of the Elmasri textbook

·   Read:  Chapter Seven of the Elmasri textbook

·   Take:  Quiz on Chapters 3, 4, and 7 of Elmasri    (9/3/09)

·   Read:  Unit Two of the online notes

 

   

   

 

 

·   Do    Tutorial: From Requirements to an EER Diagram

·   Do    Tutorial: From an EER Diagram to a set of Relations

·   Take:  Quiz on Unit Two   (9/3/09)

 

Sep 03 Unit 2: Conceptual Design: EER/UML diagrams

 

Assign Homework 1

Point value: 100 points

Due date:  September 24, 2009 (7:00 PM)

 

FOR NEXT WEEK (IF NOT SOONER)

·   Read:  Chapter Five and Six of the Elmasri textbook

·   Take:  Quiz on Chapters Five and Six of Elmasri    (9/10/09)

·   Read:  Unit Three of the online notes (Relational Algebra)

 

   

 

·   Take:  Quiz on unit 3  (Relational Algebra)   (9/10/09)

 

Sep 10Unit 3: Relational Algebra

 

Assign Homework 2

Point value: 100 points

Due date:  October 1, 2009 (7:00 PM)

 

FOR NEXT WEEK (IF NOT SOONER)  

·   Read:  Chapter Ten of the Elmasri textbook

·   Read:  Chapter Eleven of the Elmasri textbook

·   Take:  Quiz on Chapters Ten and Eleven of Elmasri (9/17/09)

·   Read:  Unit Four of the online notes

 

 

 

 

·   Take:  Quiz on Unit Four  (9/17/09)

 

Sep 17Unit 4: Relational Database Design Theory

 

Assign Homework 3

Point value: 100 points

Due date:  Sunday, October 11th, 2009 7:00 PM via email

 

FOR NEXT WEEK (IF NOT SOONER)

·   Read:  Unit Five of the online notes (Minimal Covers)

 

 

 

·   Do    Tutorial: Minimal Covers

·   Take:  Quiz on Minimal Covers (9/24/09)

·   Read:  Unit Five of the online notes (Decomposition of Relations)

 

   

 

·   Take:  Quiz on Decomposition of Relations (9/24/09)

·   Read:  Unit Five of the online notes (Preserving Dependencies)

·   Take:  Quiz on Preserving Dependencies (9/24/09)

 

Sep 24Unit 5: Min. covers, lossless joins, preserving depend.

 

HW 1 Due

 

FOR NEXT CLASS (IF NOT SOONER)

·   Read:  Unit Six of the online notes (Normal Forms)

 

   

 

·   Take:  Quiz on Normal Forms   (10/1/09)

·   Read:  Unit Six of the online notes (Bernstein's Synthesis)

 

 

 

·   Take:  Quiz on Bernstein's Synthesis  (10/1/09)

 

Oct 01 Unit 6: Normal forms up to 4NF

 

HW 2 Due

 

FOR NEXT CLASS (IF NOT SOONER)  

·   Read:  Unit Six of the online notes (Boyce-Codd Normal Form)

 

   

 

·   Take:  Quiz on Boyce-Codd Normal Form   (10/8/09)

 

Oct 08 -  Unit 6: Normal forms up to 4NF, Review

 

HW 3 is due Sunday, October 11th at 7 PM via email

 

              ·   Submit:  Midterm questions by Wednesday, October 14th, 7 PM.

·   Study!

  

Oct 15 Midterm: Closed Book, Closed Notes, Starts at 7 PM in Delta 241

          

FOR NEXT CLASS (IF NOT SOONER)  

·   Read:  Chapters 13, 14, 15, 16 and Appendix B of Elmasri

·   Take:  Quiz on Chapters 13-16, and Appdx B of Elmasri  (10/22/09)

·   Read:  Unit Seven of the online notes

 

   

 

·   Take:  Quiz on Unit Seven online notes (10/22/09)

 

Oct 22Unit 7: Physical DB Design

 

Assign Homework 4

Point value: 100 points

Due date:  November 19, 2009 (7:00 PM)

 

FOR NEXT CLASS (IF NOT SOONER)

·   Read:  Unit Eight of the online notes

·   Take:  Quiz on Unit Eight online notes (10/29/09)

 

* Last day to drop a class/withdraw for the semester is October 27th *

 

 

Oct 29Unit 8: Oracle Architecture

  

FOR NEXT CLASS (IF NOT SOONER)  

·   Read:  Chapters 17, 18, and 19 of the Elmasri textbook

·   Take:  Quiz on Chapters 17, 18, and 19 of Elmasri  (11/5/09)

·   Read:  Unit Nine of the online notes (Tran. Proc, Con Ctrl, Rec)

·   Take:  Quiz on Unit Nine online notes (11/5/09)

  

Nov 05Unit 9: Tran. Processing, Concurrency Control, Recovery

 

Assign Homework 5

Point value: 100 points

Due date:  December 3, 2009 (7:00 PM)

 

FOR NEXT CLASS (IF NOT SOONER)  

·   Read:  Chapters 20, 21, and 25 of the Elmasri textbook

·   Take:  Quiz on Chapters 20, 21, and 25 of Elmasri  (11/12/09)

·   Read:  Unit Ten of the online notes (OODB, Dist. Databases)

·   Take:  Quiz on Unit Ten online notes  (11/12/09)

 

Nov 12 – Unit 10: Object Oriented/Distributed Databases

 

FOR NEXT CLASS (IF NOT SOONER)  

·   Read:  Chapters 23, 26, and 27 of the Elmasri textbook

·   Take:  Quiz on Chapters 23, 26, and 27 of Elmasri  (11/19/09)

·   Read:  Chapter twenty-four, section four of the Elmasri textbook

·   Read:  Unit Eleven of the online notes (Security, Web, XML)

·   Take:  Quiz on Unit Eleven online notes  (11/19/09)

 

Nov 19 Unit 11: Database Security, Web Databases, and XML

   

HW 4 Due

 

FOR NEXT CLASS (IF NOT SOONER)

·   Read:  Chapters 28, 29, and 30 Elmasri textbook

·   Take:  Quiz on Chapters 28, 29, and 30 of Elmasri (12/3/09)

·   Read:  Unit Twelve of the online notes (Data Warehousing, Mining)

·   Take:  Quiz on Unit Twelve online notes (12/3/09)

 

Nov 26  Thanksgiving Break - No Class

 

Dec 03 Unit 12: Data Warehousing, Data Mining

 

HW 5 Due

  

FOR NEXT CLASS (IF NOT SOONER)

·  Submit:  Final questions by Wednesday, December 9th, 7 PM.

·  Study!

 

Dec 10 Final Exam: Closed Book, Closed Notes, Starts at 7 PM in Delta 241

 

Other Policies

Homework, Projects, Research Paper

  • Homework and projects are due exactly at the prescribed time (usually the beginning of class). As soon as a homework or project is collected, then all others are considered 1 day late (even if it only 3 minutes). In the event you might be running late, you might want to email the assignment. Also, when preparing your assignment, be mindful of possible backlogs at the printer, jammed printer, printer out of toner, etc.

  • Late homework/projects are accepted with a penalty of 10% deduction per 24-hour period after the due date. No late project will be accepted one week after the due date. The last homework/project cannot be late.

  • There will be no extra-credit homework or projects in this course.

  • All homework and projects must be typed not hand-written.

  • A cover page is expected for all homework and projects. A sample of this cover page is included in the first assignment.

  • VERY IMPORTANT! In certain classes students are encouraged to work in groups. For this class you are expected to work on all homework and projects individually. Students may not discuss, use, email, show, give, buy, sell, borrow, trade, steal, download from the Internet, etc. in whole or part, any of the homework or projects in any manner not prescribed by the instructor. This condition applies even after you complete this course! Penalty for cheating will be extremely severe and may result in an F for this course.

  • Handing in an assignment for another student is considered cheating. Penalty for cheating will be extremely severe and may result in an F for this course.

  • VERY IMPORTANT! Failing to report to the instructor any incident in which a student witnesses an alleged violation of the Academic Honesty Code is considered a violation of the academic honesty code. Please see me to discuss any incidents.

  • VERY IMPORTANT! Purchasing, or otherwise acquiring and submitting as one's own work any research paper or any other writing assignment prepared by others constitutes cheating. Penalty for cheating will be extremely severe and may result in an F for this course.

  • Standard academic honesty procedure will be followed. See the following link for additional information.

Tests, Quizzes

  • There are no make-up tests except in verified medical emergencies and with immediate notification. Rescheduling a final exam in order to catch a plane flight is unacceptable. Make up exams are harder, and different, than original exams.

  • There are no make-up quizzes. Allow plenty of additional time in the event that webCT crashes.

  • You are responsible for all the readings assigned throughout the semester.

  • Students are to work on test and quizzes individually.  Students may not discuss, show, give, sell, borrow, trade, share, etc. their tests or quizzes. Penalty on cheating will be extremely severe. Standard academic honesty procedure will be followed.

  • VERY IMPORTANT! Providing answers for any assigned work or 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. Penalty for cheating will be extremely severe and may result in an F for this course.

  • VERY IMPORTANT! Failing to report to the instructor any incident in which a student witnesses an alleged violation of the Academic Honesty Code is considered a violation of the academic honesty code. Please see me to discuss any incidents.

Miscellaneous

  • Any person with a disability who requires a special accommodation should inform me and contact the Disability services office or call 281 283 2627 as soon as possible.

  • Incomplete grades or administrative withdrawals occur only under extremely rare situations.

  • 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.

  • As a web-based class, there is no formal attendance policy. However, it is my experience that those students who do attend class on a regular basis do better on tests than those that don't.

  • I am willing to provide letters of recommendation/references only if you have attained an 'A' in one of my classes, or two 'A-' in two of my classes.

  • I highly recommend that you seek out your advisor and complete you Candidate Plan of Study (CPS) as soon as possible. I am normally not available for advising during the summer months.

  • Pay very careful attention to your email correspondence. It reflects on your communication skills. Below is a compilation of email errors I have received during the past year.

dear sir.

wen r u gonna grad the homework, bcoz i have a doubt about the third problem

Some student

Common problems:

   *   wen instead of when

   *   bcoz instead of because

   *   r instead of are

   *   u instead of you

   *   lowecase i instead of I

   *   starting a sentence with a lowercase letter

   *   doubt instead of question

  • I immediately discard anonymous emails.

Return to Top


HomeUHCLSCE



2700 Bay Area Boulevard
Delta Building. Office 171
Houston, Texas 77058
Voice: 281-283-3805
Fax: 281-283-3869
boetticher@uhcl.edu


© 2002-2009 Boetticher:  Database Course, All Rights Reserved.

Undergrad courses taught by Dr. Boetticher
Graduate courses taught by Dr. Boetticher

Locations of visitors to this page