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