Yan Chen, Assistant Professor
Room 330,
Office Hours: Thursday. 2-4pm or by appointment, Rm 330,
Yi Qiao
yqiao AT cs.northwestern.edu
Office Hours: Wednesday 2-4pm, Rm 246,
Earl Wagner
ewagner AT cs.northwestern.edu
Office Hours (by Jin Hu after the midterm): Monday 4:30-6:30pm, Rm 252,
· Lectures: Tuesday and Thursday 9:30-10:50am, Tech LR5.
·
Recitation:
Tu. Rm 381, 1890 Maple Ave.
1. bfore midterm 6-7pm
2. after midterm 5-6pm
This course is an introduction to the use of database systems for the implementation of information systems. In this course, you will become acquainted with various data models and see what goes into database design. The first half of the course will largely be devoted to understanding the data models that are commonly used in designing databases. The second half of the course will be spent putting these ideas to use in implementing a reasonably large information system.
There will be a midterm and a final exam. Exams will be in-class, closed-book, and will cover materials from lectures, required readings and projects. The final exam will not be cumulative.
There will be two kinds of homework assignments: reading assignments and textbook-style questions. You should have finished the assigned reading before coming to lecture. In addition, there will be about four sets of written homeworks.
Over
the course of the quarter, you will use Microsoft Access to design a database
in two projects. The first project is on
the entity-relational (ER) model, and the second project is about relational algebra
(RA) and relational calculus (RC).
Notes:
Date |
Lectures Topics |
|
Assignment |
Th 3/31 |
Class overview, Introduction to Database |
|
|
Tu 4/5 |
Entity-Relationship Model |
|
|
Th 4/7 |
Entity-Relationship Model (cont’d) |
|
|
Tu 4/12 |
Relational Data Model |
Ch 3.1-3.3 |
|
Th 4/14 |
Relational Data Model (cont’d) |
|
|
Tu 4/19 |
Functional Dependencies |
|
|
Th 4/21 |
Normal Forms, BCNF and 3NF |
|
|
Tu 4/26 |
Multivalued Dependencies |
|
|
Th 4/28 |
Midterm Review |
|
|
Tu 5/3 |
Midterm |
||
Th 5/5 |
Relational Algebra |
|
|
Tu 5/10 |
Relational Algebra (cont’d) |
|
|
Th 5/12 |
SQL Queries |
|
|
Tu 5/17 |
SQL Queries and Data-definition |
|
|
Th 5/19 |
SQL: Views, Constraints |
|
|
Tu 5/24 |
SQL: Trigger, PSM |
|
|
Th 5/26 |
System Aspects of SQL, Object-Relational DBMS |
|
|
Tu 5/31 |
More OR Systems, Semistructured Data/XML |
|
|
Th 6/2 |
Review for final |
|
|