Consolidation and Tracking Database

To create a database to consolidate and track changes with the below listed key functions. Software will be used as front end and refer to external database (MySQL, SQL) • User Management down to field level read, write, import/export rights o Up to 1000 users • User settings o User to create their own pre-selected queries (layout, e.g. which field and in which order) o Change Password • Database management o Select Database o Add/remove fields o Select field for query o Data validation • User defined Queries o Select Parameters  Select Fields based on access rights  Select Values for fields e.g. range, value…  Select user defined query (layout) o View entries based on parameters in tabular form o Allow changes (based on user rights) o Allow refresh of query o Allow export to excel (based on user rights) o Allow import from excel (based on user rights) • History Log o Have history log for all changes made, manually or via excel import Dataset tracked translated in table size ~ 20000 rows / 800 columns Do not bid if you haven’t done something similar before. Whole code must be well documented and will be verified through third party. As this is a bigger and a project with high potential for further extensions, I will initially create a subproject for a user module to be implemented according requirements within one week as evaluation of you capabilities. This project will only be awarded after you have successfully completed the subproject.