Student Management System - Database Setup

This file explains how to set up and use the database for the Student Management System.

---

1. **Database Name**: `student_management`

2. **Tables**:
    - **Students**: Stores student information (ID, name, email, password, date of birth).
    - **Courses**: Stores course information (ID, name, code, description).
    - **Registration**: Tracks student course enrollments (student ID, course ID).
    - **Grades**: Stores student grades (student ID, course ID, grade, remarks).
    - **Instructors**: Has instructor information (instructor_id, first_name, last_name, email, password)
    - **instructor_courses: has courses (id, instructor_id, course_id)
    - **admin**: has admin information (admin_id, username, password)

---

3. **Files**:
    - **`create.sql`**: Creates the database and tables.
    - **`load.sql`**: Loads sample data into the database.

---

4. **Setup Instructions**:

    - **Step 1**: Run `create.sql` to create the database and tables.

      SOURCE C:/xampp/htdocs/CST225/Final Project/Loading_Relations/create.sql;

    - **Step 2**: Run `load.sql` to insert sample data into the tables.
      
	SOURCE C:/xampp/htdocs/CST225/Final Project/Loading_Relations/load.sql;

    - **Step 3**: Check the data by running queries like:
      ```sql
      SELECT * FROM Students;
      ```

---

5. **Notes**:
    - The sample data includes 10 students, 10 courses, and their enrollment/grades.
    - Modify the data as needed for your enjoyment. 

---
Student login 
Username: 1
Password: pass1
--
Instructor login
Username: Instructor123
Password: pass
--
Admin Login
Username: admin123
Password: pass
End of README.