Mar 12: Build database, Python faker

Learning Objectives

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

• Build a database using a SQL script
• Use the faker module to create data

Finish Tuesday's activity:

• Create the CRS database in your personal schema by running the create.sql script in pgadmin.
• Write and run a python program that fills at least 4 related tables in the CRS database using the faker module. Use the row counts from Tuesday's activity.
• Confirm that the tables and the data exist in the database and then submit the python file in Canvas.
• This example python program creates tables (your program should not), but also shows how to generate data using faker and insert it: fake_hotels.py

Work on homework 4 and/or 5

• Confirm HW4 groups

Your To-Do List

• Submit homework 4 (team submission on Canvas) and 5 (individual submission on Gradecsope)
• Rest, relax and have fun!
• Test 2 will be on Thursday after Spring Break