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 August 23, 2021

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)

Wednesday 7:00 - 9:50 PM, Delta 241 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

Ms. Simran Goyal

Email: GoyalS5610@uhcl.edu

TA Hours:

     Tuesday 7 - 10 PM, Wedneday 12 - 4 PM (Dr. Boetticher's Students have preference)

     Thursday 12 - 7 PM (Dr. Wei's Students have preference)

     A Zoom link for Ms. Goyal will be provided in the Google folder.

 

 

 

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
 Cell phone/texting (-3 per infraction) (Face-to-face class) ???
 Absent/late (-2 for each time after first) (Face-to-face class) ???
 Class Preparation policy (+2 to start, -1 for each miss) (Face-to-face class) ???

Grades will be based solely on criteria listed above. No other factors will be considered. Below are some of factors that will not be considered:

  • Expected a higher grade
  • Good course participation
  • Good improvement during the semester
  • Have put in extra effort
  • Need to avoid probation
  • Financial needs
  • Loss of scholarship
  • Loss of job opportunity
  • Loss of practical training opportunity
  • Need to graduate
  • Company relocation
  • Immigration status needs
  • Family needs
  • Sickness during the semester

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/  ***

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

 

Aug 25 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:  Wednesday, September. 15, 2021 at 7 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 7 PM on Sep. 8, 2021.

               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 7 PM on Sep. 8, 2021.

   Quiz:  Complete Quiz 02 - Unit 01 Online Materials. This is due by 7 PM on Sep. 8, 2021.

   Quiz:  Complete Quiz 03 - Chapters 3, 4 and 9 of Elmasri. This is due by 7 PM on Sep. 8, 2021.

   Quiz:  Complete Quiz 04 - Unit 02 Online Materials. This is due by 7 PM on Sep. 8, 2021.

 

   

 

   

 

   

 

Sep 01 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 7 PM on Sep. 8, 2021.

   Quiz:  Complete Quiz 06 - Unit 03 Online Materials. This is due by 7 PM on Sep. 8, 2021.

 

 

 

  

Sep 08 Unit 3: Relational Algebra

 

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

Point value: 100 points

Due date:  Wednesday, September 22, 2021 at 7 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 7 PM on Sep. 15, 2021.

   Quiz:  Complete Quiz 08 - Unit 04 Online Materials. This is due by 7 PM on Sep. 15, 2021.

  

Sep 15 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:  Wednesday, September 29, 2021 at 7 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 7 PM on Sep. 22, 2021.

 

 

 

 

 

 

 

Sep 22 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:  Wednesday, October 6, 2021 at 7 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 7 PM on Sep. 29, 2021.

 

 

  

Sep 29 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:  Wednesday, October 13, 2021 at 7 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 7 PM on Oct. 6 2021.

 

 

 

 

 

 

 

Oct 06 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, October 17, 2021 at 7 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 7 PM on Oct. 13, 2021.

   Quiz:  Complete Quiz 13 - Unit 07 Online Materials. This is due by 7 PM on Oct. 13, 2021.

  

 

 

 

 

Oct 13 - Unit 7: Normal forms up to 4NF, Paired Attribute Algorithm, Review

 

Assignment 5 is due

 

   Submit:  Midterm questions by Tuesday, October 19, 2021, 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!

 

 

Oct 17 Sunday - Assignment 6 is due at 7 PM via email

 

Oct 20 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 7 PM on Oct. 27, 2021.

   Quiz:  Complete Quiz 15 - Unit 08 Online Materials. This is due by 7 PM on Oct. 27, 2021.

   Read:  Unit Nine of the online notes

   Quiz:  Complete Quiz 16 - Unit 09 Online Materials. This is due by 7 PM on Oct. 27, 2021. 

  

  

 

 

 

 

Oct 27 Unit 8: Physical DB Design

             Unit 9: Oracle Architecture

Assign Assignment 7 - Physical Database Design

Point value: 100 points

Due date:  Wednesday, November 10, 2021 at 7 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 7 PM on Nov. 3, 2021.

   Quiz:  Complete Quiz 18 - Unit 10 Online Materials. This is due by 7 PM on Nov. 3, 2021.

 

 

Nov 03 Unit 10: Tran. Processing, Concurrency Control, Recovery

 

Assign Assignment 8 - Transaction Processing

Point value: 100 points

Due date:  Wednesday, December 1, 2021 at 7 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 7 PM on Nov. 10, 2021.

   Quiz:  Complete Quiz 20 - Unit 11 Online Materials. This is due by 7 PM on Nov. 10, 2021.

******** November 8 Last day to withdraw ********

 

Nov 10  Unit 11: Distributed Databases/ Cloud Computing / NOSQL

 

Assignment 7 is due

 

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 7 PM on Nov. 17, 2021.

   Quiz:  Complete Quiz 22 - Unit 12 Online Materials. This is due by 7 PM on Nov. 17, 2021.

 

Nov 17  Big Data - Mongo DB

 

Assign Assignment 9 - Big Data and Mongo DB

Point value: 100 points

Due date:  Sunday, December 5, 2021 at 7 PM.

 

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 7 PM on Dec. 1, 2021.

   Quiz:  Complete Quiz 24 - Unit 13 Online Materials. This is due by 7 PM on Dec. 1, 2021.

  

Nov 24 - Thanksgiving - No Class

 

Dec 01 Unit 12: Data Warehousing, Data Mining, Review

 

FOR NEXT CLASS (IF NOT SOONER)

  Submit:   Final questions by Tuesday, Dec 7th, 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!

 

Dec 05 Sunday - Assignment 9 is due at 7 PM via email

 

Dec 08 Final Exam: Closed Book, Closed Notes

 

Other Policies

Homework, Projects, Research Paper

 

Please note: In your previous academic institution it may have been acceptable to exchange homework assignments, quizzes, or projects. For this class you are expect not to share homework assignments, quizzes, projects, and exams.

Also, after you have completed the course you are expected not to share any course materials with any future students.

  • 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 for most assignments. 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 will result at least a one letter grade reduction in your final grade. It could result in an F for this course. There may be some group assignments for this class. If there is inappropriate sharing among two or more groups, then all students will be considered guilty. Choose your partner very carefully!

  • 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. Here is another good article about plagiarism.

Tests, Quizzes

 

 There may be 2 sections of this course: a Pure Web-based and a face-to-face.

Please note the differences below

  • There are no make-up tests except in verified medical emergencies and with immediate notification.

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

Face-to-face: Rescheduling a final exam in order to catch a plane flight in order to go back home without a significant reasons and corresponding documentation is unacceptable.

Make up exams are harder and different from the original exams.

 

Web-based: You do not need to attend any lectures on campus. Also, you do not need to show up in  person to take the exams. However, you may attend any/all of the face-to-face lectures and/or exams. 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. If you will be off-campus during the exams, please make the necessary arrangements with me as soon as possible.

 

Mixed: Since I do not know how well the AV equipment works on campus, it is best to be on campus when the class is face-to-face.  Zoom-based classes will be recorded. Thus, you do not need to show up for online lectures. 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. Exams may be face-to-face or via Respondus in Blackboard.

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

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

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

  • You need to bring a hard copy of the notes to class. Laptops will be permitted only during demo (usually SQL) usage.

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

    Also, sending and/or receiving text messages during class is extremely rude and disruptive. Please turn off all cell phones, watches, and pagers prior to the start of class.

    If I see (even if the cell phone is off) or hear a cell phone during class, or see a student texting during class,   then 3 points will be deducted for each infraction from your final course average.

  • Attendance Policy:

Face-to-face: Students enrolled in the face-to-face section are expected to attend all lectures. A student is allowed to miss one class without penalty. Each addition absence will result in 2-point reduction of your final grade. Any student not present during class roll will be considered absent. This applies even if a student arrives one minute after class roll. Sometimes I take roll a second time after the break, so make sure you get back to class on time.

 

Pure Web-based: You do not need to attend any lectures on campus. Also, you do not need to show up in  person to take the exams. However, you may attend any/all of the face-to-face lectures and/or exams. 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. If you will be off-campus during the exams, please make the necessary arrangements with me as soon as possible.

  • Class Preparation Policy. To strongly encourage you to be a student "driven to learn," I am implementing the following "class preparation policy" in all face-to-face sections. You start with 2 bonus points added to your final grade. You will lose 1 point during class if I ask a review question that you are unable to answer. Review questions are different from opinion questions or open-ended questions. To make sure you are prepared, review all course notes at least 5 times prior to coming to class. It is possible to capture a point from another student's ignorance.

  • 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 an actual email I received  from a student. How many errors can you find?

Dear boeticher,

Is there any chance of regrading my final grade. As i'am very nervous in exam i couldn't be able to attempt properly. you know how attentive in class and can u please grade me considering my class participation also or do i have a chance of re exam because c grade draws my gpa low which results in loosing my scholorship, Please consider my request.

Thanks and Regards

Some Student

Common problems:

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

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

Locations of visitors to this page