MYSQL Expert needed to define flexible MySQL Database Structure for a survey capturing tool. -- 2

Please read this brief carefully and only bid if you are familiar with the task at hand, auto-replies will be ignored. We defined a couple of surveys at [login to view URL], linked 1:1 to google sheets as “collector” for the results. The task is to define and install a well-structured MySQL database based on the various google sheets. The database needs to be flexible enough to integrate new questionnaires (and therefore new google docs). The columns in google sheets depend on the specific questions (1 column per question), each answer to a survey represents one line (data set). Currently we have a test environment with 3-4 questionnaires with 10 questions each, but this will grow rapidly. The structure within the google sheets is determined by the survey platform and varies by question type (eg multiple-choice vs. rating vs. short answer). The MySQL database should be hosted at one of our servers. We want to be able to view and process the various tables locally in an MS Excel environment. The content of the database needs to be accessible in its entirety in excel. We think that to use a pivot cache is the best way to do this, but we are open to suggestions. We also need some kind of “viewer” or “console” in Excel to view the database content in Excel, eg by questionnaire (survey), user, project or question. Please add “understood” to your bid to show you actually read it. Please quote your hourly price and the number of hours needed.