Student Database Management System

Features to Implement

You will work with the Kaggle Students Performance Dataset - a popular educational dataset containing 1,000 student records with demographic information, parental education levels, test preparation status, and exam scores across math, reading, and writing subjects. This real-world dataset is perfect for building a comprehensive student management system.

Dataset Schema

Sample Data Preview

Here is what typical student records look like from the Kaggle dataset:

Your project must include all of the following components. Structure your code with clear organization and documentation.

struct Student {
    string studentId;      // STU0001 - STU1000
    string gender;         // female, male
    string raceEthnicity;  // group A-E
    string parentalEdu;    // education level
    string lunch;          // standard, free/reduced
    string testPrep;       // none, completed
    int mathScore;         // 0-100
    int readingScore;      // 0-100
    int writingScore;      // 0-100
    int totalScore;        // Calculated: sum of scores
    float averageScore;    // Calculated: average
    string grade;          // A, B, C, D, F
    
    // Constructor, display(), validate() methods
};

Implement the following features with the specified behavior. Each feature should be accessible from the main menu.

Sample Menu Output

╔══════════════════════════════════════════════════════════════╗
║           TECHVARSITY STUDENT MANAGEMENT SYSTEM              ║
╠══════════════════════════════════════════════════════════════╣
║  1. Add New Student                                          ║
║  2. View All Students                                        ║
║  3. Search Students                                          ║
║  4. Update Student                                           ║
║  5. Delete Student                                           ║
║  6. Sort Students                                            ║
║  7. Statistics                                               ║
║  8. Save and Exit                                            ║
╚══════════════════════════════════════════════════════════════╝
   Enter your choice (1-8): _

Organize your code into multiple files for better maintainability. Here's the recommended project structure:

student-database-system/
├── src/
│   ├── main.cpp              # Entry point, main menu loop
│   ├── student.h             # Student struct/class definition
│   ├── student.cpp           # Student member function implementations
│   ├── database.h            # Database class (CRUD operations)
│   ├── database.cpp          # Database implementations
│   ├── filehandler.h         # File I/O functions
│   ├── filehandler.cpp       # File handling implementations
│   └── utils.h               # Utility functions (validation, formatting)
├── data/
│   ├── students_sample.csv   # Sample data file
│   ├── departments.csv       # Department data
│   └── backup/               # Backup files folder
├── screenshots/
│   ├── main_menu.png         # Screenshot of main menu
│   ├── add_student.png       # Screenshot of adding student
│   └── search_results.png    # Screenshot of search results
├── Makefile                  # Build instructions (optional)
└── README.md                 # Project documentation

Key Functions to Implement

// filehandler.h
vector<Student> loadFromCSV(string filename);
bool saveToCSV(string filename, vector<Student>& students);
bool createBackup(string filename);

// student.h
struct Student {
    // data members
    void display() const;
    bool validate() const;
    string toCSV() const;
    static Student fromCSV(string line);
};

// database.h
class StudentDatabase {
private:
    vector<Student> students;
    string filename;
public:
    void addStudent(Student s);
    Student* findById(string id);
    vector<Student> searchByName(string name);
    bool updateStudent(string id, Student s);
    bool deleteStudent(string id);
    void sortByGPA(bool ascending = false);
    void displayStats();
};

Create a public GitHub repository with the exact name shown below:

Required Project Structure

student-database-system/
├── src/
│   ├── main.cpp              # Main program entry point
│   ├── student.h             # Student class/struct header
│   ├── student.cpp           # Student implementations
│   ├── database.h            # Database operations header
│   ├── database.cpp          # Database implementations
│   └── utils.h               # Utility functions
├── data/
│   └── students_sample.csv   # Sample data file
├── screenshots/
│   ├── menu.png              # Main menu screenshot
│   ├── add.png               # Add student screenshot
│   └── search.png            # Search results screenshot
└── README.md                 # Project documentation

Your project will be graded on the following criteria. Total: 500 points.

Grading Levels

Use this checklist to verify you have completed all requirements before submitting your project.