DASC 5333 Database Systems for Data Science
CSCI 4333 Design of Databse Systems
Spring 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 2024, Fall 2024
    2. DASC 5333:Spring 2024, Fall 2024.
  6. Classroom Demonstration: demonstration files developed during the lecture.
    1. CSCI 4333 Demonstration
    2. DASC 5333 Demonstration
  7. Course evaluation: https://apps.uhcl.edu/OnlineEvals (4/14/2025 to 4/28/2025)
  8. Useful video (such as setting up XAMPP, MySQL, etc).
  9. Student Corner: student sharing self-made resources.
  10. My regular office hours will be held on 1/14/2025 to 4/28/2025: MW 2:25PM to 3:45PM and Tuesday 3:50-4:10PM. 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 1/22 Wednesday 10:00pm
HW #1 using toyu 1/31 Friday 10:00pm h1sol.sql.txt
HW #2 2/19 Wednesday 10:00pm h2sol.pdf
HW #3 (h3sol_template.docx): use h2sol.pdf 3/3 Monday
10:00pm		 h3sol.pdf
HW #4: using Swim 3/12 Wednesday 10:00pm h4sol.sql.txt
HW #5: using toyu
 3/26 Wednesday 10:00pm h5sol.sql.txt
HW #6: using Swim 4/10 Thursday 10:00pm h6.py.txt
HW #7: h7q1_template.docx 4/17 Thursday 10:00pm h7q1_sol.pdf, h7sol.pdf
HW #8: Using toyu in Mongo, toyu-db.gz 4/24 Thursday 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 & CSCI 4333.2: 3/5 Wednesday
  2. DASC 5333.1: 3/4 Tuesday (no lecture that day)

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: 4/30 Wednesday 1:00 - 3:00pm
  2. DASC 5333.1: 4/29 Tuesday 1:00pm - 3:00pm

3.1 Examinations' Suggested Solutions