10 UMLState 80 240 220 90 Install/download prerequisites (PHP, MySQL, raw data tables) using FluPrint github. UMLClass 20 130 470 60 halign=left Data mining goal: Explore and describe SQL queries and corresponding csv tables. UMLState 330 260 220 50 Set up server and SQL development environment UMLState 570 260 190 50 Generate database tables with simple queries UMLState 360 460 210 50 Report tables in tabular form UMLState 340 520 260 70 Use descriptive statistics/modelling AND identify interesting populations of attributes UMLState 780 190 220 190 REPORT basic information of database tables ON key relations and attributes USING descriptive analysis in R/SQL AND provided information by authors UMLSpecialState 1060 250 200 80 type=decision Database clearly described? Relation 990 280 90 30 lt=<- 70.0;10.0;10.0;10.0 Relation 650 140 530 140 lt=<- [NO] 10.0;120.0;10.0;20.0;510.0;20.0;510.0;110.0 Relation 140 280 1140 230 lt=<- [YES] 10.0;210.0;10.0;150.0;1120.0;150.0;1120.0;10.0 Relation 750 280 50 30 lt=<- 30.0;10.0;10.0;10.0 Relation 540 280 50 30 lt=<- 30.0;10.0;10.0;10.0 Relation 290 280 60 30 lt=<- 40.0;10.0;10.0;10.0 UMLState 70 490 170 100 Generate datasets from interesting queries, e.g. the data used in SIMON. UMLState 360 600 210 50 Visualise interesting patterns in datasets UMLSyncBarVertical 300 460 20 180 template=txt title=titletext bg=red Relation 230 530 100 30 lt=<- 80.0;10.0;10.0;10.0 Relation 300 480 80 30 lt=<- 60.0;10.0;10.0;10.0 Relation 300 530 60 30 lt=<- 40.0;10.0;10.0;10.0 Relation 300 620 80 30 lt=<- 60.0;10.0;10.0;10.0 Relation 560 480 130 30 lt=<- 110.0;10.0;10.0;10.0 Relation 590 540 100 30 lt=<- 80.0;10.0;10.0;10.0 Relation 560 620 130 30 lt=<- 110.0;10.0;10.0;10.0 UMLSyncBarVertical 660 470 20 170 template=txt title=titletext bg=red Relation 660 540 100 30 lt=<- 80.0;10.0;10.0;10.0 UMLState 740 510 170 80 Review key relations, describe missing data, identify special values Relation 900 540 80 30 lt=<- 60.0;10.0;10.0;10.0 UMLSpecialState 960 540 20 20 type=final UMLSpecialState 20 270 20 20 type=initial Relation 30 270 70 30 lt=<- 50.0;10.0;10.0;10.0