Visitor Manager

Project contents

• main.py - Tkinter GUI with CRUD, import/export CSV, and search.
• models.py - Database access, auto-recovery from corruption, CRUD operations.
• db_init.py - Optional standalone DB initializer script.
• database_design.sql - Schema file for DB creation.
• ERD.md - ERD diagram (Mermaid).
• SYSTEM_INTEGRATION.md - Notes on integration and architecture.
• USER_MANUAL.md - Instructions for users.
• SAMPLE_DATA.csv - example data to import.
• requirements.txt - Python dependencies.

Quick start

1. Extract the ZIP.
2. (Optional) Create a virtual environment:

   python -m venv venv
   venv\Scripts\activate   # Windows
   source venv/bin/activate  # macOS / Linux

3. Install dependencies:

   pip install -r requirements.txt

4. Run the app:

   python main.py

Notes

• If visitors.db is corrupted, models.init_db() will attempt to auto-rebuild it.
• To reset DB manually, delete visitors.db (and -wal / -shm files) and relaunch the app.