DASHBOARD
Agency performance at a glance
Total Artists
—
Active Trainees
—
Concerts Scheduled
—
Merch Items
—
Top Artists
by debut year
Upcoming Concerts
next 3
Revenue Overview — Ticket Sales by Concert
ARTISTS
Manage signed artist profiles and contracts
Add New Artist
All Artists
| ID | Stage Name | Real Name | Genre | Debut | Contract End | Status | Actions |
|---|
TRAINEES
Track trainee progress and daily attendance
Enroll New Trainee
Log Attendance
Real-Time Update
All Trainees
| ID | Name | DOB | Specialty | Enrolled | Monthly Fee | Status | Actions |
|---|
EVALUATIONS
Score trainees across skills — triggers artist debut consideration
Submit Evaluation
Evaluation Records (JOIN: Trainees + Evaluations)
SQL JOIN
| ID | Trainee | Date | Vocal | Dance | Visual | Overall | Notes |
|---|
CONCERTS & TOURS
Schedule events and manage venues
Schedule Concert
Concert Schedule (JOIN: Artists + Concerts)
SQL JOIN
| ID | Concert | Artist | Venue | City | Date | Capacity | Ticket Price | Status | Actions |
|---|
TICKET SALES
Real-time ticket sale logging and revenue tracking
Record Ticket Sale
Live Update
Sales Records (JOIN: Concerts + Tickets)
SQL JOIN
| ID | Concert | Buyer | Qty | Seat | Unit Price | Total | Sale Date | Actions |
|---|
MERCHANDISE
Inventory management with real-time stock updates
Add Merchandise Item
Adjust Stock
Real-Time Update
Inventory (JOIN: Artists + Merchandise)
SQL JOIN
| ID | Item Name | Artist | Category | Price | Stock | Status | Actions |
|---|
SQL TERMINAL
Execute raw SQL — DDL, DML, DQL, Joins
nova_agency.db — SQL Shell
Output
-- Results will appear here
DB SCHEMA
Entity Relationship Overview
Tables & Relationships
Artists (artist_id PK, stage_name, real_name, genre, debut_year, contract_end, status)
│
├──▶ Concerts (concert_id PK, name, artist_id FK, venue, city, concert_date, capacity, ticket_price, status)
│ │
│ └──▶ Tickets (ticket_id PK, concert_id FK, buyer_name, quantity, seat_category, sale_date)
│
└──▶ Merchandise (merch_id PK, item_name, artist_id FK, category, price, stock_quantity)
Trainees (trainee_id PK, full_name, dob, specialty, enrolled_date, monthly_fee, status)
│
├──▶ Evaluations (eval_id PK, trainee_id FK, eval_date, vocal_score, dance_score, visual_score, overall_score, notes)
│
└──▶ Attendance (att_id PK, trainee_id FK, att_date, att_status)
──────────────────────────────────────────────────────
DDL Operations: CREATE TABLE (with constraints, foreign keys, CHECK)
DML Operations: INSERT INTO, UPDATE SET, DELETE WHERE
DQL Operations: SELECT, WHERE, GROUP BY, ORDER BY, HAVING
Joins Used: INNER JOIN, LEFT JOIN across Artists↔Concerts↔Tickets
Trainees↔Evaluations, Artists↔Merchandise
Constraints: PRIMARY KEY, FOREIGN KEY, NOT NULL, CHECK, DEFAULT