Waikato Environment for Knowledge Analysis

Waikato Environment for Knowledge Analysis (Weka) is a suite of machine learning software written in Java, developed at the University Of Waikato, New Zealand. It is free software licensed under the GNU General Public License. In previous labs, we learned how to use Weka to run several Data Mining algorithms on datasets stored in ARFF format. In the midterm exam, you will connect Weka to MySQL Database and then apply a Data Mining algorithm you used before on data stored as tables in a database. 1. The first step is to do your own research to install MySQL and MySQL Workbench on your laptop/PC (if you do not have it already). Test it by making sure you are able to create tables in the database and write/execute queries. 2. Find 1 dataset that you have not used before in any of the previous labs (you can find the data in ARFF format and then import them into a database). As you know, ARFF is text-based format and it is easy to reformat it into other text-based formats (e.g. *.csv) that can be imported into a database using MySQL Workbench. The dataset should be imported as 1 table. Name the database CSCI4823MidtermDB). Copy/Paste a snapshot of the Create statements of your table in the provided answer sheet