UMBC Spring 2006
CMSC461 Database Management SystemsInstructor
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/CMSC461-06/
Office hours: Mondays and Wednesdays 4 - 5 pm and by appointment; Email at any timeTeaching Assistants
Patrick Gillespie (Evening Section)
Office: ITE 353
email: pgille1@umbc.edu
Office hours: 4:30 to 5:30 Mondays and WednesdaysAdam Anthony (Afternoon Section)
Office: ITE 349
email: aanthon2@umbc.edu
Office hours: 10 -11 MondayMeeting Time and Place
Monday and Wednesday 5:30pm - 6:45 pm Room ITE 231 (Section 0101)
Monday and Wednesday 2:30pm - 3:45 pm Room ACIV 305 (Section 0201)
Important Dates
Midterm Exam :March 27, 2006 (class meeting time)March 29, 2006 (class meeting time)
Final Exam : CMSC 461 0101 & 0201 (Common Exam Time for both Sections) May 19 6-8 pm LH 8
Project Due : TBA (typically last day of class)
Last Day of Class: May 15, 2006
WATCH THIS SPACE FOR ANNOUNCEMENTS (Check this space at least once a day!)Chapter numbering is different in the 5th edition from 4th edition. If you are using the 5th edition, this is the chapter order we follow in class : Ch1 - Introduction, Ch6- E-R Model, Ch2 - Relational Model, Ch3 - SQL, Ch7 - Relational DB Design, Ch11 - Storage & File Structure, Ch12 - Indexing and Hashing, Ch15 - Transactions, Ch16 - Concurrency Control.
LECTURE SLIDES -- Ch1 - Introduction, Ch2 E-R Model (This is Ch6 in the 5th edition), Ch3 Relational Model (this is Ch2 in the 5th edition), Ch4 SQL (this is Ch3 in the 5th edition), Ch7 (Relational Database Theory), Ch12 (Index structures), Ch 15 (Transaction management), Ch 16 (Concurrency control)
Homework1 (Announced on 2/14/06, Due beginning of class 2/22/06)
Relational Algebra examples
Homework2 (Announced on 3/1/06, Due beginning of class 3/8/06) Homework2 Solution
Homework3 (Announced on 3/8/06, Due beginning of class 3/15/06) Homework3 Solution
SQL examplesProject (Announced on 2/20/06; updated on May 07, 06 with demo details/schedule)
Look for demo details and schedule in the project description.
FAQ (new items added on 4/11/06)
Oracle and Java Help
Reading Assignment (5th edition) for the project: Chapter 4 Advanced SQL, Chapter 8 Application Design and Development (take a look at the triggers Section 8.6)Homework4(Announced on 4/19/06, Due at the beginning of class 5/1/06). Homework4 Solution
Practice problems for Ch 12, 15, 16Midterm is moved to Wed the 29th of March, 2006 (class meeting time).
Important: Project Demo Schedule is up on the bulletin board outside Dr. Mundur's office. Sign up for the demo if you have not already done so!
Project Grades (announced on May 18, 2006)
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.