Creates semi random test instances for a mock library database. This can be used on both REAL and Postgres.
Step 1: Change the file locations for the outputed databse data
Step 2: Run each cell of jupyter note book in order
Step 3: For postgres must import the schema.txt provided then the interst.txt while in Real you must import each table using .add TABLE_NAME(columns): file.csv
https://www.postgresql.org/
https://git.ecdf.ed.ac.uk/pguaglia/real/-/releases
Feel free to use this script for any use :)
Why not check out my functional dependies package coming soon: