Lesson Outline

40 min	Lecture Slides * CREATE VIEW AS * Materialized views * GRANT and REVOKE * System catalogs * Example Queries
10 min	Exam Logistics * Written Portion: on paper (~50 min)         Multiple choice and short answer         Example:  Draw an EER Diagram         Example:  Map EER to Relational * Queries Portion: pgAdmin (~50 min)         Same format as the 2019 exam         Make sure your laptop works! * Take-home, untimed, don't cheat
25 min	Group Study * Discuss chapters 1, 2, 3, 6, 7 * Work through exams from 2019

Before Monday

1. Textbook: Read PDBM 7.3.2--7.7 (9 pages).

2. Exam: Submit both portions by Sunday 11:59pm.
   * I will announce when the exams files are ready.

Announcement: I will be traveling to SIGCSE 2022 this Wed–Sat. As a result, my office hours will be canceled on Wed 3/2 and Fri 3/4.