DB design for a Course-Exam scenario with capability of keeping track of exam types 
===

Assume that we have a table for **Course** and two tables for **Multiple Choice Questions(MCQ)** and **Normal Questions (NQ)**.

Each course can have several MCQs and NQs. I'm supposed to keep track of their numbers to be shown to Students and also to be used for statistical purposes.

How can I connect them ?? I was supposed to use a middle table (say Exam Label) between questions and Course to keep track of each exam type, but a friend told me to use **Sequences** (for instance in Postgres),etc.

What do you recommed ? 