1. Each project goes through several stages and each stage is to be thouroughly
documented. The following stages are required:
a. ER diagram for the enterprise. Documentation should include a diagram
and description of every entity, attribute, and relationship. Additionally,
for each entity a key must be given. Documentation should not exceed more than
two pages.
b. Conversion ER diagram into a set of relations with an attempt to
minimize the number of relations. Documentation should not exceed more than
one page
c. A set of SQL relations definitions. creating these relations and loading
them with a sample of some data. Your documentation of this step should give a
set of Create and Create index SQL statements
d. Description of Web based user interface along with an outline of each
screen. Documentation should not exceed more than 4-5 pages. I would prefer that
you provide me with a picture of each screen. You also should provide help
pages to operate your database application.
e. Description of a set of C++ program that take data from the web
interface, prepare a sql statement(s) and submit these statement to SQL.
After the execution of the program, the data obtained from SQL should be
displayed on the screen. You should allow users to scroll through your data
and to cancel the query during the execution or modify the data on the screen.
Documentation for this stage, consists of a description of each program and a
program source code.
f. Finally, you should prepare a user manual (1-3pages) that describes
how to install your application, and how to use it. You should assume that you
give a user a diskette (or cd ) that contains your application. User should
be able to follow your instruction in installing your package.