CSCI 4333
Design of Database Systems
Fall 2020
by K. Yue

1. General

  1. General Information and Grading Policy (course description, instructor and teaching assistant information, grading, etc)
  2. Course Policy
  3. Syllabus and Schedule (you can find lecture notes here.)
  4. Zoom's office hour's virtual meeting place.
  5. Course pages of previous semester: Summer 2020, Spring 2020, Fall 2019, Spring 2019,
  6. Classroom Demonstration
  7. Useful video (such as setting up XAMPP, MySQL, etc).
  8. Applied Critical Thinking.
  9. Colloquium attendance: Attending CSE Colloquium for Bonus Yue.pdf (may not have colloquium this semester)
  10. Course evaluation: https://apps.uhcl.edu/OnlineEvals

2. Homework Assignments and Examinations

Homework:

,
Homework
Due
 Suggested Solutions
HW #1 (toyu.accdb used in HW #1, schema: toyu_relations.pdf) 9/1 (Tuesday) 10:00pm: extended to 9/3 (Thursday) 10:00pm because of Laura  
HW #2 (createtoyu.sql.txt used) 9/8 (Tuesday) 10:00pm: extended to 9/10 (Thursday) 10:00pm because of Laura  
HW #3; no submission will be accepted after 9/20. 9/18 (Friday) 10:00pm  
HW #4 (h4sol_template.docx): use h3sol.pdf 9/25 (Friday) 10:00pm
  
HW #5: (Description: SWIM Db); (SQL files for creation and population: createSwimDB.sql.txt, PopulateSwim.sql.txt) 10/2 (Friday) 10:00pm
  
HW #6 10/19 (Monday) 10:00pm  
HW #7 11/9 (Monday) 10:00pm  
HW #8: (h8q1_template.docx) 11/26 (Thursday) 10:00pm
  

Examinations