CSci 241.AL: Database Management SystemsDepartment of Computer Science
The George Washington University, Fall 2010
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.
- 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
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
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
Receive approval for your proposal from the instructor
- If rejected then tweak, refactor, or completely replace it as necessary to gain approval
Determine your data needs and produce an Entity-Relationship diagram Select a DBMS implementation to use
- We'll talk about your options in class
Generate your database schema, create the database, and populate it with sample data Write and execute queries against your database to solve the business problem you presented in your proposal 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%
firstname.lastname@example.org Modified: Tue Aug 31 14:06:46 EDT 2010