CMSC 461: Database Management Systems Jan 30, 2007Course OutlineInstructor: Parag Namjoshi1 Contact InformationInstructorParag [email protected] Hours Tu–Th 1:15–2:15pm or by appointmentITE 215 (410) 455–8867TASandor [email protected] Hours Wed 3:30-5:30 pm or by appointmentITE 332 (410) 455–2668Course website: http://www.csee.umbc.edu/˜nam1/CLASSES/CMSC461-sp07/2 Meeting Place and TimeTime: Wed 2:30pm–3:45pm,Place: AC IV – 305 .3 TextbookThe required text is the Fifth edition of Database System Concepts by Silberschatz, Korthand, Sudarshan.(McGraw-Hill, 2005).4 Prerequisites• CMSC–341, Java programming.5 ObjectivesEach student will (a) learn th e fun damental concepts of database management, includingdatabase design, models and languages, and sys tem implementation techniques, and (b)develop skills to apply those concepts in practical data management applications.Course Outline-I6 List of Topics• Entity–Relationship Model• Relational Model• SQL• Normalization• Design Methodology• Storage and File Structures• Indexing and Hashing• Query Processing and Optimization• Transactions• Security• Concurrency Control and Recovery• System Architectures• Special topics (TBA)7 ExamsThe exams will be conducted in the classroom on the specified dates. The exams w ill beclosed-book and closed-notes. The final exam will be comprehensive and cover the materialfrom the entire course.8 ProjectThere will be one group project to be implemented using Oracle and Java. The groups cancomprise of u p to two students. The grading will be oblivious to the group size – i.e. oneperson pr ojects will be assessed at the same level as two person projects. The project willhave multiple phases with the later phases dependent upon previous phases. Late projectswill not be accepted except in the cases allowed by the University policy. All groups mustdemonstrate their projects between 14–16 May. A sign up sheet will be posted at thebeginning of May and the time slots will be assigned on first come first serve basis. Detailsof the project will be posted on the course web-page by mid-February.Course Outline-II9 Grading and Required WorkYour fi nal grade will be based u pon s even quizzes (7%), five homework assignments (15%),one project (23%), one midterm examination (25%) and the final examination (30%). Thegrade is given only for work done during the semester; incomplete grades will given onlywhen mandated by the UMBC policy. Failure to do the work on time is not an excuse forgranting an incomplete grade.Required work consists of (1) taking the midterm and the final exams, (2) doing allthe homework assignments, (3) taking at least four of the seven quizzes and (4) a pr oject.Further, you are expected to actively participate in class discussions.All the seven quizzes will be given at the beginning of class . You will have 10 minutesto complete each quiz. The quizzes will be based on the new material covered since theprevious quiz.Homework is due at the beginning of lecture – this is so you do not work on yourhomework during lectur e. Late homework will not be accepted – this is to allow for timelygrading and discussion of the homework solutions. Since you will be given partial creditfor serious attempts, you s hould simply turn in whatever you have accomplished for thehomework set when it is d ue.Your final grade will be based on your total score on all the activities in table 1 weightedappropriately. The instructor will convert the total score into the letter grades by thefollowing mapping: [90 − 100] ⇒ A, [80 − 90) ⇒ B, [70 − 80) ⇒ C,[60 − 70) ⇒ D,[60 − 100] ⇒ P , [0 − 60) ⇒ F . Necessary, but not sufficient, conditions to passingthis course are:• 30% on the seven quizzes.• 50% on the six homework assignments.• 60% on the pr oject.• 30 points in each of the exams.Course Outline-III10 Important Dates and Work ScheduleActivity Assigned Due Weight.Quiz# 1 Feb 13 1%HW# 1 Feb 10 Feb 20 3%Quiz# 2 Feb 22 1%HW# 2 Feb 24 Mar 8 3%Quiz# 3 March 13 1%HW# 3 Mar 10 Mar 29 3%Quiz# 4 April 3 1%Midterm Exam April 10 25%Quiz# 5 April 17 1%HW# 4 Apr 10 Apr 19 3%Quiz# 6 May 1 1%HW# 5 Apr 21 May 10 3%Quiz# 7 May 15 1%Project Feb 16 May 13. 23%Final Exam May 22 30%Total 100%Note that some of th e assignment dates may change. Please monitor the Announcementssection of the course web-page to keep track of any changes.11 Academic HonestyBy enrolling in this course, each student assumes the responsibilities of an active participantin UMBC’s scholarly community, in which everyone’s academic work and behavior are heldto the highest standards of honesty. Cheating, fabrication, plagiarism, and helping othersto commit these acts are all forms of academic dishonesty, and they are wrong. Academicmisconduct could result in disciplinary action that may include, but is not limited to,suspension or dismissal. To read the full Stud ent Academic Conduct Policy, consult theUMBC Stud ent Handbook, th e Faculty Handbook, or the UMBC Policies section of theUMBC Directory. [Statement adopted by UMBC’s Undergraduate Council and Pr ovost’sOffice.]Academic dishonesty will not be tolerated in this course. Maximum punish-ment allowed by the University policy will be sought in ALL cases of academicdishonesty.Course