SQL based Student Grader - OPEN FOR FYs

[Once-1296]

Project Idea

• We need to write a CLI program that allows for CRUD operations on a single type of entry: a student's grade in a subject
• The columns expected are: student_name, student_id, subject_name, subject_id, grade, status (fail or pass)
• subject_id and student_id should form a composite key that is unique to all entries.

List the important libraries you believe would be necessary

1. sqlite3

Additional goals

• can you add student_name and subject_name to foreign tables? this allows for normalising the data and reducing redundant use of space
• can you make this a GUI interface?