• Stephen & Stephanie: OATS (login: nicole.chambers@nyu.edu / Chambers / student)
• Josh & Jeremey: The Next Event
• Ajay & Michael: Stern Test Repository (Stern/sales login)
• Julia, Lee & Kristen: Sports Book
• Rohan, Max & Chris: Repair Spot
• Laura & Eliana: Global Exchange

• Welcome!

• Blackboard
• A Gentle Introduction to SQL
• SQL for Web Nerds
• History of RDBMS
• Databases and the Web
• List of "Web 2.0" sites

This course focuses on managing the data needs of an organization, and on designing and developing database applications for a variety of business problems. The course covers database architecture aspects, logical and physical data models, and the integration of database systems with programming and fourth generation languages. Topics include conceptual data modeling, data security and integrity, distributed data management, recovery strategies, and overall database administration. Students develop database applications using such tools as Access, Ingres, and SQL/DS (Prerequisite or co-requisite: C20.0001, or V22.0101).

Database Management Systems by Raghu Ramakrishnan, Johannes Gehrke Hardcover: 1104 pages Publisher: McGraw-Hill Science/Engineering/Math ISBN: 0072465638 3 edition (August 14, 2002) Available at the NYU Bookstore, BN (with same-day delivery in Manhattan), amazon.com and amazon.co.uk, and searchable on amazon.com.

Homework assignments will include written problems, programming and perhaps presentation. The project will comprise all aspects of a multi-tiered DB-backed web application, including the design and implementation of a database schema and the delveopment of a web-based front end. Consistent attendance and participation are required. Base score is computed as:

• O(1) homeworks (5%)
• project (30%)
• midterm (25%)
• final (30%)
• participation/pop quizzes (10%--missing a quiz will adversely affect your overall grade)

Final score = base score - 2^{n-1} (where n = # missed quizes, if n>0)

Instructor : M.P. Johnson
e-mail: mjohnson-at-stern.nyu.edu
Office Hours: after class

We would like the course to run smoothly, enjoyably and profitably. Feel free to let us know what you find good, interesting and fun about the course. Let us know sooner about the opposite. See us, leave us a note, or send us email. We want your feedback!

Reading and homework assingments appear on the days for which they are due.

• GA Tech Emerging Database Technologies and Applications
• Stanford (Widom) Introduction to Databases
• Cornell Introduction to Database Systems
• UWash Introduction to Database Systems
• Stanford (Ullman) Introduction to Databases
• UMD Database Design
• Database Management Systems slides
• C20.0046: Database Management Systems, Spring04
• C20.0046: Database Management Systems, Spring05