Create the framework and 3 test programs for a database query module.
Overview Program 1: The test program use 2 classes. Class A is a test class representing a larger system. Class A accesses the public method(s) of a Class B to initiate the creation of a new account object. Class B checks for pre-existing accounts in a small data base(flat file or even raw data as part of the main test program) and returns an object. The object is either a new account object with the standard fields filled in or an exception object.
Overview Program 2: Change Program 1. Rather than checking the database(simulated) directly, Class B queries another Class C. Class C compares the information passed in to the pre-existing accounts in two small simulated data bases and returns an object just the same as in Program 1.
Program 3; Implement Program 2 with MySQL.
Test Data Fields: The data fields sjhall consist of 6 alphanumeric and 2 integer/double fields.
Test Data Volume: There shall be few (minimum of 5) entries in the data base and the test program will test for differences between the data supplied to the query and the predefined test data entries.
Query Function Details: If all the supplied query fields match a pre-existing account entry, then return an exception object. Between 1 and 8 fields will be supplied/contained in the query.