Exercise Goals
Identify the tables you will need
- First decide what data you will save
- What questions will be asked?
- Then decide how to group it into tables
- Start with binary relations if that helps
Design the queries
- Using join, project and restrict
- Add primary and foreign keys where needed