Project CPP

OBJECTIVE: Create a Database Application

• The applications should have the following classes

Class, Description
clsCatalog, Manage the catalog for the CPP school
clsEnrollment, Manage the enrollment of the students
clsCourse, Has the definition for course
clsInstructor, Has the definition for Instructor
clsStudent, Has the definition for student
clsValidator, Handles validation for the data entered
CPP_DB, Handles all database operations

• The application should allow the user to enter data into the database
• All forms perform the same type of operations. Add, Update, Delete, Select
• The form have a detail view and a list view
• The application uses the MDI model

Application Design

Main form see image.

Enrollment Form drop down format see image.

Course Catalog drop down format see image.

See the student form to see example of how the forms should operate see image.

Form Operations

• Forms load and displays all records available in the database
• User can use the Add, Update, Delete, Find buttons to manage the records
• If a command requires data entry the form switches view to detail mode
• Complete coding the rest of the forms to match the functionality of the student form
• For forms that have Comboboxes load that data on form load from the database
• When reading data from the Comboboxes use the space as delimiter to identify the Key field

Button Operations

• ADD BUTTON: Switch to detail mode. Add data to the DB and grid
• UPDATE BUTTON: Switch to detail mode. Prefill the form with data from the grid. Update data in DB and Grid
• DELETE BUTTON: Delete the selected row from the DB and Grid
• FIND BUTTON: Prompt user for record id and finds the record and sets the focus to the record

Validation

• All fields should be validated when entered using the Validator class
• Fields need to match the datatypes in the database.
• String values should not be blank, numeric values should be valid and not blank
• Phone number should be 10 digits
• Email should be valid email format is XXXXX@XXXX.XXX

Database Structure

See figure: see image.

CPP Sample Data

See figure: see image.

Enrollment Summary

See figure: see image.