You will have up to 90 minutes available for meeting with the client over the course of the project. You may use up to 60 minutes of this time during the design phase. More time with the client may be available at the client's discretion. Time with the client will be included in your time log. You are expected to discuss implementation requirements with the client after completing the design phase. Client availability times will be determined by the client.
Your database design must include examples of the main elements of relational systems (primary keys, foreign keys, other constraints ...); you must consider appropriate normalization. You will document the design, including normalization, and provide it to the client and course instructor in draft form by November 4, and in final form, after consultation with the course instructor, by November 14. The design document will not exceed 10 pages (single-spaced, minimum 12 pt type).
In order to facilitate your work in the second phase of the project, we will examine features of mysql in class near the end of the design period.
The implementation is required to follow your design document. Your php forms will allow data entry, updating and access to the database. The database and forms will both enforce integrity. You will show the client and course instructor an implementation prototype during the implementation phase no later than November 25. You may consider user views and security issues later.
You will write an Implementation and Programmer's Guide (must not exceed 10 pages) as a narrative of the implementation and referring to your design, and as a guide to programmers for maintenance and/or enhancement. A draft is due by November 28.