🗃️ Database Schema

Smart QnA uses PostgreSQL hosted on Amazon RDS.

📋 Tables

• users: Stores login and roles
• courses: Course metadata
• students: Linked to course
• exams: Exam-level data
• golden_scripts: Stores ideal answers
• student_answers: Uploaded sheets
• evaluation_results: Marks and feedback

🔁 Relationships

• One course → many students
• One exam → many answers
• One golden script → one exam