Book
Database Systems, 2nd
edition, by Kifer,
Bernstein, and Lewis, 2006.
Lectures
Tue, Thur
2:45-4:00 pm.
Olin 313
Instuctor
Jiong Yang
Olin 515
Email: jiong@eecs.cwru.edu
Office Hours: Tue/Thur 4:00-4:50pm
TA
Shijie Zhang
Olin 514
Email: shijie.zhang@case.edu
Office Hours: M/W 1:00-1:55pm
Grading Scheme
Quiz: 10%, Homework: 20%, Midterm: 20%, Final: 25%, Project: 25%.
Homework Assignments
HW1 (Due 9/18
4pm)
Ex. 4.14,
4.15: In addition to the exercises
in the textbook, you need translate the ER model to the Relational Model.
HW2 (Due 10/9
4pm)
Ex
5.20-5.24 and 7.6.
HW3 (Due 11/6
4pm) Solution
1) Explain why BCNF is not equal to 3NF.
2) Problems 22, 23, 24, 25, 26, and 27 in
the notes.
Each team will present
their work on Dec. 6 class and every student will give a score on other
teams’ presentation. Hard copy of the report should be turned in to your
TA when you do your presentation. All materials including code and a softcopy
of your report are due on Dec. 7 midnight.
You need form a
team of 2 to 3 students and report to the TA by Friday 9/21.
Write one or
two pages on the project: what application that your group wants to build, what
host language, database system, and data set you will use. Briefly describe the above issue. It is due on 10/11 4pm.
Midterm: Oct. 18. It covers the topics until the SQL
triggers. The materials are ER model, RA, RC, SQL (VIEW, TRIGGER). Cheat Sheet is allowed. The size of a
cheat sheet is 1 side of letter size paper or both sides of a half letter size
paper.