CPSC 464: Introduction to Database Management
Spring 2012
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/30/12.

Part 1: Choose a project and design an E/R diagram. Due Mon, 2/6/12.

Part 2: Relational design. Due Mon, 3/5/12.

Part 3: Create database in MySQL. Due Wed, 3/28/12.

Part 4: Queries, updates, and indexes. Due Mon, 4/9/12.

Part 5: Embedded SQL. Due Mon, 5/4/12.

Part 6: Project Presentation. 5/4/12.

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