mysql - How to structure/normalize this database? -

-

i need make database should hold 50 questions, 3 possible answers each question , value of each answer.

enter image description here

this first guess feels wrong , i'm not sure how access values properly. suggestions on how structure this?

this seems correct way:

questions table --------------- id title ...  answers table ------------- id question_id answer value

one way be

questions table --------------- id title ...  values table ------------ id value   answers table ------------- id question_id answer value_id

then answers of specific question do

select a.*, v.value answers join questions q on q.id = a.question_id join values v on v.id = a.value_id q.title = 'what name of dr. who'

Comments

Post a Comment

Popular posts from this blog

python - No exponential form of the z-axis in matplotlib-3D-plots -

-
Image
i have similar problem described in how prevent numbers being changed exponential form in python matplotlib figure : i don't want (in special case) weird scientific formatting of axis. problem different have problem @ z -axis. 2-d plots can use ax.get_yaxis().get_major_formatter().set_useoffset(false) . , there no function ax.get_zaxis() what use format z -axis same way? edit: example: from mpl_toolkits.mplot3d import axes3d import numpy np import sys import matplotlib import matplotlib.pyplot pyplot def func(xi, ti): res = 10e3 + np.cos(ti) * np.sin(xi) return res if __name__ == '__main__': timespacing = 20 timestart = 0 timeend = 1 time = np.linspace(timestart, timeend, timespacing) widthspacing = 50 widthstart = 0 widthend = 3 width = np.linspace(widthstart, widthend, widthspacing) reslist = [] matplotlib.rcparams['legend.fontsize'] = 10 fig = pyplot.figure() ax = fig.gca(projection = '3d...
Read more

excel vba - VBA Proxy auto-configuration for http requests -

-
i need build client web api in vba , needs work behind proxy (with authentication). i've been looking @ winhttp.winhttprequest , msxml2.xmlhttp/serverxmlhttp classes. turns out that: xmlhttp automatically detects proxy settings provided through proxy.pac file (good) winhttprequest doesn't (bad) however, on other hand: xmlhttp automatically follows redirects, , there's no way of disabling behaviour (bad) winhttprequest doesn't (good) since i'd able have cake , eat it, there way automatic proxy configuration component such winhttprequest doesn't follow redirects blindly? the vba-web project might pastry eating problem. https://github.com/vba-tools/vba-web i guess wish go like: dim client new webclient client .baseurl = "https://www.google.com" .proxyusername = <user> .proxypassword = <password> .enableautoproxy = true end dim request new webrequest request .method = webmethod.httpget ...
Read more

php - phpWord - Tables with borders in headers/footers -

-
i working phpword , bringing changes header/footer content gives me real hard time. trying have header content arranged in table. table created through code write. styles try apply table placed in header not take effect. following part of code in may making mistake. $phpwordobj = new phpword(); $section = $phpwordobj->addsection(); $styletable = array('bordersize' => 18, 'bordercolor' => '006699'); $phpwordobj->addtablestyle('my custom style', $styletable); //add header document $header = $section->addheader(); $header->firstpage(); $table = $header->addtable(); $table->addrow(); //logo $table->addcell(2000)->addimage( '../vendor/phpoffice/phpword/samples/resources/phpword.png', array('width' => 80, 'height' => 80, 'align' => 'left') ); //logo $cell = $table->addcell(7000); $textrun = $cell->addtex...
Read more