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

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)

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

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.

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

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 4^th, 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

Home • UHCL • SCE

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.