UMBC CMSC–461Summer 2006 Database Management SystemsSyllabusInstructorDr. K. KalpakisComputer Science & Electrical Engineering DepartmentOffice: ITE 348Phone: (410) 455-3143Email: [email protected] homepage: http://www.csee.umbc.edu/∼kalpakis/Courses/461/Office Hours: Tuesday and Thursday, 1:00pm-2:00pm, and by appointment.Meeting Time and PlaceTuesday and Thursday 9:00am–12:10pmRoom ITE 233Teaching Assistant: Parag Namjoshi, Room ITE 366,Phone: 410-455-8945, Email: [email protected] hours: Tuesday and Thursday, 1:00pm-2:00pm, and by appointment.Important Dates• Midterm Exam, July 27, 2006, 9:00am–10:15pm.• Final Exam, August 17, 2006, 10:00am–12:10pm.Prerequisites CMSC–341, or permission of the instructor.Text. The required text is “Database System Concepts. 5th Edition” by Silberschatz, Korth, andSudarshan published by McGraw-Hill, 2005.List of Topics (tentative).• Entity–Relationship Model• Relational Model• SQL• Normalization• Design Methodology• Storage and File Structures1Syllabus, CMSC–461: Database Management Systems, Summer 2006 2• Indexing and Hashing• Query Processing• Transactions• Security• Concurrency Control and Recovery• System Architectures• Special topics (TBA)Course objectives:Databases touch all aspects of our everyday lives. Database techn ologies enable u s to manage vastand diverse amounts of data and information efficiently, and consequently are an indispensablecomponent in the toolbox of every Computer Scientist. In this couse, each student will (a) learn thefundamental concepts of database management, including database design, models and languages,and system–implementation tech niques, and (b) develop s kills to apply those concepts in practicaldata management applications.Required WorkRequired work consists of (1) taking the midterm exam and fin al exam, (2) homework assignments,and (3) a project. Further, you are exp ected to actively participate in class discussions.Homework assignments will help you master the fundamental concepts of database systems, whilethe pr oject assignment will help you in developing skills to apply these concepts in practical datamanagement applications. The exams will be yet another opportunity to receive feedback withrespect to your accomplishment of the cours e objectives.AssignmentsThere will be at least four homework assignments. Homework assignments involve design, analysis,and software development and will need to be completed in a short period of time, usually in abouta week.There will also be a semester long project assignment, which will have a design, analysis,and development component. Basic programming skills using the Java 2 (version 1.4.2 or later)programming language are needed in the project. The project may have multiple phases, withlater phases depending on earlier phases. At the end of each phase, you will be submitting aproject progress report and any software developed, and may be asked for a demonstation of yourach ievements in an oral presentation. Details about each phase and their due dates will be providedwithin the first couple of weeks of classes.Ground Rules for Assignments• Assignment details, due dates, etc will be posted at the class homepage. Stu dents are stronglyadvised to check the class homepage on a regular basis. Failure to do so is not an acceptableexcuse for missing an assignment or for not adhering to the assignment’s instructions.Syllabus, CMSC–461: Database Management Systems, Summer 2006 3• You may develop the programs, if any, for your assignments using the computers available toyou at UMBC, or any other computer available to you. However, no matter what computeryou use to develop your programs, you must make sure that you r programs can run successfullyon the GL Linux computers at UMBC.• All assignments must be s ubmitted electronically by the date they are due according to theassignment’s submission instructions. No late assignments will be accepted, unless UniversityPolicy states otherwise.• In submitting an assignment, stud ents must adhere to the submission instructions specifiedby that assignment.• The written part of each assignment must be typed using a word–processor of your choice (youmay include hand–written mathematical formulas and/or diagrams as images in your docu-ments). No matter how you prepare the written part of your assignment, it must submittedin the Adobe PDF format. No other formats are going to be accepted.• No collaboration. Unless otherwise specified, each assignment is to be done and writtenindividually by each stu dent. Students should not collaborate on any assignment. The onlyexception would be for assignments for explicitly designated as team assignments, where teammembers are expected to collaborate in completing such an assignment.• Students may be asked to come in and explain their solution(s) to an assignment to theinstructor(s) and/or TA(s). Failure to satisfactory demonstrate authorship of a solution is aviolation of Academic Integrity policy.Students are strongly advised to keep up with the assignments and other coursework. Homeworkand project assignments do demand the amount of time allocated to them.ExamsThere will be one midterm exam and a comprehensive final exam. All the exams will take place inclass and will be closed–book and closed–notes. Make–up exams are possible only under Univers ityPolicy. You should make p rior arrangements with the instructor if you exp ect to miss an exam.Each student should have his student photo identification card or driver’s license when takingan exam. Failure to pro duce a pr oper photo ID may result in getting a zero on that exam.CommunicationStudents are strongly advised to check the class homepage, and the course Blackboard areahttp://blackboard.umbc.eduon a regular basis for news, announcements, and assignments. Failure to d o so is not an acceptableexcuse for missing an assignment or announcement.Students are welcome to u s e the course Blackboard area to discuss topic matters. However,student’s are advised not to solicit or post solutions to any assignment or otherwise violate AcademicIntegrity policy.Grading PolicyThe course grades will be determined as follows. For each course activity in Table 1, each studentSyllabus, CMSC–461: Database Management Systems, Summer 2006 4Activity WeightHomework 10%Project 30%Midterm Exam 30%Final Exam 30%Total 100%Table 1: Course Activities and their