Term Project
MIS 372 - Database Management
Fall 1998

Working in groups of two or three you are to design and implement a database system using Microsoft Access 97. The project should be a real world problem from work or school. You will be required to:

• Analyze a situation
• Create a conceptual model of the data
• Implement a database from the conceptual model
• Produce forms and reports and other features
• Present the solution to the class and to your customer.

Company Background
Customers, who they are and what they expect/need
Industry, what products or services does the company provide
Technology, current level of technology
Employees, how many and level of expertise

Corporate Analysis
Existing systems, functions and processes
User information needs
Strategic activities or processes

Project Objectives
Activities or processes that are to be supported
Basic process flows diagram
Scope of the Project (# of users, products, etc.)

Design:

Conceptual and Logical Design
Functional dependencies
Entity Relationship Diagram
List of entities and their attributes mapped to the function they will support
List of queries with contents, frequency, etc.
List of reports with contents, frequency, etc.
Assumptions made in the design and future issues
Relational Model (normalized)

Physical Design
List of tables
List of forms
List of reports
List of queries
Referential Integrity rules

Working Prototype:

Your system should consist of 3 or 4 tables with sample data, 4-6 forms, and 4 reports. You should incorporate advanced features like macros, queries, and controls depending upon the requirements of the system. The features implemented should assist the user and meet the requirements of the proposal.

Documentation:

User Manual
Create a user manual describing the major functions and use of your product. The user manual should be easy to read and follow so that a beginner with no previous experience could use your database system.

Implementation Notes
Database security and access issues
Implementation
Backup and maintenance procedures

Demonstration:

Each group will have the opportunity to present their database during the second to final week of class. should be given. Each group will be given 20 minutes for a presentation/demonstration of the project, its design, and implementation.

Due Dates:

Grading: