## Scholarships

id | name | amount
--- | --- | ---
1 | Academic Excellence Scholarship | 2000.0
2 | Service Leadership Scholarship | 1500.0
3 | Young Leader Scholarship | 1000.0
4 | Needy Student Grant | 500.0
5 | Artistic Talent Award | 750.0

## Criteria

id | value
--- | ---
1 | Academic Achievement
2 | Community Service
3 | Leadership Skills
4 | Financial Need
5 | Extracurricular Activities

## Scholarship_Criteria

scholarship_id | criterion_id
--- | ---
(→ Scholarships.id) | (→ Criteria.id)
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
5 | 2

## Students

student_id | first_name | last_name | email | phone_number | admission_date
--- | --- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | +123-456-7890 | 2021-08-01
2 | Jane | Smith | jane.smith@example.com | +123-456-7890 | 2021-08-01
3 | Tom | Brown | tom.brown@example.com | +123-456-7890 | 2021-08-01
4 | Alice | Green | alice.green@example.com | +123-456-7890 | 2021-08-01
5 | Mike | Black | mike.black@example.com | +123-456-7890 | 2021-08-01

## Applications

application_id | student_id | scholarship_id | submission_date | status
--- | --- | --- | --- | ---
| (→ Students.student_id) | (→ Scholarships.id) |  |
1 | 1 | 1 | 2021-09-01 | Pending
2 | 2 | 2 | 2021-09-01 | Approved
3 | 3 | 3 | 2021-09-01 | Rejected
4 | 4 | 4 | 2021-09-01 | Under Review
5 | 5 | 5 | 2021-09-01 | Withdrawn