Final Project
CIS451/551, Fall 2007
The purpose of this project is to step through both the design and
implementation phases of creating a database and appropriate applications.
The subject of your database should be of your own choosing, either fictional
or intended for actual use.
Defaults: It is assumed that
- you will work on your own
- you will use a MySQL server running on ix
- applications will be coded using PHP
Exceptions to the defaults are perfectly acceptable but should be cleared
with the instructor first.
Deliverables:
- Title page
- Table of contents
- URL Tell us where to find the project.
- Summary - This is a high level, English description of the
mini-world
to be modeled. This should include an informal discussion of the kinds
of data to be stored and the application programs desired.
- Logical Design - A description if the inter-relationships of
the data items, including an E-R diagram.
- Physical database design - A description of all tables and
attributes. This step should discuss functional dependencies and
normalization issues.
- Physical application design - A description of all the desired
applications, which tables each effect, and the I/O behavior of each.
- User's guide - How to use what you have implemented. We will
look at each project, though you do not need to be present for a demo.
- Table contents - A list of your tables and the contents
of each.
- Implementation code - You do not need to implement all
applications that you propose. For example, an application package may need
15 applications, while you need only implement 5 or 6. (Alternatively,
instead of providing hardcopy of your code, you can provide a link
from your website to a page with the code.)
- Conclusion Describe what you have done and what you would do if
you had more time.
Mechanism and dates:
- Part One - due Monday, November 12
This should include a hardcopy report of
the summary, logical design (ER diagram),
physical database design (relational tables), and an outline of the
(proposed) physical application design. (This is essentially steps 4-7
above.)
You do not need to have created any tables or written any code.
- Part Two - due Tuesday, December 4
Turn in a copy of the full report as described above. If you used another
engine,
arrange
to provide a demo to for the instructor.
- Warnings
- Provide a guest account so I can connect my MySQL Browser at your instance. Be sure to
let me know your port number, and the guest account name/password. Also be sure the guest account
has adequate privileges to look at your databases and tables.
- Please do not incorporate a login mechanism with password
protection, or anything of the sort.
- Provide sample input data if you feel that it would make
testing your project simpler.
Chris Wilson