Database Systems
22:198:603

New Homework 1 Due February 21 (Posted: Feb 8) Solutions

Homework 2 Due April 18 (Posted: March 29) Solutions

Note: There will be another lab session on April 18, which will be held in ENGLEHARD 309

Official University/Campus closings:
Call 973-353-1766 or 732-932-1766
New Brunswick Campus Information
Newark Campus Information

Course Description: The primary objective of this course is to introduce the fundamental concepts necessary for the design and use of a database and to provide a practical experience in applying these concepts using commercial database management systems such as Oracle.

Text Book: Raghu Ramakrishnan and Johannes Gehrke, Database Management Systems McGraw-Hill, Third Edition

Other Reading:

1. Database Systems: An Application-Oriented Approach, Michael Kifer, Arthur Bernstein, Philip M. Lewis, Addison Wesley, Second Edition
2. Elmasri and Navathe, Fundamentals of Database Systems, 4th Edition, Addison-Wesley
3. Korth and Silberschatz, Database System Concepts, 2nd Edition, McGraw-Hill, 1991.
4. Ullman, Principles of Database Systems, 3rd Edition.
5. Date, Introduction to Database Systems, 4th Edition.
6. Rob and Coronel, Database Systems: Design, Implementation & Mangement 4th Edition, Course Technology, ISBN 0-7600-730-2215

Expected Work:

• Homework Assignments and Class Participation 25%
• Project 25%
• Midterm Examination 25%
• Final Examination 25%

Jan 17

• Introduction to Database Systems
• Class Notes
• The Entity-Relationship Model
• Class Notes

Jan 24

• The Relational Model
• Class Notes
• Relational Algebra
• Class Notes

Jan 31

• SQL: Queries, Constraints, Triggers
• Class Notes

Feb 7

• The project title, names of the team members, and Abstract Due
• Relational Model, Algebra and SQL continued

Feb 14

• Oracle Lab session: will be held in the ENG 003 lab (in the Basement of Englehard Hall)
• This requires an account on Oracle available on pegasus. So you need a an account on pegasus first. To get an account on Oracle, follow the steps below. You have to have your oracle account ready before you come to the lab class.
  Since Oracle can be access only through pegasus, you have to follow the following steps:
  1. First create an account on pegasus. The procedure to do this is available at (https://www.pegasus.rutgers.edu/cgi-bin/makeacct) If you already have an account, please make sure you can successfully login.
  2. Send an email to Songmei Yu (songmei@cimic.rutgers.edu) from your "pegasus account" She must know your login name on pegasus to create an oracle account.
  3. Please send this information to her by this Friday Jan 27 so that you will have it ready by next Tuesday.
  
• Lecture Notes for the Lab
  
• Additional material provided by Prof. Richard Holowczak.
  • Oracle tools on Pegasus
    
  • SQL and the Oracle SQL*PLUS Tutorial
    
  • Getting Around UNIX

Feb 21

• Microsoft Access Lab Session
• Lecture Notes for the Lab
  

Feb 28

• Storing Data: Disks and Files
• Class Notes
• Overview of Storage and Indexing
• Class Notes
• Tree Indexes
• Class Notes

Mar 7

• Tree Indexes (continued)
• Brief Project Presentations: Prepare one or two slides of the ER model of your project database (Either transparancy or power point file is fine)

Mar 14

• Spring recess: No Class

Mar 21

• Mid-term Examination (Topics covered until Mar 7)
• Sample Questions

Mar 28

• Concurrency Control and Recovery
• Class Notes
• Class Notes
• Example
• Class Notes

Apr 4

• Database Design and Normalization
• Class Notes, revised
• Database Tuning
• Class Notes

Apr 11

• Oracle Lab session in ENGLEHARD 309
• Developer/2000 Oracle Forms and Reports
• Tutorial on Reports by Youssef Mohamed
• Database Security
• Class Notes

Apr 18

• Oracle Lab session in ENGLEHARD 309
• Data warehouses
• Class Notes
• Design of data warehousing - a survey by Igg Adiwijaya

Apr 25

• Final Examination.
• Final Project Reports Due on May 2 by 6pm Guidelines for preparing the report