| Time | T/Th 1:15-2:30pm | |
|
Location
|
Lincoln 1135 |
|
| Instructor
|
Prof. Yuqing Melanie Wu
|
|
Office |
Edmunds Hall 221 | |
| Phone | 909-607-9202 | |
| Melanie.Wu@pomona.edu
|
||
|
|
Office hours
|
M/T/W/Th 14:30-16:00 and by appointment |
| Student Mentors
|
Jerry Yan, Madhura Jayaraman | |
|
|
Mentoring hours
|
Tuesday/Thursday 20:00-22:00 |
Course description:
Fundamental
and cutting-edge concepts in database design: entity-relationship model,
relational and semi-structured models. Query languages: relational algebra,
relational calculus, SQL and XPath. Mechanism and
design of database management systems: storage model, indexing, query
evaluation and optimization, and concurrency control. Key ideas will be
practiced via course projects that involve the design and implementation of
real-life database applications.
Prerequisites:
CSCI052 PO
and CSCI062 PO (or CMC) or CSCI60 HM and CSCI070 HM. CSCI081 PO recommended.
Course Materials
Course
syllabus can be downloaded here. All other
course materials, including slides, homework assignments, solutions, etc., will
be shared via Sakai.