SQL & Python - simple book manufacturer database filled with scraped data

As a starting project to learn SQL, I created a database based off a diagram given to me by Alan. I started by creating the Delivery.., Logistics.. and Document.. tables, connected with foreign keys, then decided to create more connecting tables to fill the database with, starting by webscraping a book store website designed for scraping found here.

Using this python script I scraped 10 000 books - their names, prices, ratings, availability and a link to their page - all to CSV files which can be imported in to SQL using BULK INSERT.

I then used python to fill temporary tables with random data - driver names, adressess, business names, warehouses, distribution centers... Then using this data I randomly created associated foreign keys.

For example, this script randomly selects dates, route ids and driver ids from the database to fill a temporary logistics route schedule table.

I also used more complicated scripts to fill in columns that should be mathematically sound, such as making sure the quantity in item boxes match the overall ordered quantity of the delivery.