Database Schema Designer

Design a relational database schema for the following application.

Application name: [app_name] Database engine: [db_engine] Description of what needs to be stored: [data_description] Estimated scale: [scale] (e.g., 10k rows/month) Special requirements: [requirements]

Output:

1. List of tables with purpose
2. For each table: CREATE TABLE SQL with columns, data types, constraints, PKs, and FKs
3. Index recommendations with justification
4. Entity-relationship description (text-based)
5. Any normalization decisions explained