How thorough your error checking and validation controls are

Part2

Connect to database

Demonstrate ability to design and implement a workflow model to simulate core business functions.
Demonstrate ability to apply rigorous error checking and data validation.

DVDEzy is a sales and rental DVD shop that always proud to serve its members with excellence home entertainment that is good in quality and value for money. Over the years many non-computerised methods of tracking customers and DVDs have been tried, none have been truly successful. Therefore, the shop manager David Smith decided to put investment on the computerised system with a hope to better serving the customers and to efficiently tracking the DVDs. The shop needs to record details of all DVDs currently in stock, the names and details of all customers and the details of all DVDs sold or rented (who they were sold or rented to and for how much).

Project Requirements

The assignment must be written using Visual Basic.Net through the Visual Studio IDE 2008 or 2010.
The application is to be a Windows application and NOT a web based application.

Customer information can be added, modified, and ‘deleted’ from the database through a Windows user interface.
DVDs stock information can also be added, modified, and ‘deleted’ from the database through a Windows user interface.
All design assumptions and implementation details should be documented and justified through sound referencing and application of the theoretical concepts delivered in the course.
You must assume that the database design is static and will not and cannot be changed. Therefore, some of your own business rules and design assumptions may be governed by the database design.

A robust application provides the help page for the user. You would be marked based on how well you provide the necessary help for the user that utilizes your application.
How robust and resilient your middle tier and database connectivity is. That includes, how thorough your error checking and validation controls are. This includes well commented code, well formatted code, the application does not crash or terminate unexpectedly, and the amount of feedback and instruction you provide to users when an error occurs. Further, you are expected to use Hungarian notation for all of your naming schemes.