DASC 5333 Database Systems for Data Science
CSCI 4333 Design of Databse Systems
Fall 2024

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 2023
    2. DASC 5333:Spring 2024, Fall 2023.
  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 (11/16/2024 - 11/30/2024)
  8. Useful video (such as setting up XAMPP, MySQL, etc).
  9. Student Corner: student sharing self-made resources.
  10. My regular office hour will be held on 1/16/2024 to 4/29/2024: MW 2:25PM to 3:45PM, 5:20-5:40Pm and T3:50-4:10PM. Office hours will be conducted in person (Delta 163) and upon request, via Zoom meeting: 616 099 762.
  11. Colloquium attendance: Attending CSE Colloquium for Bonus Yue.pdf (may not have colloquium this semester)

2. Homework Assignments

Homework
Due
 Suggested Solutions
HW #0   Not Applicable
HW #1 using toyu 9/6 Friday 10:00pm h1sol.sql.txt
HW #2 9/20 Friday 10:00pm h2sol.pdf
HW #3 (h3sol_template.docx): use h2sol.pdf 10/2 Wednesday 10:00pm h3sol.pdf
HW #4: using Swim 10/11 Friday 10:00pm h4sol.sql.txt
HW #5: using toyu, mailcode.csv
 10/25 Friday 10:00pm h5sol.sql.txt
HW #6: using Swim 11/11 Monday 10:00pm h6.py.txt
HW #7: (h7q1_template.docx: to appear) 11/21 Thursday 10:00pm h7q1_sol.pdf, h7sol.pdf
HW #8: Using toyu in Mongo, toyu-db.gz 11/28 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: 10/9 Wednesday
  2. DASC 5333.1: 10/8 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: 12/4 Wednesday 1:00 - 3:00pm
  2. CSCI 4333.2: 12/4 Wednesday 4:00pm - 6:00pm
  3. DASC 5333.1: 12/3 Tuesday 1:00pm - 3:00pm

3.1 Examinations' Suggested Solutions