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

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/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