Scholarships

idnameamount
1Academic Excellence Scholarship2000.0
2Service Leadership Scholarship1500.0
3Young Leader Scholarship1000.0
4Needy Student Grant500.0
5Artistic Talent Award750.0

Criteria

idvalue
1Academic Achievement
2Community Service
3Leadership Skills
4Financial Need
5Extracurricular Activities

Scholarship_Criteria

scholarship_idcriterion_id
(→ Scholarships.id)(→ Criteria.id)
11
21
31
41
51
52

Students

student_idfirst_namelast_nameemailphone_numberadmission_date
1JohnDoejohn.doe@example.com+123-456-78902021-08-01
2JaneSmithjane.smith@example.com+123-456-78902021-08-01
3TomBrowntom.brown@example.com+123-456-78902021-08-01
4AliceGreenalice.green@example.com+123-456-78902021-08-01
5MikeBlackmike.black@example.com+123-456-78902021-08-01

Applications

application_idstudent_idscholarship_idsubmission_datestatus
(→ Students.student_id)(→ Scholarships.id)
1112021-09-01Pending
2222021-09-01Approved
3332021-09-01Rejected
4442021-09-01Under Review
5552021-09-01Withdrawn