SPRING, 2013

Section 1: Deena Engel ... Section 2: Evan Sandhaus


Note: CSCI-UA.60 can be used as one of the four courses which make up the Web Programming and Applications Minor.

This course introduces principles and applications of database design. Students learn to use a relational database system; learn Web implementations of database design (specifically MySQL and PHP); and write applications using SQL. Students explore principles of database design and apply those principles to database applications in general and to their respective fields of interest in particular. Students will also become acquainted with other implementations such as SQLite with Python and an introduction to NoSQL.

Help and Contact information:

Tutoring Hours: We are fortunate to have David Taylor tutoring for us this semester. Tutoring hours will be held at the ITS Fourth Street Lab ... 35 West 4th Street (across from Courant)

E-Tutor Email address - You will also be able to reach David by email with questions outside of tutoring hours -


For non-majors: Web Design and Computer Principles ( CSCI-UA.4) or equivalent and Introduction to Computer Programming (CSCI-UA.2) or one semester of programming in Java, Python or an equivalent programming experience such as in C or C++.

Required Text Books:

LEARNING MYSQL by Tahaghoghi and Williams
Published by O'Reilly
Print ISBN: 978-0-596-00864-2 | ISBN 10: 0-596-00864-3
Ebook ISBN: 978-0-596-10526-6 | ISBN 10: 0-596-10526-6
Beginning Database Design: From Novice to Professional [Paperback]
Clare Churcher
Publisher: Apress;
ISBN-10: 1430242094
ISBN-13: 978-1430242093


Optional Text Books:

PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, 4th Edition
By Larry Ullman
Published by Peachpit Press
ISBN-10: 0-321-78407-3
ISBN-13: 978-0-321-78407-0
MongoDB and Python: Patterns and processes for the popular document-oriented database [Paperback]
Niall O'Higgins
Publisher: O'Reilly Media
ISBN-10: 1449310370
ISBN-13: 978-1449310370


Homework Policy:


This course will require one mid-term exam (20% of the final grade); one final exam (20% of the final grade); and approximately eight homework assignments (accounting for 60% of the final grade). All students work individually and the content of the database project may reflect their major or minor studies or other special interest(s).

Unix account:

All students will be assigned a UNIX account on a university web server for this class to use for their own web sites.


The primary software for this course will be available on the web server that we use in class. Any additional software that you need (e.g. Adobe's Photoshop) will be available to you at no cost through the ITS computer labs.