CSCI 470- Database Management Systems Semester Project

916 Medical Home Spa

Proposal Phase

Due Date: Thursday, September 18, in class and uploaded in VISTA/WebCT -

For the proposal phase of your project you will need to list who is on your team, who is your team leader and who is going to be assigned what responsibilities for your project. Each team will thus submit one proposal. The team leader is responsible for collecting together, collating, editing and providing a table of contents for the proposal and also making sure the proposal is uploaded in VISTA/WebCT. The responsibilities of team members may change over time, but give the initial assignments. You will need to turn in a preliminary Problem Statement/Requirements Definition, and initial Entity-Relationship (ER) Diagram, and an initial set of Use Cases. These are the items 1), 2), and 5) as described in your Design Phase Requirements. Present the elements of your proposal in exactly this order. Again, these are preliminary and I would expect that they will change as you refine what you need to do to implement your project over time.

You will develop your proposals based on the in-class presentation of the clients and other verbal and written information provided by the client. You mail email the client questions prior to the due date of the proposal. Be sure to be very professional and formal in your communication with the client. Minimize any inconvenience to your client by planning ahead. Be sure to communicate effectively with your client by using language that is familiar to your client, translating technical terms into concepts familiar to the client. The proposals and team interaction will be judged by the client and Dr. Stapleton and the proposals will be ranked. The team with the best proposal will be excused from the next quiz in the course, receiving 100% on that quiz by default. The best concepts from the proposals will be merged into a single proposal by the winning team and that proposal will be used by all teams to be elaborated on for the next phase of the competition, the design phase. The Design Phase will include an on-site interview with the client. No on-site interviews will occur in the Proposal Phase, however.

1) Problem Statement/Requirements Definition (5 points) . Develop a narrative statement of the needs for this project. Begin with a overview and background description of the organization and enterprise. What is the business operation that you are automating? Next describe what is to be done and what business processes you are focusing on for the project. Your Requirements Statement needs to include the problem scope, what is needed, the application context, and assumptions and performance needs.

2) The Entity-Relationship Model (10 points) which will provide the mapping to the global schema for your database. Entity-Relationship Modeling is covered in Chapter 3 of your text and in the course notes. Object-Oriented and Object-Relational Databases are covered in later chapters.

NOTE: Not due in the Proposal Phase, but due in the Phase 1 Design phase you will also build a *simple* Object Model diagram according to the Rumbaugh Methodology discussed in class and shown in notes.

3) A Set of Use Cases (5 points): You will need to include an overall use case diagram and a separate narrative description of each use case. If use cases are complex, break them down hierarchically into sub-use cases. Use cases are described in the notes. See other links on my web page for more on Use Cases including the examples of other student projects.

4) A filled-in evaluation form from each and every one of your project team. These evaluations are to be uploaded in VISTA/WebCT by each individual team member ON THE DATE THE PROPOSAL IS DUE, SEPTEMBER 18.