+----------------------------+-------------------------+----------------+----------------+
| questions | questions | recepient_name | submitter_name |
+----------------------------+-------------------------+----------------+----------------+
| how do you like your team? | how do you like java? | linon jacob | kayne ran |
| rate your work load? | how do you like java? | linon jacob | kayne ran |
| how do you like your team? | how do you like java? | linon jacob | kayne ran |
| rate your work load? | how do you like java? | linon jacob | kayne ran |
| rate your work manager? | how do you like java? | linon jacob | kayne ran |
| how do you like your team? | how do you like java? | linon jacob | john random |
| how do you like your team? | how do you like python? | linon jacob | kayne ran |
| rate your work load? | how do you like python? | linon jacob | kayne ran |
| how do you like your team? | how do you like python? | linon jacob | john random |
| how do you like your team? | how do you like python? | linon jacob | kayne ran |
| rate your work load? | how do you like python? | linon jacob | kayne ran |
| how do you like your team? | how do you like python? | linon jacob | john random |
| how do you like your team? | how do you like ruby? | linon jacob | kayne ran |
| rate your work load? | how do you like ruby? | linon jacob | kayne ran |
| how do you like your team? | how do you like ruby? | linon jacob | john random |
+----------------------------+-------------------------+----------------+----------------+

How do I make this normalized? I mean that for a given

surveyID

,
it should display the

question, response, recepient_name, submitter_name

& the question could be either from the

custom_questions

table or the

questions

table depending on the

questionID

, but it should be displayed in the same questions
column only.

Is it possible to make a column a foreign key referring
to two different columns in two different tables (i.e., making