re boe
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
Updated January 14, 2022

Office and Address

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

Class Hours (Face-to-Face or Online)

Thursday 4:00 - 6:50 PM, Delta 234 or via Zoom

 

Office Hours

Wednesday 2 to 4 PM; Thursday 3 to 4 PM, or by appointment. Students with appointments have priority. If the suite door is locked, then call my extension (last 4 digits) using the phone in the hallway. Students who have an appointment will have priority over those students who don't. During the COVID-19 situation, you will be emailed a Zoom link.

Teaching Assistant

Mr. Rahul Rajendran
Email: RajendranR5206@UHCL.edu

TA Hours:

     Monday      6 -  9 PM

     Tuesday     6 -10 PM

     Wednesday 1 - 4 PM

     Thursday   10 - 2 PM

    

 

 

Blackboard link

Required Textbook

 

Elmasri, R., Navathe, S., Fundamentals of Database Systems Benjamin Cummings, Seventh Edition, 2016.

 

 

 

 

 

 

Reference Materials

Proc. of SIGMOD Conf: ACM-Special Int Group 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 University 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:

  • Model problems using various conceptual design approaches using a modeling language such as EER or UML Class diagrams.

  • Understand the precise concepts and issues associated with designing a relational database (e.g. normalization, good decomposition, foreign keys).

  • Comprehend various normal forms and their uses in logical inferences in database design.

  • Apply relevant query language concepts and techniques to accurately answer queries (question).

  • Understand physical database design concepts and issues (e.g. indexing).

  • Understand some of the important relevant issues (e.g. ACID, SQL transactions) in transaction processing, concurrency control, and database recovery.

  • Understand one or more advanced topics in databases, their purposes and relevance (e.g. NOSQL).

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

Lecture, seminar, case studies, and interactive problem solving. Lecture supplemented with You Tube videos.

Appraisal

 Assignments:  15% of the total
 Quizzes (Blackboard and in-class): 

  5% of the total

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

Grades will be based solely on criteria listed above. No other factors will be considered.

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:

Foster disciplined, altruistic passion.

Schedule  (Tentative)

************************************************************************

***   With the uncertainty of the COVID-19 situation, some classes   ***

***   may be taught vis Zoom. This is subject to change.             ***

***   Please constanstly check your UHCL email for updates.          ***

***                                                                  ***

***   Please see: WK00 - COVID-19 FYI for in-class policies          ***

***                                                                  ***

***   Please see: https://www.click2houston.com/health/2020/03/22/chart-houston-area-coronavirus-cases-in-the-past-week/  ***

************************************************************************

 

Jan 20 Unit 1: Overview and Syllabus, Intro, DB Lifecycle (1.5 hours), Intro to EER (1.5 hours)

************************************************************************

***   All course materials are located in the Google Drive folder.   ***

***   You are expected to bring a copy of the notes to all lectures. ***

***   I strongly recommend you place the notes in a 3-ring binder.   ***

************************************************************************

 

Assign Assignment 1 - EER and UML Diagrams - Individual Assignment

Point value: 100 points

Due date:  Thursday, February. 10, 2022 at 4 PM. Bring a hard copy to class

 

FOR THIS WEEK (IF NOT SOONER)  

   Read:  Syllabus

   Read:  Online Orientation (Blue color = Available on the Google Drive)

 

   

 

   Read Chapters One and Two of the Elmasri textbook

 

 

 

   Read:  Unit One of the online notes

                         

             It is the student's responsibility to download the notes, print the notes, and bring them to class.

 

FOR NEXT WEEK (IF NOT SOONER)  

   Read:  Chapters 3, 4, and 9 of the Elmasri textbook

   Read:  Unit Two of the online notes

   Quiz:  Complete Quiz 00 - Syllabus and Online Orientation. This is due by 4 PM on Feb. 3, 2022.

               You may take the syllabus quiz multiple times. However, you cannot proceed to other quizzes

                until you get a perfect score on the syllabus quiz. All other quizzes may be taken only one time.

   Quiz:  Complete Quiz 01 - Chapters 1 and 2 of Elmasri. This is due by 4 PM on Feb. 3, 2022.

   Quiz:  Complete Quiz 02 - Unit 01 Online Materials. This is due by 4 PM on Feb. 3, 2022.

   Quiz:  Complete Quiz 03 - Chapters 3, 4 and 9 of Elmasri. This is due by 4 PM on Feb. 3, 2022.

   Quiz:  Complete Quiz 04 - Unit 02 Online Materials. This is due by 4 PM on Feb. 3, 2022.

 

   

 

   

 

   

 

Jan 27 Unit 2: Conceptual Design: EER/UML diagrams continued, FTD Florist Shop

 

FOR NEXT WEEK (IF NOT SOONER)

   Read:  Chapters 5 and 8.1 to 8.5 (pages 239 to 268) of the Elmasri textbook

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

   Quiz:  Complete Quiz 05 - Chapters 5 and 8.1 to 8.5 of Elmasri. This is due by 4 PM on Feb. 3, 2022.

   Quiz:  Complete Quiz 06 - Unit 03 Online Materials. This is due by 4 PM on Feb. 3, 2022.

 

 

 

  

Feb 03 Unit 3: Relational Algebra

 

Assign Assignment 2 - Individual Assignment - Mapping EER to Code, Relational Algebra

Point value: 100 points

Due date:  Thursday, February 17, 2022 at 4 PM. Bring a hard copy to class

 

FOR NEXT WEEK (IF NOT SOONER)

   Read:  Chapters 6 and 7 of the Elmasri textbook

   Read:  Unit Four of the online notes

   Quiz:  Complete Quiz 07 - Chapters 6 and 7 of Elmasri. This is due by 4 PM on Feb. 10, 2022.

   Quiz:  Complete Quiz 08 - Unit 04 Online Materials. This is due by 4 PM on Feb. 10, 2022.

  

Feb 10 Unit 4: SQL, Triggers, Cursors, PL/SQL (1.5 hours), Hands-on 1.5 hours

 

Assignment 1 is due

 

Assign Assignment 3 - Individual Assignment - SQL

Point value: 100 points

Due date:  Thursday, February 24, 2022 at 4 PM.

 

FOR NEXT WEEK (IF NOT SOONER)  

   Read:  Chapters 14 and 15 of the Elmasri textbook

   Read:  Unit Five of the online notes

   Quiz:  Complete Quiz 09 - Unit 05 Online Materials. This is due by 4 PM on Feb. 17, 2022.

 

 

 

 

 

 

 

Feb 17 Unit 5: Relational Database Design Theory

  

Assignment 2 is due

 

Assign Assignment 4 - Individual Assignment - Closure, Armstrong's Axioms

Point value: 100 points

Due date:  Thursday, March 3, 2022 at 4 PM. Bring a hard copy to class.

 

FOR NEXT CLASS (IF NOT SOONER)

   Read:  Unit Six of the online notes (Decomposition of Relations)

   Quiz:  Complete Quiz 10 - Unit 06 Online Materials. This is due by 4 PM on Feb. 24, 2022.

 

 

  

Feb 24 Unit 6: Min. covers, lossless joins, preserving depend.

 

Assignment 3 is due

 

Assign Assignment 5 - Individual Assignment - Min. Cover, Lossless Join, Preserving Dependencies

Point value: 100 points

Due date:  Thursday, March 10, 2022 at 4 PM. Bring a hard copy to class.

 

FOR NEXT CLASS (IF NOT SOONER)

   Read:  Unit Seven of the online notes (Normal Forms)

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

   Quiz:  Complete Quiz 11 - Unit 07 Online Materials. This is due by 4 PM on Mar. 3 2022.

 

 

 

 

 

 

 

Mar 03 Unit 7: Normal forms up to 4NF

 

Assignment 4 is due

 

Assign Assignment 6 - Individual Assignment - Normal Forms, Bernstein's Synthesis, Paired Attribute Alg.

Point value: 100 points

Due date:  Sunday, March 20, 2022 at 4 PM. Submit by email to boetticher@uhcl.edu

 

FOR NEXT CLASS (IF NOT SOONER)

   Read:  Unit Seven of the online notes (Boyce-Codd Normal Form and Fourth Normal Form)

   Quiz:  Complete Quiz 12 - Chapters 14 and 15 of Elmasri. This is due by 4 PM on Mar. 10, 2022.

   Quiz:  Complete Quiz 13 - Unit 07 Online Materials. This is due by 4 PM on Mar. 10, 2022.

  

 

 

 

 

Mar 10 - Unit 7: Normal forms up to 4NF, Paired Attribute Algorithm, Review

 

Assignment 5 is due

 

   Submit:  Midterm questions by Wednesday, March 23, 2022, 7 PM. This is optional.

                Use the template found on the Google Drive

                Strip out any identifying information (Your name, Student ID number)

                Specify whether you want me to post your questions on the Google Drive.

   Study!

 

Mar 17 ***** SPRING BREAK ****** NO CLASS *****

 

Mar 20 Sunday - Assignment 6 is due at 4 PM via email

 

Mar 24 Midterm: Closed Book, Closed Notes

 

FOR NEXT CLASS (IF NOT SOONER)  

   Read:  Chapters 16 and 17 of the Elmasri textbook

   Read:  Unit Eight of the online notes

   Quiz:  Complete Quiz 14 - Chapters 16 and 17 of Elmasri. This is due by 4 PM on Mar. 31, 2022.

   Quiz:  Complete Quiz 15 - Unit 08 Online Materials. This is due by 4 PM on Mar. 31, 2022.

   Read:  Unit Nine of the online notes

   Quiz:  Complete Quiz 16 - Unit 09 Online Materials. This is due by 4 PM on Mar. 31, 2022. 

  

  

 

 

 

 

Mar 31 Unit 8: Physical DB Design

             Unit 9: Oracle Architecture

Assign Assignment 7 - Physical Database Design

Point value: 100 points

Due date:  Thursday, Apr 21, 2022 at 4 PM.

 

FOR NEXT CLASS (IF NOT SOONER)  

   Read:  Chapters 20 through 22 of the Elmasri textbook

   Read:  Unit Ten of the online notes (Tran. Processing, Concurrency Control, Recovery)

   Quiz:  Complete Quiz 17 - Chapters 20 through 22 of Elmasri. This is due by 4 PM on Apr. 7, 2022.

   Quiz:  Complete Quiz 18 - Unit 10 Online Materials. This is due by 4 PM on Apr. 7, 2022.

 

 

Apr 07 Unit 10: Tran. Processing, Concurrency Control, Recovery

 

Assign Assignment 8 - Transaction Processing

Point value: 100 points

Due date:  Thursday, April 28, 2022 at 4 PM.

 

FOR NEXT CLASS (IF NOT SOONER)  

   Read:  Chapters 23 and 24 of the Elmasri textbook

   Read:  Unit Eleven of the online notes

   Quiz:  Complete Quiz 19 - Chapters 23 and 24 of Elmasri. This is due by 4 PM on Apr. 14, 2022.

   Quiz:  Complete Quiz 20 - Unit 11 Online Materials. This is due by 4 PM on Apr. 14, 2022.

******** April 12 Last day to withdraw ********

 

Apr 14  Unit 11: Distributed Databases/ Cloud Computing / NOSQL

 

FOR NEXT CLASS (IF NOT SOONER)

   Read:  Chapter 25 Elmasri textbook

   Read:  Unit Twelve of the online notes - Big Data and Mongo DB

   Quiz:  Complete Quiz 21 - Chapter 25 of Elmasri. This is due by 4 PM on Apr. 21, 2022.

   Quiz:  Complete Quiz 22 - Unit 12 Online Materials. This is due by 4 PM on Apr. 21, 2022.

 

Apr 21  Big Data - Mongo DB

 

Assignment 7 is due

 

FOR NEXT CLASS (IF NOT SOONER)

   Read:  Chapters 28 and 29 of the Elmasri textbook

   Read:  Unit Thirteen of the online notes - Data Mining and Data Warehouse

   Quiz:  Complete Quiz 23 - Chapters 28 and 29 of Elmasri. This is due by 4 PM on Apr. 28, 2022.

   Quiz:  Complete Quiz 24 - Unit 13 Online Materials. This is due by 4 PM on Apr. 28, 2022.

  

Apr 28 Unit 12: Data Warehousing, Data Mining, Review

 

Assignment 8 is due

 

FOR NEXT CLASS (IF NOT SOONER)

  Submit:   Final questions by Wednesday, May 4th, 7 PM. This is optional.

                Use the template found on the Google Drive

                Strip out any identifying information (Your name, Student ID number)

                Specify whether you want me to post your questions on the Google Drive.

  Study!

 

May 05 Final Exam: Closed Book, Closed Notes

 

Other Policies

This class has 6 simple rules:

1) Be respectful of others.

2) Be very passionate about your learning and do your best.

3) Be fearless - ask lots of questions in class.

4) Don't be late on anything.

5) Don't ever cheat.

6) Have fun!

 

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.

  • You are expected to come fully prepared to every class!

  • If there is any religious observance that may interfere with any scheduled exam, homework due date, or attending class, please notify me of the situation during the first 2 weeks of class so that adjustments can be made at that time.

  • Please turn off all cell phones, and pagers prior to the start of class.

  • 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 your Candidate Plan of Study (CPS) as soon as possible. I am normally not available for advising during the summer months.

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-2022 Boetticher:  Database Course, All Rights Reserved.

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

Locations of visitors to this page