CPSC 464: Introduction to Database Management
Spring 2013
Project: Personal Database Application (PDA)

NOTE: there are some differences for the 564 students. Students in 564 should go here
Source: Arthur Keller, CMPS 180, University of California Santa Cruz, Winter 2002, http://www.cse.ucsc.edu/classes/cmps180/Winter02/. Adapted for UNM CS Department.

[Overview] [Logistics] [Part 0] [Part 1] [Part 2] [Part 3] [Part 4] [Part 5] [Part 6]


Your CS 464 programming project will be to build a substantial database application for a real-world domain of your choosing. You will design a schema on paper. Then, you will create an actual database using MySQL. You will populate the database, write interactive queries and modifications on the database, develop programs that manipulate the database, and explore other aspects such as constraints and triggers.

Part 0: Choose groups. Due Mon, 1/28/13.

Part 1: Choose a project and design an E/R diagram. Due Mon, 2/4/13. extended to Wed 2/6/13

Part 2: Relational design. Due Mon, 2/27/13.

Part 3: Create database in MySQL. Due Fri, 3/29/13.

Part 4: Queries, updates, and indexes. Due Fri, 4/12/13.

Part 5: Embedded SQL. Due Wed, 5/1/13.

Part 6: Project Presentation. 5/1/13.

The project is worth 35% of your course grade, broken down like this: Parts 1, 2, 3, 4 and 6 are worth 5% each and part 5 is worth 10%.

Back to beginning