MIS415 Business Database Systems

* Home * Description * Overview * Schedule *
* Projects * Grades * Discussions *

MIS415 Projects

A half-quarter-long team project will be a required part of this course. In this project, you will need to develop a fully functional prototype of a database application for a fictitious or real-world client. Teams will be formed by the mid-point of the course, and will consist of 3-5 students. You will not have the option to work alone. Four major milestones will be used for the deliverables for the project:

Proposal: In this milestone, you will form a team and generate an idea for a project and submit a one-page proposal for the project. I will be happy to help in the formation of the team - ensure that there is at least one strong programmer in your team, because there will be some programming required for the project.
Databse design: In this milestone, you will design the database structure for your project. For this milestone, you will build a data model (ER diagram), and create the tables necessary for the project, and insert sample data into the tables.
Website skeleton: See the schedule page for due date. In this milestone, you will need to turn in a skeleton for the web-based user interface for the project. In this milestone, you will need to build a mock-up for the final interface implementation.
Implementation: Due by the end of the quarter, this will include the complete implementation of your system. The system must be developed using JSP, and demonstrated during the final class week.

Project Theme - Mobile Databases

For the team project, you will need to come up with an idea of an application that will be used primarily from an online connected mobile device (e.g., an iPhone/iPod, Android, Blackberry or Windows phone). Think of something that is useful for you, the company you work for, or a family member who has a business or some kind of a need for such a database.

Scope of the project

While a self-selected project may have a really broad scope, I will be looking for some specific things that must be supported:

1. Data must be somewhat complex. A system that only needs 1-3 tables will not be accepted.

2. Provide a search capability of the items you are storing. You should be able to search by things like keywords, IDs, say, a barcode number on the items (commonly the ISBN number for books) and display results in a meaningful way..

3. Allow users to add and edit something in the database - when new items are added to the database, your system should be able to show updated values of calculated numbers or reports etc..

4. Provide some kind of point of sale/shopping cart capability. Anything that allows users to gather items in a cart of some sort. If this does not apply to your project at all, this can be omitted.

5. Provide some quick "business intelligence" type queries - something that allows you to make some decisions regarding data in the database.

6. Finally, generate some reports - think about one or two reports based on data that you model.