Creating a GUI application using MySql

Your team is going to implement a MVC design pattern (Model View Controller) based application. For the Model (Data), each team will be required to implement a minimum of 4 database classes that abstract the underlying database tables. Two of these classes need to have CRUD functionality implemented (Create, Read, Update, Delete) to maintain the underlying database tables. For the GUI, a form consisting of the following: • at least 3 drop down lists, • 5 data entry text boxes, • CRUD buttons, • a table to display a set of data records, • corresponding labels. No data bound controls will be allowed. At least 2 of the drop down lists need to have their list content provided from a table in the database, however the list control cannot bind directly to the database, the list data must come from a data class. Any remaining lists can be hard-coded. The Controller class(s) are responsible for orchestrating the user experience.