UMBC              Fall 2003
CMSC661        Principles of Database Systems

Instructor
      Dr. Padma Mundur
       Computer Science  & Electrical Engineering Department
       Office : ITE 350
       Phone : (410) 455 3019
       Email : pmundur@cs.umbc.edu
       Class homepage : http://www.csee.umbc.edu/~pmundur/courses/CMSC661-03/
       Office Hours: Mon and Wed 3:30 - 5 pm or email or appointment

TA
        Fang Huang
        Office Hours: 4-5pm on Wed
        email: fhuang2@csee.umbc.edu (Fang is available via email and by appointment for project related questions)


Watch this space for announcements
Class meets in ACIV 011 starting Monday, the 15th.

Project
http://www.gl.umbc.edu/oracle_class.shtml  (for
information on how to connect to OIT's Oracle server )
Lectures
Homework1 (Due September 29 beginning of class)
Homework2 (Due October 13 beginning of class)
Homework3 (Due November 26 beginning of class)
Homework5 (Due December 8 beginning of class)
Midterm review
Homework4 (need not submit) and Final Review Topics


Meeting Time and Place
       Monday and Wednesday  2 pm - 3:15 pm, ACIV 011

Important Dates
      Midterm Exam :  October 27, 2003, Class time
        Final Exam : Mon Dec 15th  from 1 pm to 3 pm
        Project Due : TBD
        Last Day of Class: Dec 8, 2003

Prerequisites:    CMSC 461 or equivalent or with Instructor's permission (strictly enforced)

Required Text : Database Systems: The Complete Book, Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer
Widom

Course Description:  This course is meant to be a second course in Databases consisting of advanced topics on the mathematical foundations of database concepts.

Course Objective: At the end of the course, the student will have developed skills in three areas: i) a deeper understanding of the theory behind various data models and query languages and of issues related to management of databases including query optimization, security, recovery, and concurrency control; ii) a practical knowledge in designing and implementing a fairly complicated relational database using modern software tools; iii) a familiarity with research in the database field.

List of Topics
 
Chapters  Related Papers (citations available at the end of the chapters) 
Chapter 1 (reading assignment)
Chapter 2: The Entity-Relationship Data Model
Chapter 3: The Relational Model		 Reference [2] from Chapter 2 and [4] from Chapter 3 
Chapter 5: Relational Algebra
Chapter 6: SQL
Chapter 10: Logical Query Languages		 Reference [4] from Chapter 3 and [3] from Chapter 6
Chapter 7: Constraints and Triggers
Chapter 8: System aspects of SQL
Chapter 12: Representing Data Elements (reading assignment)
Chapter 13: Index Structures
Chapter 14: Multimedimensional and Bit Map Indexes		 Reference [3] from Chapter 13
Chapter 18: Concurrency Control Reference [11] 
Chapter 19: Transaction Management
Chapter 15: Query Execution Reference [2]
Chapter 16: The Query Compiler

Grading
    Homeworks   - 15%
    Midterm Exam - 25%
    Final Exam - 30%
    Project -  30%

There will be 5 homework assignments.  All homework must be done independently.  No late homework is accepted.

You will be required to work on a semester-long project requiring substantial work.  Project work requires working in a team of 2-3 students.  A detailed description of the project will be provided on the second or the third day of class. Teams will also be assigned at the same time.  A final project report is due on the date shown above.  A demonstration of the project will be scheduled for each team around the same time (1st week of December).  You are also required to pass intermediate milestones. No late projects are accepted. You will be provided accounts on the Oracle Server from OIT.

Midterm and final exams are closed book and conducted in class during the times shown above. Final exam is comprehensive (butmore weightage will be given to topics from second half). Makeup exams and incompletes are allowed only under extraordinary circumstances as per University policy.

Academic Honesty
Each individual is responsible for his or her own homework. Under no circumstances should written or printed materials be shared. With respect to the project, I would like to see a healthy competition among teams to generate innovative ideas and come up with the best project at the end of the semester.  Photo IDs may be required for admission to exams.

By enrolling in this course, each student assumes the responsibilities of an active participant in UMBC's scholarly community in which everyone's academic work and behavior are held to the highest standards of honesty. Cheating, fabrication, plagiarism, and helping others to commit these acts are all forms of academic dishonesty, and they are wrong. Academic misconduct could result in disciplinary action that may include, BUT IS NOT LIMITED TO,  suspension or dismissal. To read the full Student Academic Conduct Policy, consult the UMBC Student Handbook.