CSCI 4333 Design of Database Systems
Fall 2025

1. General

  1. Course information and grading policy: course description, instructor and teaching assistant information, office hours, grading, etc. for this course.
  2. General course policy: general course policy for all my courses.
  3. Lecture Notes, Syllabus and Schedule: you can also find links to lecture notes here.
  4. Course pages in Canvas (for HW submission and external copyrighted materials): logon to Canvas at UHCL and navigate to the course page.
  5. Course pages of previous semesters:
    1. CSCI 4333: Spring 2025, Fall 2024
    2. DASC 5333:Spring 2025, Fall 2024.
  6. Classroom Demonstration: demonstration files developed during the lecture.
    1. CSCI 4333 Demonstration
  7. Course evaluation: https://apps.uhcl.edu/OnlineEvals
  8. ABET exit survey on satisfaction of course objectives:
    1. Section 1
    2. Section 2
  9. Useful video (such as setting up XAMPP, MySQL, etc).
  10. Student Corner: student sharing self-made resources.
  11. My regular office hours will be held on 8/18/2025 to 12/1/2025: MW 11:20PM to 11:50PM and MW 2:50pm to 3:50pm. Office hours will be conducted in person (Delta 163) and upon request, via Zoom meeting: 616 099 762.

2. Homework Assignments

Homework
Due
 Suggested Solutions
HW #0 8/25 Monday
10:00pm
HW #1 using toyu 9/4 Thursday
10:00pm		 h1sol.sql.txt
HW #2 9/23 Tuesday
10:00pm		 h2sol.pdf
HW #3 (h3sol_template.docx): use h2sol.pdf 10/3 Friday
10:00pm		 h3sol.pdf
HW #4: using Swim 10/16 Thursday
10:00pm		 h4sol.sql.txt
HW #5: using toyu
 10/23 Thursday 10:00pm h5sol.sql.txt
HW #6: using Swim 11/6 Thursday 10:00pm h6.py.txt, better structured: h6_alt.py.txt
HW #7: h7q1_template.docx 11/13 Thursday 10:00pm h7q1_sol.pdf, h7sol.pdf
HW #8: Using toyu in Mongo, toyu-db.gz 11/25 Tuesday 10:00pm h8sol.js.txt


3. Examinations

Mid-term Paper Exam, in person, class time (one hour 20 minutes): Closed book. However, you can bring an 'information' sheet: A4, print or write both sides, which must be prepared by yourself. The relation schema and instance of toyu db will be provided to you.

  1. CSCI 4333.1 and .2: 10/8 Wednesday class time

Final Paper Examination: In person. Closed book. However, you can bring two 'information' sheets: A4, print or write both sides, which must be prepared by yourself. The relation schema and instance of toyu db will be provided to you.

  1. CSCI 4333.1: 12/3 Wednesday 10:00AM - noon
  2. CSCI 4333.2: 12/3 Wednesday 4:00PM - 6:00PM

3.1 Examinations' Suggested Solutions