Database design and hosting in MySQL – Please read carefully!
$250-750 USD
Πληρώθηκε κατά την παράδοση
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.
Ταυτότητα Εργασίας: #22703082
Σχετικά με την εργασία
Ανατέθηκε στον:
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 Περισσότερα
33 freelancers κάνουν προσφορές κατά μέσο όρο $494 για αυτή τη δουλειά
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, Περισσότερα
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 Περισσότερα
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, * Περισσότερα
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 Περισσότερα
“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 Περισσότερα
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 Περισσότερα
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, Περισσότερα
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] Περισσότερα
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.
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
@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. Περισσότερα