Develop a sample web-based application that uses Grails, GWT and GORM to dynamically create and manage data structures to read from and write to in a database and join tables by automatically mapping on similar content (using string comparison or search functions) and displaying it back in the application. Use any freeware relational DB software for the database.
-Develop within the month, ideally 2 weeks
-Application meets the objective.
-Other software, frameworks more suited to meeting the development objective can be recommended and used upon my approval e.g. SmartGWT may be recommended for the built-in searching feature for mapping content.
-All ownership, development and licensing rights will belong to me, the requestor, and not the developer
-Successful transition of the installation and setup of the development and run-time environment to me (incl. web server, db setup, all software to edit and execute the project)
-Successful handover of all code, compilation and execution of the application developed on my machine
-Successful re-production of a test change of the application on my machine e.g. adding a field to the database through the web application
-Technologies and software selected should allow integration with non-relational data in the future without any re-work
-Any sample dummy data of approx. 100 rows per table can be used.
-Web application allows creation of tables, populating, and managing them via forms
-Application should be LDAP integrated. Provide information if this requires extra setup (optional)
-Web applications allows for tabular and chart displays of single or multiple tables on a mapping criteria e.g. displaying selected fields from two tables on a user-designated mapping criteria e.g. month of January or names starting with Sa
-Maximum GUI based, drag and drop, wizard like capability instead of typing in e.g. to see data of two or more tables combined, user selects from options provided and then suggests mapping criteria with drag and drop e.g. mapping one field from one table with another. Text box should only be used when a string needs to be entered to search or map on.
-Cover integrating across 2 and 3 tables at a time
-Document installation, configuration of all software
-Document code thoroughly with annotations and comments to explain all parts of the program
-Ensure tightness in design. DO NOT include code that is not needed or is redundant
-Document in a one-pager the different parts of the application and how they tie together through a high-level design
-Ensure complete handover of all content to me after development of the program. The idea or code of this program cannot be reused by the developer elsewhere.
-2-3 hours for understanding requirements
-3-4 days of development time incl. documentation
-3-4 hours of handover