Our database design needs to capture and analyze emerging and startup technologies in the broader sciences field.
The database will be proprietary, used specifically 'in house' by our own external consultants for the filtering and identification of case specific technologies and not for public viewing.
We are seeking a developer to create a simple, effective online multi-user database based primarily on the existing pre-development, mock MS Access database. (attached) We developed this database to better understand our own needs, it is not and has never been used in a functional way.
Please use this database to form your submission. We have included a small volume of test data to help with the overall understanding of what is required.
What we need:
Define a database format / language
Ideally needs to be manageable by the users (us)
In a common, well known format, e.g. MS Access App, SQL, Caspio, MS Apps etc
Please suggest your database format
Outline the reasons / advantages relative to what we are trying to achieve
Set up a multi-user online environment.
Log user edits, date stamp submissions etc.
Capture existing data from Excel spreadsheets
Create import Queries from MS Excel spreadsheets (An example included)
We understand that there are likely referential integrity issues that will be faced with the conversions.
Conversion will involve splitting of multi-value fields into useful data
(e.g.) researcher fields which contain Multiple names comma separated which will need to be split into First, Last name, etc. and associated with the primary record.
Create forms for rapid data entry flow
Create forms for easy visual understanding and data viewing of existing data
Create search forms consisting of nested queries with ‘and/or’ options.
Filtering on form tables
An outline of the queries we would like to perform is below below
Create reports for screen and print to convey the results of searches
Ideally, educate us on how to create our own extraction reports
Facilitate the hosting and move to an online based environment
Direct us to cost effective but secure online hosting which we can ultimately manage ourselves
The developer will have an ongoing support role for the database.
In terms of searching, we want to be able to search by the following fields with ‘And/Or’ options so that we have the option to search multiple fields for the same word:
This will involve full string searches for partial and full matches in multiple fields.
We’d probably also want to be able to sort the results in the results table by each column.
We would like to be able to search the results for alternative terms
Results reports from queries
Reports from base database (reports from filtered data)
What we expect from your submission.
Outline the database you recommend and the reasons for this format.
A methodology you will use to liaise and create what we want.
A rough estimate of the time it would take you to create the database as outlined
A cost for the development
What debugging support you will offer
Where you are operating from
How many members in your team (those with relevant skill sets)
Examples of your database work
References from clients