php - mysql db normalization help required -

-

please forgive me ive been confused , need in normalization of next mysql database (will work on along php). if not allowed post ignore :)

  • i've need record large number students visit library in order document , create analysis , reports later on.
  • these visits hold lots of data , criteria each student single visit, , filled different supervisor people because student visit more 1 section.
  • hence, there limitations entry , disallowing parts of form accessed users...etc.
  • my plan have single form initial student information , select boxes, radio, checkboxes, , notes free text, each visit, mentioned, using php frontend

this have in mind, 2 main tables + other smaller tables hold select boxes data foreign keys.

table1: students

  1. student_id
  2. student_number
  3. student_name
  4. student_gender
  5. student_grade
  6. student dateofbirth
  7. student age

table2: visits

  1. studnet_id (referring , pulling student info table1)
  2. date_of_visit
  3. have_did_this_during_the_visit (dropdown)
  4. psychological_reaction (checkboxes) 5 was_wearing_well (yes not selectbox)

and on, more 50 criteria measure each visit

this way, have 2 forms, 1 add student, , 1 deal visits...

although, visits form/page big.. , here comes question, ok? these data of visits table can exceed 40 or 50 fields or guys advise different approach?

thanks in advanced

have_did_this_during_the_visit (dropdown).

for need 1 table table have pk anf fk on visits table's primary key

psychological_reaction (checkboxes) 5 was_wearing_well (yes not selectbox)

for need 1 table table have pk anf fk on visits table's primary key

table2: visits

    visit_id     studnet_id (referring , pulling student info table1)     date_of_visit     have_did_this_during_the_visit (dropdown)     psychological_reaction (checkboxes) 5 was_wearing_well (yes not selectbox)

have_did_this_during_the_visit

id visit_id dropdown vaues

psychological_reaction

id visit_id checkboxes vaues

Comments

Post a Comment

Popular posts from this blog

python - mat is not a numerical tuple : openCV error -

-
i have write down code showing error ma not getting it: please help: showing mat not numerical tuple: import cv import cv2 capture = cv2.videocapture("j.3gp") while(1): _, frame1 = capture.read() grayimage1 = cv2.cvtcolor(frame1, cv2.color_bgr2gray) _, frame2 = capture.read() grayimage2 = cv2.cvtcolor(frame2, cv2.color_bgr2gray) differenceimage = cv2.absdiff(grayimage1,grayimage2) thresholdimage = cv2.threshold(differenceimage,25,255,cv2.thresh_binary) cv2.imshow("difference image", differenceimage) cv2.imshow("threshold image", thresholdimage) cv2.imshow("image", frame1) k = cv2.waitkey(30) & 0xff error arising : ----------------------------------------------------------------------------------------- traceback (most recent call last): file "desk.py", line 15, in <module> cv2.imshow("threshold image", thresholdimage) typeerror: mat not numerical tuple ...
Read more

c# - MSAA finds controls UI Automation doesn't -

-
i'm working on automating windows application. i'm using teststack white framework. i've hit problem. program has 'window' object cannot see inside of. white shows no controls inside of it. inspect.exe shows no controls inside of either when running in ui automation mode. if switch inspect msaa see controls inside fine. there anyway me use msaa c# handle on these controls? if can identify msaa functions need, can use p/invoke call them c#. here's example article doing msaa: http://www.codeproject.com/articles/38906/ui-automation-using-microsoft-active-accessibility also, pinvoke.net can used identify iaccessible (msaa) functions: http://www.pinvoke.net/search.aspx?search=iaccessible&namespace=[all] here's answer along lines: msaa com-based? finally, alternative p/invoke, might able use tlbimp.exe create wrapper assembly oleacc.dll, , access msaa functions through it. i'm not sure if works msaa, it's worth try. as e...
Read more

wordpress - .htaccess: RewriteRule: bad flag delimiters -

-
pulling hair out on one. have following .htaccess file custom redirects in addition wordpress's default settings. when tested on local wamp server worked fine after moving production i'm not getting rewriterule: bad flag delimiters error in server log , after while site goes down internal server error any appreciated. in advance! <ifmodule mod_rewrite.c> rewriteengine on rewritebase / rewriterule ^rockford_weddings___welcome\.html$ /wedding/ [r=301,l] rewriterule ^blog/?$ /journal/ [r=301,l] rewriterule ^blog/(.*)$ /$1 [r=301,l] rewriterule ^portraitinvestment/?$ /portraitinvestment\.pdf [r=301,l] rewriterule ^weddinginvestment/?$ /weddinginvestment\.pdf [r=301,l] rewriterule ^holidaycards2014/?$ /holidaycards2014\.pdf [r=301,l] </ifmodule> # begin wordpress <ifmodule mod_rewrite.c> rewriteengine on rewritebase / rewriterule ^index\.php$ - [l] rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewriterule . /index.php [l] </...
Read more