|
General Information
| When: |
|
Monday/Wednesday, 3:00 - 4:15 pm |
| |
| Where: |
|
5129 Sennott Square Building |
| |
| Instructor: |
|
Prof. Panos K. Chrysanthis
(contact) |
| |
| |
| TA: |
|
Roxana Gheorghiu
(contact) |
| |
| |
| Recitations: |
|
Friday 2:00-2:50pm (CRN# 21606 & 21606) and
Friday 4:00-4:50pm (CRN# 21608 & 21608) |
| |
|
at 6110 Sennott Square Building |
|
| Purpose: |
|
There are two principle objectives for this course. First, to
introduce the fundamental concepts necessary for the design and use
of a database. Second, to provide practical experience in applying
these concepts using commercial database management systems.
|
| |
| Prereq: |
|
A grade of C or better in CS 0441 and CS 0445 is required. Working
knowledge of Java and familiarity with Unix are assumed. |
| |
| Enrollment: |
|
Open to all students having the prerequisites;
max 40 students in 1555 (40 currently registered) and 6 in 2055
(6 currently registered) |
| |
| Textbook: |
|
Fundamentals of Database Systems, 6th Edition
Ramez Elmasri and Shamkant B. Navathe,
Addison-Wesley (c) 2011
(ISBN-10: 0-13-608620-9; ISBN-13: 978-0-13-608620-8)
|
| Reference: |
|
Oracle10g Programming: A Primer,
R. Sunderraman, Addison-Wesley, 2007
Learning SQL, 2nd Edition,
Alan Beaulieu, O'Reilly 2009
(Available online from campus computers through
Safari Bookshelf).
|
| |
|
 |
|
Announcements |
|
| Apr. 22: |
HW7 sample solutions were posted
|
|
| Mar. 1: |
Final Exam Review: 2-4pm, Apr. 23, 2013 @ 5317SQ
|
|
| Apr. 10: |
Notes on ER Modeling and Transaction Recovery were posted
|
|
| Apr. 15: |
HW6 sample solutions were posted
|
|
| Apr. 12: |
HW7 was released & is due on Apr. 20
|
|
| Apr. 10: |
Notes on Normalization were posted
|
|
| Apr. 3: |
Notes on Query Optimization were posted
|
|
| Apr. 1: |
Notes on Physical Organization (Set #4) were posted
|
|
| Apr. 1: |
HW6 was released & is due on Apr. 11
|
|
| Mar. 30: |
Notes on Physical Organization (Set #1-3) were posted
|
|
| Mar 30: |
Notes on Concurrency Control were posted
|
|
| Mar. 30: |
Recitation 10 handouts & solutions were posted
|
|
| Mar. 18: |
Recitation 9 handouts & solutions were posted
|
|
| Mar. 3: |
Recitation 8 solutions were posted
|
|
| Mar. 3: |
HW4 & HW5 sample solutions were posted
|
|
| Mar. 1: |
Midterm Reviews: 2-3pm & 5:30-6:30pm, Mar. 5, 2013 @ 5317SQ
|
|
| Mar. 1: |
Recitation 8 handouts were posted
|
|
|
[ News Archive ]
|
|
|
