Database Schema (Tables) + Python Implementation (Extensible)

[amjadAwad95]

Goal: Create a database schema that contains the tables User and Presentation, then build Python code to create and use these tables. The design must be extensible so new tables can be added easily later.

---

Requirements

• Create a database schema that includes tables:
  • User
  • Presentation
• Make the codebase extensible:
  • Adding a new table should be as easy as creating a new model/class and running migrations/creation.

---

Deliverables

• Tables design (fields + types + relationships)
• Table creation (SQL or ORM models)
• Python code that:
  • Connects to DB
  • Creates the tables
  • Inserts a user
  • Inserts a presentation linked to a user
  • Queries presentations by user
• Example extension:
  • Add a new table (e.g., Slide) without changing existing tables

---

Acceptance Criteria

• Tables created successfully with correct keys
• Relationship works (user → presentations)
• Python demo script runs end-to-end
• Adding a new table requires minimal changes