Web database
- or -
Post a project like this£200(approx. $251)
- Posted:
- Proposals: 1
- Remote
- #59156
- Expired
Description
Experience Level: Expert
I\'m looking for an individual, who is able to create and set up a database in the cloud.
The database will feed a questionnaire on an iPad via WiFi and collect some data:
EventApplications
• Application Name: Name of the application/event
• Application Type: Quiz/Market research
• idEventApplications: Primary Key, AutoNumber - Unique ID for each of three products
• NumberOfTerminals: Number of Hardware terminals
• DetailCountry: Country of Event
Users
• ID: Unique reference for the user e.g. generated by HardwareName+_+CurrentTimeAndDate
• Name: Not used in this app, but for now should mirror ID
• DetailTime: Session started time
• idEventApps: reference to EventApplications.idEventApplications
• idUsers: Primary Key, AutoNumber – unique id given to the user when they are registered in the database
• timeOnTerminal: total session time
Questions
• idQuestions: Primary Key, AutoNumebr - Unique question ID
• QuestionNumber: Number of question/question order
• QuestionText: Text for the question
• idEventApplications: Reference unique product in EventApplications.idEventApplications
• QuestionType
Answers
• idAnswers: Primary Key, Auto Number - unique answer ID
• Correct: Flag if correct: 1 = correct, 0 = incorrect
• orderOfCorrectAnswer: sort order of answers
• idQuestions: Reference to Questions.idQuestions
• optionSign: label for the answers e.g. A B C, or 1, 2, 3
QuizData
• QAnswer: Answer given by the user / reference to idAnswers
• QNumber: Reference to Questions.QuestionNumber
• idUsers: Reference to Users.idUsers
• idQuestions: Reference to Questions.idQuestions
• entryTime: Time answer is submitted
• idQuizData: Primary Key, AutoNumber – unique QuizData reference
Any questions, shout.
The database will feed a questionnaire on an iPad via WiFi and collect some data:
EventApplications
• Application Name: Name of the application/event
• Application Type: Quiz/Market research
• idEventApplications: Primary Key, AutoNumber - Unique ID for each of three products
• NumberOfTerminals: Number of Hardware terminals
• DetailCountry: Country of Event
Users
• ID: Unique reference for the user e.g. generated by HardwareName+_+CurrentTimeAndDate
• Name: Not used in this app, but for now should mirror ID
• DetailTime: Session started time
• idEventApps: reference to EventApplications.idEventApplications
• idUsers: Primary Key, AutoNumber – unique id given to the user when they are registered in the database
• timeOnTerminal: total session time
Questions
• idQuestions: Primary Key, AutoNumebr - Unique question ID
• QuestionNumber: Number of question/question order
• QuestionText: Text for the question
• idEventApplications: Reference unique product in EventApplications.idEventApplications
• QuestionType
Answers
• idAnswers: Primary Key, Auto Number - unique answer ID
• Correct: Flag if correct: 1 = correct, 0 = incorrect
• orderOfCorrectAnswer: sort order of answers
• idQuestions: Reference to Questions.idQuestions
• optionSign: label for the answers e.g. A B C, or 1, 2, 3
QuizData
• QAnswer: Answer given by the user / reference to idAnswers
• QNumber: Reference to Questions.QuestionNumber
• idUsers: Reference to Users.idUsers
• idQuestions: Reference to Questions.idQuestions
• entryTime: Time answer is submitted
• idQuizData: Primary Key, AutoNumber – unique QuizData reference
Any questions, shout.
Digital C.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
25%
Last project
29 Jan 2014
Germany
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies