hi guys,
I have one table:
exams(e_no integer primary key,e_name text);
now i want to create another table called questions which should have primary key that is combination of exam.e_no (foreign key) and question.q_no
questions(q_no,e_no,questions text);
so i would like to make q_no and e_no both act as primary key or combinational key.
the aim is to always insist that there will be unique question belong to single exam.