Oct 07: Review for Midterm
Learning Objectives
After today's class, you should be able to:
- Summarize the types of questions that will be asked on the midterm.
- Identify the next steps and real data sources for your group project.
Lesson Outline¶
HW3 Hints, Q&A [15 min]
Project Next Steps [10 min]
- Revise GP2/GP3 diagrams based on feedback
- Gather real data to import into your database
- Write code to generate other data with
faker
Midterm Review [50 min]
Midterm Outline¶
This is what we are planning. The question order and point values are not 100% guaranteed.
| Question | Points | Homework / Lab | Readings | Class Days |
|---|---|---|---|---|
| 1. Read EER Diagram | 15 pts | GP2, EER Diagrams | 2.1, 2.2 | Sep 09, Sep 11 |
| 2. Draw EER Diagram | 15 pts | GP2, EER Practice | 2.4 | Sep 16 |
| 3. Relational Mapping | 15 pts | GP3, EER Mapping | 2.3, 3.1 | Sep 23 |
| 4. Database Updates | 15 pts | HW2, SQLite | 1.5, 1.6, 1.7 | Aug 21, Sep 04 |
| 5. SQL Joins, etc. | 20 pts | HW1, TPC-H | 1.2, 1.3, 1.4 | Aug 28, Sep 25 |
| 6. SQL Aggregation | 20 pts | HW3, TPC-H | 1.1, 1.9, 3.4 | Aug 26, Sep 25 |
Not on the exam:
- Python DB-API (Sep 02)
- Data generation (Sep 30)
- Software tools (Sep 18)
- Group project (GitHub, Markdown, DBML)
- Textbook sections we haven't yet studied
Your To-Do List¶
- Study for the midterm exam (this Thursday in class)
- Make progress on your project before next Tuesday!