Term Database in SQLite

README / LICENSE

Copyright (c) 2025 Yuto “Possior” Morii. Use at Your Own Risk, No Warranty.

List of Contents

1. ~/database.db | Term Database.
2. ~/LICENSE | MIT License.
3. ~/README.md | Project Description.
4. ~/SCRIPT/associative.sql | Associative Table Script.
5. ~/SCRIPT/base.sql | Base Table Script.
6. ~/SCRIPT/structure.sql | Structure Script.

Requirements

Usage

• If the database file (database.db) does not exist, create a new database file (database.db). If the database file (database.db) exists, connect to it. Then execute the structure script (structure.sql) to build the relational database structure.

  sqlite3 ./database.db < ./SCRIPT/structure.sql

• If the database file (database.db) does not exist, create a new database file (database.db). If the database file (database.db) exists, connect to it. Then execute the base table script (base.sql) to input the values into the base tables.

  sqlite3 ./database.db < ./SCRIPT/base.sql

• If the database file (database.db) does not exist, create a new database file (database.db). If the database file (database.db) exists, connect to it. Then execute the associative table script (associative.sql) to input the values into the associative tables.

  sqlite3 ./database.db < ./SCRIPT/associative.sql

Want-to-Do List

• Update the names of the tables in the associative table script (associative.sql).
• Write the requirement section of the description file (README.md).
• Develop a Python program (structure.py) to build the relational database structure.
• Develop a Python program (base.py) to input the values into the base tables.
• Develop a Python program (associative.py) to input the values into the base tables.
• Develop a Python program (query.py) to output a custom table queried from the database.