# Database: Relational Schema Exercise - Test Database

Name: _________________________________

5 points.

Your instructor decided to use a database to assemble tests for the course. Some characteristics of this new database are:

- There will be a `Question` table with primary key `question_id` and attributes `question_text`, `question_answer`, and `question_points`.
- There will be a `Test` table with primary key `test_id` and a field for `test_title`.
- A test may have many questions in it.
- A question may appear in many different tests.

Draw a relational schema below to show these tables and how they are related. Using crow's foot notation to show the relationship between primary and foreign keys. Create a bridging table if necessary.