search

fatemehSalarzaei / coursemaster

A comprehensive course management system developed using Django. Features include course creation, editing, and deletion, student enrollment management, session scheduling, progress tracking, and notification sending. Designed to help educational institutions efficiently manage courses and enhance the student learning experience.
0 stars 0 forks source link

Database Design #2

Closed fatemehSalarzaei closed 1 month ago

fatemehSalarzaei commented 1 month ago
    • Requirements Analysis and Initial Design
    • Create Database Models in Django
    • Database Configuration and Migrations
    • Implement Model Relationships
fatemehSalarzaei commented 1 month ago

Model and Database Design Overview

This project involves developing a comprehensive learning management system with the following key components:

  1. User Management:

    • CustomUser: Base model for user authentication and management.
    • Instructor: Inherits from CustomUser, including fields for biography, specialization, and photo.
    • Student: Inherits from CustomUser, with additional fields for address, profile picture, and emergency contact.

  2. Courses and Enrollments:

    • Course: Manages course details including title, cost, description, schedule, and status.
    • Enrollment: Tracks student enrollments in courses, including registration and payment statuses.

  3. Sessions and Attendance:

    • Session: Represents individual class sessions, with fields for date, duration, content, and attendance tracking.
    • Attendance: Tracks student presence for each session.

  4. Exams and Assignments:

    • Exam: Manages exam details, including questions and answers.
    • Assignment: (if applicable) Handles assignments related to exams.

  5. Notifications:

    • InstructorNotification: Facilitates notifications from instructors to students, with options for global or specific notifications.

  6. Payments:

    • Payments: Manages payment transactions and invoices for course enrollments, including tracking and financial records.

  7. Reports:

    • Reports: A dedicated app for generating and managing various reports and analytics related to courses, enrollments, and other system metrics.

    Design Considerations

    • Relationships: Models are designed with clear relationships, e.g., students and instructors linked to courses, sessions linked to courses, and exams linked to sessions.
    • Scalability: The design supports scalability for handling multiple users, courses, and transactions.
    • Flexibility: The design allows for adjustments and additions, such as more detailed reporting or additional user roles.

This design provides a robust framework for managing educational content, user interactions, and financial transactions within the system, with a dedicated focus on reporting and analytics.