| MemberID | FullName | MembershipType |
|---|---|---|
| M001 | Alice Smith | Peak |
| M002 | Bob Jones | Off-Peak |
| M003 | Charlie Brown | Peak |
| ClassID | ClassName | Instructor |
|---|---|---|
| C101 | Spin | Sarah |
| C102 | Yoga | Dave |
| C103 | Pilates | Sarah |
| BookingID | MemberID | ClassID | BookingDate |
|---|---|---|---|
| B9001 | M001 | C101 | 2023-11-01 |
| B9002 | M002 | C102 | 2023-11-02 |
| B9003 | M001 | C103 | 2023-11-03 |
State one field in the Booking table that is a foreign key.
38 exam-style questions on AQA GCSE Computer Science Relational databases. Each one has a worked solution and a mark scheme showing where the marks go.