Home
Syllabus
Policies & Grading
» Recording/Copyright
» Piazza
Class Schedule
Notes & Readings
Recitations
Assignments
» Submit
» Project Info
» System Docs
FAQ
Links
General Information

When:   Tuesday/Thursday, 11:00 am - 12:15 pm
Where: 5129 Sennott Square Building
Instructor: Prof. Panos K. Chrysanthis (contact)
Recitations Instructor & TA: Wei Guo (contact)
Recitations: Friday   11:00-11:50am (CRN# 17659 & 17657) and
Friday   2:00-2:50pm (CRN# 17660 & 18348)
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 42 students in 1555 (42 currently registered) and 6 in 2055 (0 currently registered)
Textbook: Fundamentals of Database Systems, 7th Edition Ramez Elmasri and Shamkant B. Navathe, Pearson (c) 2015
(ISBN-10: 0-13-397077-9; ISBN-13: 978-0-13-397077-7)
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
Dec. 9: Recitation 13 sample solution handout was posted
Dec. 9: HW7 sample solution was posted
Dec. 6: Recitation 13 handout was posted
Dec. 5: Notes (Set #3)TP: Recovery Techniques were posted
Dec. 5: Notes (Set #2) TP: Concurrency Control thechniques were posted
Dec. 3: Notes (Set #1) TP: Concurrency Control theory were posted
Dec. 1: Recitation 12 solution handout was posted
Nov. 30: Recitation 12 handout was posted
Nov. 29: HW6 sample solution was posted
Nov. 29: Notes (Set #4) Indexing were posted
Nov. 21: Notes (Set #3) File Organization were posted
Nov. 20: HW7 was released & is due on Dec. 6
Nov. 20: Notes (Set #2) Data/Record Orgnanization were posted
Nov. 17: Recitation 11 sample solution was posted
Nov. 16: Recitation 11 handout was posted
Nov. 15: Notes (Set #1) Data Storage & Physical Organization were posted
Nov. 10: Recitation 10 sample solution was posted
Nov. 7: Notes (Set #2) on EER Model, UML & ER-2-Relational were posted
Nov. 9: Recitation 10 handout was posted
Nov. 8th: Recitation 9 sample solution was posted
Nov. 7: Notes (Set #1) on ER Model & Diagrams were posted
Nov. 3: HW6 was released & is due on Nov. 15
Nov. 3: Notes (Set #3) on Normalization were posted
Nov. 2: Recitation 9 handout was posted
Nov. 1: Notes (Set #2) on Normalization were posted
Oct. 30: Notes (Set #1) on Normalization were posted

[ News Archive ]


Copyright Panos K. Chrysanthis © 2017 Last updated on December 9, 2017 at 14:33:37 EST