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

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 Blackboard (for HW submission and external copyrighted materials): logon Blackboard at UHCL and navigate to the course page.
  5. Course pages of previous semesters:
    1. CSCI 4333: Spring 2023, Fall 2022
    2. DASC 5333:Spring 2023, Fall 2022.
  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. Course objective satisfaction survey:
    1. CSCI 4333.1 (MW 1-2:20pm): https://sceweb.sce.uhcl.edu/abet2012/content/test/feedbackform.php?courseName=CSCI4333-Design&sem=fall&year=2023&class=01
    2. CSCI 4333.2 (MW 4-5:20pm): https://sceweb.sce.uhcl.edu/abet2012/content/test/feedbackform.php?courseName=CSCI4333-Design&sem=fall&year=2023&class=02
    3. DASC 5333: https://sceweb.sce.uhcl.edu/abet2012/content/test/feedbackform.php?courseName=DASC5333-Database&sem=fall&year=2023&class=01

  9. Useful video (such as setting up XAMPP, MySQL, etc).
  10. Student Corner: student sharing self-made resources.
  11. My regular office hour will be held on 8/21/2023 to 11/29/2023: MW 2:20PM to 3:50PM, 5:20-6:00pm and T3:50-4:20PM. Office hours will be conducted in person (Delta 163) and upon request, via Zoom meeting: 616 099 762.
  12. Zoom's lecture video links in Blackboard: likely no longer available as courses with be entirely face to face.
  13. Colloquium attendance: Attending CSE Colloquium for Bonus Yue.pdf (may not have colloquium this semester)

2. Homework Assignments and Examinations

Homework:

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

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: 10/11 Wednesday
  2. DASC 5333.1: 10/10 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: 12/6 Wednesday 1:00 - 3:00pm
  2. CSCI 4333.1: 12/6 Wednesday 4:00pm - 6:00pm
  3. DASC 5333.1: 12/5 Tuesday 1:00pm - 3:00pm

Examinations' Suggested Solutions