Creating the ABQ database

Now that we've modeled our data and gotten a feel for the data types available, it's time to build our database. To begin, create a database on your SQL server called abq and make yourself the owner.

Next, under your project root folder, create a new directory called sql. Inside the sql folder, create a file called create_db.sql. We'll start writing our database creation code in this file.

Get Python GUI Programming with Tkinter now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.