Databases

1. Materials 

q      Introduction (slides)

q      A Sample (slides)

q      Database Building Procedure (slides)

q      Data Modeling: Class Diagram (slides)

q      Data Modeling: E-R Diagram (slides, slides with voice)

q      E-R Model to Relational Model (slides, slides with voice)

q      Functional Dependencies (slides)

q      Relational Database Design (slides)

q      Relational Algebra: Basic Operators (slides, slides with voice)

q      Relational Algebra: Complex Expression (slides)

q      SQL: Introduction (slides), Multi-Relations (slides),

q      SQL: More about SQL (slides)

q      SQL: Schema Definition and View (slides)

q      Constraints (slides)

q      Object Oriented DB (slides)

2. Design and Development Assignments

q      Assignment 1: Assignment in slides (DB-2.ppt)

q      Assignment 2: Exercise 3.2.1 and 3.4.4

q      Assignment 3: Exercise 5.2.1

q      Assignment 4: Exercise 6.2.3, Exercise 6.3.2 (due date: Nov. 21th)

q      Term Project Assignment, Sample Data

3. Announcements

q      Presentation on the interim report will be on Nov. 26th (Mon.) as scheduled

q      3rd Exam will be on Nov. 28th (Wed.) at Jedo-Kwan as scheduled.

4. Communications