I really need help with the this project.
CIS 2334 Database Project Requirements 2
CIS 2334 Information Systems Applications
Database System Development v.1.
The database application project (DAP) for this course consists of the creation of a fully functional Microsoft Access database application for a real client. I recommend you select a potential client organization with which you have some familiarity, e.g. a bowling league, a small business, or a club. The application should not be complex. The final Access database application prototype must meet the following minimum criteria:
Tables:
A minimum of 5 tables, including intersection tables where necessary;
Tables must have enough data (minimum of 8 records each) to fully demonstrate the functionalities of your database application;
At least four table relationships, all of which must have referential integrity enforced.
Queries:
1. At least five queries (total) appropriate to the database requirements;
1. Of these five, at least one query must prompt the user for input (i.e., parameter query) and use the input in the criteria for the query;
1. Of these five, at least one query must use an aggregate function to calculate a summary statistic for an appropriate field in a table.
1. Of these five, at least two queries must retrieve data from multiple tables.
Forms:
1. All the necessary forms for inputting and displaying the data in your database as required by your client. One form per table for data entry.
1. At least one form displaying data from a minimum of two tables.
Reports:
1. At least four reports (total) for data output;
1. Of these four, at least two reports should be based on a multiple-table query.
1. At least one report should display grouped data.
User Interface:
1. Provide a user interface to access the features of the prototype.
Milestone 1:
Write a memo to me describing your client, an initial analysis of the organization’s problem, and what business process will be automated. This memo is due Week 6, Tuesday, October 1.
Milestone 2:
Write up results of Interview with client, including a workflow diagram of current business process. Due Week 8, Tuesday, October 15.
Milestone 3:
Draft of Requirements Analysis section. Due Week 9, Saturday, October 26.
Milestone 4:
Database diagram of reversed engineered database application project database. Due Week 10, Saturday, November 2.
Milestone 5:
Draft of Database Design section. Due Week 11, Saturday, November 9.
Milestone 6:
Prototype Testing. Due Week 12, Thursday, November 14.
Milestone 7:
Final Database Application Project Report and Database (Due Week 15, Thursday, December 5)
1
August 27, 2013 v1