Mar 10: generate SQL DDL, faker

Learning Objectives

After today's class, you should be able to:

• Use dbdiagram.io to create SQL DDL and build a database
• Use the faker module to create data

Lesson Outline

Homeworks [2 min]

• HW5 is due this Thursday (Mar 12); note: gradescope submission is ready
• HW4 is extended until this Friday (Mar 13) to give time to complete with team

Faker module [20 min]

• faker_demo_hotels.py
• Documentation

Activity [55 min]

• create and fill database
• Also refer to - psycopg and faker

Your To-Do List

• Read about faker
• Read section 1.9 in the Runestone book
• Test 2 on Thursday after Spring Break