CS 374: Database Systems
James Madison University, Spring 2022

Jan 25: ER Diagrams, Python SQLite

Lesson Outline

15 min Homework
* Compare your HW1 with the solution on Canvas
* Preview of HW2: two diagrams + Python basics
* Preview of GP1: we'll finalize groups this week
20 min Textbook Slides
* Chapter 3, slides 1–31
25 min Group Activity
* Reading ER Diagrams
* Drawing ER Diagrams
15 min Python + SQLite
* sqlite3 module (Python DB-API 2.0 interface)

Before Thursday

  1. Textbook: Read PDBM 3.1--3.2 (14 pages).

  2. Homework: Take a look at HW2 and GP1.