CSci 241.AL: Database Management Systems

Department of Computer Science
The George Washington University, Fall 2010
CRN 73415

Term Project

---

Overview: In order to gain further experience with the material we will cover in class, you are to complete a term project. The main component of the project is to work in a team to develop a moderately complicated database application.

1. Form a team of 3 (or 4) class members and notify the instructor
• Teams of four will be expected to complete projects slightly more complicated than those undertaken by three-person teams
2. Select a business problem to solve from a domain with which you are familiar.
• Possibilities include...
• something from work (assigning people to project teams, a content management system)
• something regarding a hobby or interest (assigning referees to soccer games, cataloging a media collection)
• something familiar from daily life (web shopping, exploring your family tree, booking a flight, registering for a class)
• an idea you have for a new business or service
3. Write a high-level proposal describing your business problem and, in very general terms, your proposed solution using database technology
• This is probably 2-3 pages or so
• Include at least 3 use cases
4. Receive approval for your proposal from the instructor
• If rejected then tweak, refactor, or completely replace it as necessary to gain approval
5. Determine your data needs and produce an Entity-Relationship diagram
6. Select a DBMS implementation to use
• We'll talk about your options in class
7. Generate your database schema, create the database, and populate it with sample data
8. Write and execute queries against your database to solve the business problem you presented in your proposal
9. Demonstrate your solution to the class
• Your final project should include a web front-end. If necessary, feel free to discuss implementation options with the instructor.

Deliverables: Due dates are indicated on the class schedule. Late assignments will not be accepted without prior arrangements. Each project deliverable shall include a statement describing each team member's contribution to the deliverable. Submission details will be addressed in a separate document.

Grading Weights for Project Deliverables:

Proposal	10%
E-R Diagram	10%
DB Schema	35%
Queries	35%
Demo	10%

---

mmburke@gwu.edu

Modified: Tue Aug 31 14:06:46 EDT 2010