DASC 5333 Database Systems for Data Science
CSCI 4333 Design of Databse Systems
Spring 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 2023, Fall 2023
    2. DASC 5333:Spring 2023, 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
  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. Echo 360 lecture video links in Canvas: only when available, courses will be entirely face to face.
  12. Colloquium attendance: Attending CSE Colloquium for Bonus Yue.pdf (may not have colloquium this semester)

2. Homework Assignments

Homework:

Homework
Due
 Suggested Solutions
HW #1 (toyu in Access: toyu.accdb, relational schema: toyu_relations.pdf) 2/7 Wednesday 10:00pm h1sol.pdf
HW #2 (toyu MySQL script: createtoyu.sql.txt) 2/14 Wednesday 10:00pm h2sol.sql.txt
HW #3 2/28 Wednesday 10:00pm h3sol.pdf
HW #4 (h4sol_template.docx): use h3sol.pdf (to appear) 3/15 Friday 10:00pm h4sol.pdf
HW #5: (swim: SWIM Db, plenty of examples & SQL script: createSwimDB.sql.txt
 3/29 Friday 10:00pm h5sol.sql.txt
HW #6: 4/8 Monday 10:00pm h6.py.txt
HW #7: (h7q1_template.docx: to appear) 4/18 Thursday 10:00pm h7q1sol.pdf, h7sol.pdf
HW #8: toyu-db.gz 4/26 Friday 10:00pm h8sol.js.txt

3. Examinations

Mid-term 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.

  1. CSCI 4333.1 & CSCI 4333.2: 3/6 Wednesday
  2. DASC 5333.1: 3/5 Tuesday (no lecture that day)

Final Examination: Closed book. However, you can bring two 'information' sheets: A4, print or write both sides, which must be prepared by yourself.

  1. CSCI 4333.1: 5/1 Wednesday 1:00 - 3:00pm
  2. CSCI 4333.2: 5/1 Wednesday 4:00pm - 6:00pm
  3. DASC 5333.1: 4/30 Tuesday 1:00pm - 3:00pm

Examinations' Suggested Solutions