Integrated Case Study Project Descrip6on Module code: SOFT6012
Informa6on Model Data Dic6onary (ERD)
Context diagram Data Collec6on JSOUP Web Crawler (JVM)
Web Server
*Note all teams will have to implement this as part of their implementa6on File (CSV)
Data Loading Geo Visualiza6on 1911
1901
www.census.na6onalarchives.ie Report Produc6on
Reports (PDF)
Web Browser (JSP/HTML5/ CSS3)
(scripts/GUI)
*JDBC DB (MySQL)
Reports (JVM) BIRT
Bulk Import
*JDBC
Tables (DDL) Scripts
Chapters of feasibility report 1.
2. 3.
4.
Informa6on Model
a. b.
Data Collec6on
a. b.
Zip up source code (Java, project, plus any build instruc6ons) Zip up file(s) created
Data Loading
1. 2. 3.
Document MySQL download, install procedure Document schema crea6on (based on a sample table) Document data importa6on (based on sample file)
1.
Zip up source code (HTML5/CSS3/JavaScript) that loads a file containing a sequence of long-‐lat (polygon), and an associated count that depending on its value is rendered on Google maps as a “color” of Red through to Blue (along a linear scale) -‐ such as a “Select count(*) of the number of people with certain agributes that are present in the region on the night of the census. These are loaded from a CSV file (not JDBC) Zip up source code (HTML5/CSS3/JavaScript) of a tool that creates the file described above. Provide an operate readme.txt for each of these web applica6ons
Geo Visualiza6on
2. 3.
5. 6.
En6ty Rela6onship Diagram (include cardinali6es) Data dic6onary (include enumera6ons of derived/categorical data – such as socio economic indicators)
Report Produc6on Download BIRT, write a Java Program that loads a sample test file that contains a count and label. For each file produce two reports (pdf format); one is a ‘Pie Chart’ depic6ng the ra6o of counts (% in Pie Chart) against the label (variable name), the other a simple ‘Bar Chart’ depic6ng the count against each label *variable name.