• The Review Session will take place Tuesday, May 2, at NOON, in the usual classroom.
• Please fill out your anonymous Course Evaluation by Tuesday, May 3, and get a 50% bonus on the final. Thanks!
• The Final Exam is Thursday, May 5, 10-11:50 (TEN a.m.), in the usual classroom, according to the registrar's website. Be there or be square.
• Homework 1 is up.
• The textbooks have now arrived at the bookstore. (No, seriously!)
• Welcome!

• Rameet & Samir: Student Job Search
• Janelle, Natasha & Monique: Dealership Connection
• Rajat, JP & Howard: Movie Database
• Michael, Mark & Lele: Video Games Database
• Dibya & Jyothi: Movies 'R Us
• Helen, Felix & Vivek: Cell Phone Search
• Zena, Tim & Marina: The Wedding of John and Jane

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.

• Change your MySQL password
• How to password-protect with .htaccess and an example that authenticates Stern user/pass.
• Google/websearch links:
  • The PageRank Citation Ranking: Bringing Order to the Web
  • The Anatomy of a Large-Scale Hypertextual Web Search Engine
  • Page and Brin on NPR's Fresh Air
  • Click Fraud More...
  • An NYU course on websearch
• $100 Laptops
• Recursive Acronyms
• Using mysql in Batch Mode
• Scripting examples:
  • PHP Examples
  • Perl Examples
  • PL/SQL Examples
  • some more PL/SQL examples, per class
• MySQL Reference Manual
• Transcript of the unintutive set-theortic SQLism, in Oracle on sales
• Past DBMS projects:
  • Denis & Alex: Stock Info
  • Corey & Paras: Police Department Database
  • Andy & Paul: Business-Keeper Information System
  • Daniel & William: Cigar Database
  • Past Projects at Stanford
• Info on Stern accounts
• Blackboard
• A Gentle Introduction to SQL
• SQL for Web Nerds
• History of RDBMS
• Databases and the Web

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.

• O(5) homeworks (30% 90/95 * 30% ~= 28.4%)
• project (30% 90/95 * 30% ~= 28.4%)
• midterm (15% 90/95 * 15% ~= 14.2%)
• final (20% 90/95 * 20% ~= 19%)
• attendance/participation (5% 5% + 5% = 10%)

Instructor : Matthew Johnson
e-mail: mjohnson-at-stern.nyu.edu
Office Hours: Tuesdays & Thursdays, 12:15-1:15, KMC 8-171

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 assingments appear on the days for which they should be done.

• 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