Setup Sql Tables 4 Data Entry
You’ll be simply setting up a few simple mySQL tables for our data entry. There will be the main table and then maybe 2 or 3 “sub” tables for the data entry people. They’ll be copying and pasting Q&A type of data from an original Word document into the sub-tables. The attachment here, on p. 1 shows the exact columns and layout we want for the main table. You’ll need to figure out how you can make the “sub” tables to accomodate the Multiple Choice (MC) type questions (85% of the questions are these. This input table will be super easy) plus 1 or 2 more input tables, or subtables for the various types of Matching (MA) type questions. The latter will be the challenge or the “work” on this project, ie trying to accomodate the various types of MA questions shown in the attached document on pp. 3-10 into maybe 1 or 2 subtables.
To be considered for project award, we will need you to submit a proposed solution (keep it simple, nothing long or formal thanks) to our entry of the many MATCHING type questions (looking for an efficient solution) represented in the attached sample questions file (an example of the types of q&a we’ll be doing data entry on) so that we can see you’ve got a workable gameplan before assigning the project. Just use “mySQLdb” as pw to access the document.
This solution will probably be in the form of 1 or several data entry tables that will ultimately feed that entered data back into the main mySQL table.
Bids up to $100 can be considered for this small project. Your bid should include the words “have read”. Basic familiarity with FLEX, AIR, Flash database design, and SQLite would be great for you if you’re interested in additional related work & larger subsequent projects, though is not necessarily required here. Should be a simple project for anyone who knows mySQL well. Setup some tables, the fewer the better. Will watch for your proposed solution to the attached MA (matching) types.
