sql server - SQL Questionaire Database Design (EAV Model) Issue -


im building friendship site try , match users share similar interests.

  • i have 25 questions defined answers(drop down answers) user must fill out.
  • im using entity–attribute–value model store users id question id answered id user selects.
  • i use count function see users have matches profile.

current table structure

  1. question table
  2. answer table
  3. question_answer_user table

the problem im running have 2 question , im not sure best place store them is.

  1. the question country?
  2. the question state?

im not sure if should store them other 25 questions or if should store them in 3 separate tables seen below.

  1. country table
  2. state table
  3. user_country_state table

there going alot of answer entries these 2 questions. example there 25 countries user can answer , total of 900 states / provinces user can answer from.

i want able consider users location similarity count im not sure best approach incorporate is?

i think selected country , state should live in user table, along other necessary user information such name , email address. don't think belongs in answers table, work there.

for list of options user select when setting account, storing them in pre-defined q , tables place any. depends, guess, on how data , functionality broken apart aren't crossing responsibility boundaries q&a table storing survey-type answers user-setup answers.


Comments

Post a Comment

Popular posts from this blog

cakephp - simple blog with croogo -

i not problem, made simple blog in croogo, problem is not adding or modifying or delete, because arabic language ?? function add in controller `public function admin_add() { $this->set('title_for_layout', __('add part')); if (!empty($this->request->data)) { $this->part->create(); if ($this->part->save($this->request->data)) { $this->session->setflash(__('the part has been saved'), 'default', array('class' => 'success')); $this->redirect(array('action' => 'index'));//, $this->part->id)); } else { $this->session->setflash(__('the part not saved. please, try again.'), 'default', array('class' => 'error')); } } }` => model `class part extends appmodel { public $name = 'part'; var $belongst...
Read more

How to group boxplot outliers in gnuplot -

i have large set of data points. try plot them boxplot, of outliers exact same value , represented on line beside each other. found how set horizontal distance between outliers in gnuplot boxplot , doesn't much, apparently not possible. is possible group outliers together, print 1 point , print number in brackets beside indicate how many points there are? think make more readable in graph. for information, have 3 boxplots 1 x value , times 6 in 1 graph. using gnuplot 5 , played around pointsize, doesn't reduce distance anymore. hope can help! edit: set terminal pdf set output 'dat.pdf' file0 = 'dat1.dat' file1 = 'dat2.dat' file2 = 'dat3.dat' set pointsize 0.2 set notitle set xlabel 'x' set ylabel 'y' header = system('head -1 '.file0); n = words(header) set xtics ('' 1) set [i=1:n] xtics add (word(header, i) i) set style data boxplot plot file0 using (1-0.25):1:(0.2) boxplot lw 2 lc rgb '#8b0000...
Read more

bash - Performing variable substitution in a string -

i have string contains use of variable, , i'd substitute variable's value string. right best have is #!/bin/bash foo='$name; echo bar' name="the name" expanded="$(eval echo "$foo")" echo "$expanded" which has obvious defects: prints the name bar while i'd print the name; echo bar instead of eval can bash's regex matching bash's string replacement: foo='$name; echo bar' name="the name" [[ "$foo" =~ \$([[:alnum:]]+) ]] && s="${!bash_rematch[1]}" && expanded="${foo/\$${bash_rematch[1]}/$s}" echo "$expanded" name; echo bar
Read more