Database design and hosting in MySQL – Please read carefully!

Completado Publicado hace 4 años Pagado a la entrega
Completado Pagado a la entrega

We defined a couple of surveys at [login to view URL] (survey platform), 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 resulting google sheets. The database needs to be flexible enough to integrate new questionnaires (and therefore new google sheets).

The columns in google sheets are named based on the question text (1 column per multiple choice option or 1 column for a rating (eg 1 to 5 stars). Each answered survey question represents one line in google sheets (data set). The structure within the google sheets itself is determined by the survey platform and varies by question type (eg multiple-choice vs. rating vs. short answer).

Currently we have a only a test environment with 3-4 questionnaires with 10 questions each, but we plan to increase this significantly.

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 read this brief carefully and only bid if you are familiar with the task at hand, auto-replies will be ignored.

Programación de bases de datos Excel VBA MySQL Arquitectura de software Procesamiento de datos

Nº del proyecto: #22703082

Sobre el proyecto

33 propuestas Proyecto remoto Activo hace 4 años

Adjudicado a:

tushargp93

Understood I am a senior developer with 4 plus years experience in Backend Development I can help you design Database in such a way that your excel sheet requirements are met. For viewing, You wil need to create APIs Más

$500 USD en 15 días
(4 comentarios)
3.9

33 freelancers están ofertando un promedio de $494 por este trabajo

extreamcode

Hi there, I can assist you with Database design. I’d like to be considered for your Project. I’m a designer and developer with expertise and experience in Web designing, HTML, CSS, PHP, AJAX, JQuery, Wordpress, MySql, Más

$500 USD en 7 días
(22 comentarios)
6.9
dvcontact

Hi, Would you like to see a quick demo of your project on transferring your survey data from Google sheet to your server in order to be viewed and processed in Excel completed before you award the project? You can cons Más

$500 USD en 7 días
(41 comentarios)
6.3
luiswilliam

Hi, Reiner P.! I read the description of your project thoroughly. I understand your requirements initially and I have experiences of the field. I am a specialist of: * React.js, Angular and Vue.js for Front-end, * Más

$500 USD en 2 días
(22 comentarios)
6.0
AITSoft

Hello there, How are you doing?. I have read the description, I have great experience doing similar jobs related to these skills Data Processing, Database Programming, Excel VBA, MySQL, Software Architecture. Right n Más

$555 USD en 7 días
(24 comentarios)
4.9
udalsoft

“Understood” Respected Sir, Greetings of the Day ! I am Udal Bharti. I have 9+ years of competitive experience in web application development using .net and SQL server. I have 7+ years of experience in Database Más

$500 USD en 20 días
(4 comentarios)
5.1
jinjinwu

hi, there. I saw your posting with an interesting. I have an experience with google spreadsheets. so I think I can solve your project. I wanna discuss about your project with you. if you have an interesting with me, k Más

$500 USD en 7 días
(11 comentarios)
5.1
reedsystems

Hello there! How are you doing today? Your project caught my eyes and I am ready to work with you. With my level of experience as a developer working with different tools including database for about 8 years, more so, Más

$450 USD en 10 días
(13 comentarios)
5.1
arjun366333

Hello, i'm interested in your project. Please send me a message so that we can discuss more. I prefer to submit my detailed proposal after our discussion. Note: + We are flexible with changes. + [login to view URL] Más

$250 USD en 7 días
(18 comentarios)
5.3
ayyar1

Sir, I'm expert at excel and MySQL database, I can create script Normalized 1NF, 2NF, 3NF and design model ERD of your database. I look forward to working with you. Thanks for reading. Best Regards.

$370 USD en 7 días
(14 comentarios)
3.9
MykolaDudych

Hello, I am interested in your offer and I am ready to cooperate. I am ready to do database development and hosting in MySQL. I can also make a "viewer" or "console" in Excel to view the contents of the database in Exc Más

$499 USD en 30 días
(13 comentarios)
4.0
mahmoudkaseemeg

Hello, "understood" there is many details i want to understand it , i can use VBA to handle and organize the huge data in excel with less time and i can make a review macro to improve it wehave to discuss the detai Más

$750 USD en 10 días
(1 comentario)
0.6
Geracimov

Hello, sir. How are you? I have just read your project description and I can help you with my experiences. Don't waste your golden time to looking for a developer! I'm new freelancer, but I will make the perfect produc Más

$300 USD en 5 días
(1 comentario)
0.0
rajamahantiprave

Hello I'm an expert Web Designer/Developer >> WordPress, Woo-commerce, Shopify, HTML/CSS, Bootstrap, UI/UX , WIX , complex websites, graphic design,web design, logo design, landing pages, building custom themes based o Más

$250 USD en 7 días
(0 comentarios)
0.0
kkinfotech099

Thanks for your posting      I checked your requirements and I have experience in similar work and can do demo WORK FREE If you like my trial work then we have deal or you dont have to pay anything For trial work p Más

$500 USD en 7 días
(0 comentarios)
0.0
isangcorporate

We are a team conposed with: -Mobil App developper -Sothware developper -Business analyst -Excel and Acces Macro developper -Data base management (access,Oracle,Odoo) -Powerpoint designer -Adobe infography and Video m Más

$500 USD en 7 días
(0 comentarios)
0.0
billion4world1

@HI, Dear@. I'm a senior web&app, database developer/engineer with over 7 years of experience and rich experiences in this area. If you want to work with me, I am sure I can deliver you a wonderful result as you want. Más

$500 USD en 7 días
(0 comentarios)
0.0