Updating multiple databases Free sexchat american
// Users Only take the survey 'foobar' once, and can // edit the answers if and only if they have not completed the survey.table_member ( member_id, taking Foobar, foobar Completed, foobar Start Time, foobar End Time ) //foobar is actually a "results" table.Learn More DISCLAIMER: The FCC License View contains licenses that have been granted by the Federal Communications Commission, and is intended solely to demonstrate some of the changes envisioned for the Commission's new Consolidated Licensing System.
Thing is, there have been no concerns about normalization as I have had no problems with data insertion, querying results, reporting the answers, association of answers with members, etc!bazz My answers are in one table (table_foobar), and does use a FK(question_id) to relate them to the questions table (table_questions).r397 recommended to have the three rows in a normalized table, in first normal form. Now if there was a Member #1 Responses - Question #1: yes, 22, no, 34 - Question #2: no, 24, yes, 42 - Question #3: yes, 14, no, 42 Member #2 Responses - Question #1: no, 42, no, 55 - Question #2: no, 51, yes, 21 - Question #3: yes, 11, no, 14 etc., I see your concern and how you may recommend having only one answer for one question, which makes it so much easier to update SQL and PHP wise!;) table_foobar ( foobar_id, member_id, question_id, answer One, answer Two, answer Three, answer Four ) //Multiple questions for a single foobar Main survey.tbl_foobar Question ( question_id, foobar Main_id, foobar Question ) tbl_foobar Main ( foobar Main_id, foobar Name, foobar Description ) your database is not normalised as was mentioned before.