If you would like more information about this project, please read
report.pdf in the docs/ directory.
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.
- you will work on your own
- you will use a MySQL server
- applications will be coded using PHP
- Cover page
- 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 - ER diagram, either using Chen notation or Crowsfoot.
- Physical design - A description of all tables and attributes.
- List of Applications - A description of all the desired applications, which tables each effect, etc.
- User's guide - How to use what you have implemented. We will look at each project, though you do not need to give a demo.
- Contents of tables - A list of your tables and the contents of each. (Rather than inluding this in your report, it might be simplest to give a link from your project intro page.)
- Implementation code It is nice to be able to look at your code. You could print it out, but it might make more sense to give links to it.
- Conclusion Describe what you have done and what you would do if you had more time.