For this project you will do Case Project 9-3 on page 475 of the text. This project involves some flexibility in that you can design the database as you wish. You may select appropriate fields, data types, etc., but should do the project with a single table. The table will need to be named with your username. For example, if your username for the class server were 4530btclown, that's what you would call your table. Since you are sharing the database with other students, it is imperative that you name your table this way, lest you overlay someone else's table.
You will need to construct your application so that it checks to see if the table exists in the database. If it does not, you will need to provide code to create the table in the database. Minimum functionality will include the ability to add bug reports and modify bug reports.
There is a sample application you can use for guidance, but you need to design your own. The sample is just to show you minimum functionality. Your fields, forms, and functionality may be different from the sample.
When you turn in your project, you should also delete the table you used in the project from your database. When I run your project for grading, the project should detect that the table doesn't exist and then create the table. I will then enter several bugs into the application for testing. You can delete your table using this utility. Please do not use if for anything other than to list tables or delete your own table. Do not delete any table that doesn't belong to you. Do not forget to do this after uploading your final submission to the course web site because I will not check your table before running your program.
Your header on each page should be identical (see the sample) so that the user sees the same header on each page of the application.
Your program will need access to your database. Remember the parameters I gave you in class regarding the MySQL setup on our class server:
Error Checking
Your program should check for common errors, both in form data (for example, boxes left blank) and database errors. You should issue appropriate errors when there are errors.
Remember to adhere to all general specifications in addition to those specific to this project.
Turning in Your Project
Your project must be uploaded to your workspace on the class server by 9:00 a.m. on the due date noted in the course calendar. Remember that I will give no help on projects on the day they are due. Late submissions will not be accepted.
Pay attention to the requirements above regarding removing the table from your database after testing your project on the server. There will be a substantial loss of points if I cannot observe your program creating the table and I will not remove it for you if you forget.
Extra Credit
There are two extra credit possibilities for this project, worth 20 points each. You may enhance your program by adding either or both functionalities:
Here is an example of the program working with the extra credit included.