CSci 2441W DB Systems & Team Projects

TR 3:45pm - 5:00 p.m. Tompkins Hall, Room 201

Announcement: HW5 has been posted here. All slides (i.e., for Chapters D1-D5, D8, D12, D19, E1-E9 and Labs 1-2, 7) have been uploaded here. Midterm review slides have been posted here. Animations for normalization theory have been posted here. Sample questions for the first exam have been posted here. Team roster is available here. If you have any question/concern regarding the roster, please bring it to the attention of the instructor by Thu, Feb. 2, 2012. Course syllabus is available here.

Instructor: Nan Zhang nzhang10 at gwu.edu Office: 715 Academic Center Phone: 202.994.5919 Office Hours: TR 12pm - 2pm

TA1: Mahsa Ghafarianzadeh masa at gwmail.gwu.edu Office: 719 Phillips Phone: 202.994.0595 Office Hours: W 5 - 6pm

TA2: Xuanyi Chen xuanyi at gwu.edu Office: 102 Staughton Phone: 202.994.9492 Office Hours: M 5 - 6pm

Course Objective: This is a first course in database systems, team software development, social impact and professional ethics, and writing in the disciplines. In database design, it covers the following topics: introduction to database concepts, the relational model and algebra, the SQL language, the conceptual database design using Entity-Relational (ER) model, and the theory behind relational schema design. For team software development, a semester-long, team-based, project requires the design and implementation of an information system using one of the commercial database systems. The course shall also expose students to the impact of computer systems on society, both locally and globally, the basic concepts of intellectual property and software copyrights, as well as ethical analysis skills and the use of professional code of ethics in decision making. As part of the WID requirement, a number of written homework and project reports will be assigned. Corequisite: CSci 2113. Textbook: Ramakrishnan and Gehrke, Database Management Systems, 3rd ed., McGraw-Hill, 2003. Baase, A Gift of Fire: Social, Legal, and Ethical Issues for Computers and the Internet, 3rd ed., Prentice Hall, 2008. Optimal Readings: Silberschatz, Korth, Sudarshan, Database System Concepts, 5th ed., McGraw-Hill, 2005. Ullman and Widom, A First Course in Database Systems. Prentice-Hall, 1997. Elmasri and Navathe, Fundamentals of Database Systems, 5th ed. Addison Wesley, 2006. Date, An Introduction to Database Systems, 7th ed. Addison-Wesley, 2000. Project: Please refer to the Project page for details. Grading: Homework: 25% Exam 1: 25% Exam 2: 25% Team-based term project: 25% Lectures: Please refer to the Notes page for details.