CPSC 564: Introduction to Database Management
Spring 2011
Project: Personal Database Application (PDA)

NOTE: there are some differences for the 464 students. Students in 464 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 1] [Part 2] [Part 3] [Part 4] [Part 5] [Part 6]


Your CS 564 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 1: Choose a project and design an E/R diagram. Due Mon, 2/7/11.

Part 2: Relational design. Due Mon, 2/21/11.

Part 3: Create database in MySQL. Due Mon, 3/28/11.

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

Part 5: Embedded SQL. Due Tuesday, 4/26/11.

Part 6: Project Presentation. In class on 4/27, 4/29, 4/2, 4/4. (The schedule)

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