Project Phase #8: CRUD Functionality
CRUD: CReate, Update, Delete
This is your final deliverable for this project, asking you to add features that let you add records to the database, and (optional) modify and remove records from the database through the web application interface. You will choose one major entity in your design as the target of the CRUD operations (i.e. insert rows into, update rows in, and delete rows from, a single table).
Add New Item
The user of your web application must be able to add a new item (a.k.a. row or record) to the database through the interface. This new item must be validated and, should a business rule be broken, the user informed of the problem. In other words, invalid data must never be inserted into the database. Once the item has been added, there must be some form of confirmation that the operation was successful.
(Optional) Modify Existing Item
The user must be able to select an existing item to modify, and then make the changes through the interface. You may--and in fact are encouraged to--reuse the same form page used to add new items. However, in this case, the existing item data must be presented to the user in the form's fields. The same validation rules that were enforced for adding a new item must also apply to modifying an existing item, and the user must be alerted of any problems. Once the item has been modified, there must be some form of confirmation that the operation was successful.
(Optional) Remove Existing Item
Finally, the user must be able to select an existing item and remove it from the database. No validation is necessary, but you may wish to confirm the delete operation with the user, before removing the item from the database. Once the item has been removed, there must be some form of confirmation that the operation was successful.
Changes from the Previous Deliverables
In this section, document changes to this project's design or scope from that described in the last deliverable.
If you made any changes to previous project deliverable, you must resubmit (re-upload) the modified versions showing the changes. In this case, please highlight the changed requirements in some way.