CSCI 5333.3
DBMS
Spring 2012

by K. Yue

1. General

• Course information: course description, instructor and teaching assistant information, course syllabus, policies and guidelines.
• Course site of the previous semester can be helpful: Fall 2011.
• Please check the Yahoo group: UHCL_Yue_DBMS, a private group via invitation. Please include your student id when requesting to join.

2. Project Assignments and Examinations

Homework

• Homework #1: due 2/8/2012 (Wed)
  • Suggested Solution to HW #1:
    • Use case diagram: vsd, pdf.
    • Class diagram: vsd, pdf.
  • Grading notes written by the TA.
• Homework #2: due 2/20/2012 (Mon)
  • Suggested Solution to HW #2
• Grading notes written by the TA.
• Homework #3: due 2/29/2012 (Wed)
  • Suggested Solution to HW #3
• Homework #4: due 3/19/2012 (Mon)

Classroom Demo

• coming soon.

Examinations

• coming

3. Course Notes

Introduction: (Read Chapters 1, 2 and 3)

• Introduction: classwork.
• Introduction to DB Architecture.

Data Modling: (Read Chapters 7 to 10)

• Introduction to DB Modeling.
• Introduction to UML/DB Modeling.
• Mapping UML class diagrams to relational schema.
• Toy library sample class diagram
• A suggested sample solution to EN7-16.

Query Languages: (Read Chapters 3 to 6)

• Introduction to the relational model.
• Relational Algebra.
• Relational Calculus
• Introduction to SQL.
• PHP MySQL Web Development (Read Chapter 14)