Terra DB - SQlite3 Version

Requirements

sqlite3, pandas

---

• the first version of this database was published in Dürr, M., Radermacher, K.: "Einsatz von Datenbanksystemen - Ein Leitfaden für die Praxis". Berlin u.a.: Springer-Verlag 1990
• this version is adapted for SQLite3 for local training SQL in absence of a DBMS like MySQL or similar.

---

python ./genTerraDB.py

will generate a new terra.db file for SQLite3 every time you call it

Original terra2023.sql source from "www.sachsen.schule" (MariaDB dump)

TO DO

cleanup SQL script
provide ER model

---

enjoy 🍝 coding