تفاصيل المشروع

Software Analysis Functional Requirements: 1.User :: Student: a.User can sign up i.Required: Name, Mail, Phone, Major, Grade, Age, Gender , photo b.User can login c.User can activate his account by email verifying d.User can reset their password e.User can change and update their info i.Phone, Major, Grade, Age, photo f.Users can show course details i.Course name, Major, Grade, Subject, Level, Teacher, course rate, sessions, sessions duration, status, price, reviews g.User can enroll in a course h.User can pay course fees i.User can see his paid bills and payments j.User can exit with a refund k.User can enroll in real course or a trial session l.User can rate session m.User must be notified with new sessions, quizzes, and exams in registered courses. n.User can be notified with messages o.User can send messages to the teacher who enrolled their courses p.User can attend sessions q.User can attend quizzes and get the result r.User can attend exams and get the result s.User can show their quizzes t.User can show their exams u.User can get certificates at the end of the course v.User can show homework of session w.User can upload answers of homework x.User can chat with support y.User can download material of course z.User can ask and answer in FAQ 2.User :: Teacher: a.User can sign up i.Required: Name, Mail, Phone, Age, Gender , photo ii.Required: Major, Grade, subject, Level, ex years iii.Required: About, intro video b.User can login c.User can activate his account by email verifying d.User can reset their password e.User can change and update their info i.Age. photo, Major, Grade, subject, Level, ex years, About, intro video f.User can create and edit course info i.Course name, Major, Grade, Subject, Level, session duration, status, price, description, schedule g.User can show their course details and schedule h.User can create and edit session info i.Title, status, price, description, schedule i.User can set and change their schedule Session-timetable j.User can show session reviews k.User can manage payments i.Show: payment history, pending, ii.Withdraw available payment l.User must be notified of a new student enrollment, pending, available payment. m.User can be notified with messages n.User can send messages to students enrolled in his courses o.User can Start the session p.User can create questions bank and question be saved automatically and can explore them. i.Subject - Unit - Lesson - Title - Notes q.User can create, edit, schedule quiz and assign questions r.User can create, edit, schedule exam and assign questions s.User can evaluate exams and quizzes t.User can show his quizzes with answers of students and model answer u.User can show their exams with answers of students and model answer v.User can assign homework for session w.User can evaluate homework x.User must put signatures for certificates y.User can chat with support z.User can upload material to class like pdf, videos, images with size limitation on google drive service aa.User can ask and answer in FAQ bb.Statistic on Exams and quizes 3.User :: parent: a.User can sign up b.User can login c.User can activate his account by email verifying d.User can reset password e.User can change and update his info f.Get notify with messages g.Get notify with student sessions, quizzes and exams and results h.Can pay course bill 4.User :: admin: a.User can login using an authenticated account created by the manager account b.User can activate his account by email verifying c.User can reset their password d.User can change and update their info e.User can create and edit rolls for other users f.User can assign roles to other users g.User can lock other users' account h.User can Send messages to all user i.User can Notify all users with messages j.User can send email to users k.User can review teacher's CV and accept or reject l.User can create and edit Curriculums m.User can create and edit Grades n.User can create and edit Level o.User can access questions bank p.User can view all schedules q.User must be notified of new payments for teacher and student r.User must be notified of new teacher registration s.User must be notified with the refund action t.User must be notified if other users need support 5.User :: Manager: ●User can login using an authenticated account ●User can create admin ●User can reset his password ●User can create and edit rolls for other users ●User can assign roles to other users ●User can lock other users' account ●User can Send messages to all user and also delete it ●User can Notify all users with messages ●User can send emails to users ●User can review the teacher's CV and accept or reject and review why was accepted or refused ●User can access questions bank ●User can view all schedules ●User must be notified of new payments for teacher and student ●User must be notified of new teacher registration ●User must be notified of the refund action ●User must be notified if other users need support ●User must be provided with a weekly and monthly report ●All active, deactivated, new Student number ●All active, deactivated, new Teacher number ●Refund ●Paid service ●Other expense ●Taxes & Gross income & ads income & Net income ●User must review all reports Courses Schema: IGCSE has gardes (10, 11, 12) each grade contains subjects (English, Biology, Math, Chemistry, physics humanities, Arabic, ICT) each subject contains Levels ( O, A, AS). SAT has gardes (10, 11, 12) each grade contains subjects (English, Math, EST1 English, EST2 Biology, EST2 Math, EST2 Physics, EST2 Chemistry) . TOEFL IELTS General English Major schema MajorGradeSubjectLevel IGCSE10 11 12English Biology Math Chemistry physics humanities Arabic ICTO A AS SAT10 11 12English Math EST1 English EST2 Biology EST2 Math EST2 Physics EST2 ChemistryNull TOEFLNullReading Writing Speaking ListeningNull IELTSNullReading Writing Speaking ListeningNull General EnglishNullReading Writing Speaking ListeningNull Manager DashBoard Reports: Income Finance details: Total gross and net income, pending. Payment Details with filter on type, status and date with summary Students: Number of New Students Today,week,month Number of paid Students Today,week,month Number of refund students Today,week,month Teacher: Number of New Teacher Today,week,month Number of pending Teacher Today,week,month Number of paid Teacher Today,week,month Courses: Number of courses started Today,week,month Number of session Today,week,month Number of students attend sessions Today,week,month Number of canceled sessions Teacher Details Course Details Session Details Student Details Initial Design Database : 1. Users Table: - UserID (Primary Key) - Name - Email - Phone - Age - Gender - Photo - Password - Activation_Status - Activation_date - Role (Foreign Key to Roles Table) 2. Students Table: - StudentID (Primary Key, Foreign Key to Users Table) - Major - Grade 3. Teachers Table: - TeacherID (Primary Key, Foreign Key to Users Table) - Major - Grade - Subject - Experience_Years - About - Intro_Video_url 4. Parents Table: - ParentID (Primary Key, Foreign Key to Users Table) 5. Admins Table: - AdminID (Primary Key, Foreign Key to Users Table) 6. Managers Table: - ManagerID (Primary Key, Foreign Key to Users Table) 7. Roles Table: - RoleID (Primary Key) - Role_Name - Description - Notes 8. Courses Table: - CourseID (Primary Key) - Course_Name - Major - Grade - Subject - Level - TeacherID (Foreign Key to Teachers Table) - Course_Rate * - Session_Duration - Status - Price - Number of sessions Courses rate comment Table: 9. Enrollments Table: - EnrollmentID (Primary Key) - UserID (Foreign Key to Users Table) - CourseID (Foreign Key to Courses Table) - Enrollment_Type (Real Course or Trial Session) - Date 10. Payments Table: - PaymentID (Primary Key) - UserID (Foreign Key to Users Table) - itemID: CourseID (Foreign Key to Courses Table) - Type course, exam, service, expense - Amount - Payment_Date - Status 11. Messages Table: - MessageID (Primary Key) - SenderID (Foreign Key to Users Table) - ReceiverID (Foreign Key to Users Table) - Message_Content - Timestamp - Read_ststus - Delete Flag 12. Sessions Table: - SessionID (Primary Key) - CourseID (Foreign Key to Courses Table) - Title - Status - Price - Description - Schedule 13. Sessions Attendance Table: - SessionID (Foreign Key to Session Table) - CourseID (Foreign Key to Courses Table) - StudentID (Foreign Key to Student Table) - Date - Status 14. Questions Bank Table: - QuestionID (Primary Key) - creatorID (Foreign Key to Teacher) - creation_date - question_type: written , mcq, matching - major - grade - level - Subject - Unit - Lesson - Title - Notes - Question_Content - choice1 - choice2 - choice3 - choice4 - part1 - part2 - Answer - Timestamp 15. Quizzes Table: - QuizID (Primary Key) - SessionID (Foreign Key to Sessions Table) - Schedule_date 16. Exams Table: - ExamID (Primary Key) - CourseID (Foreign Key to Sessions Table) - creatorID (Foreign Key to Teacher Table) - Schedule - Questions - Timestamp 17. Quizzes_exams Questions Table: - ID (Primary Key) - QuestionID (Foreign Key to Questions Table) 18. Quizzes_exams Questions student answer Table: - ID (Primary Key) - QuestionID (Foreign Key to Questions Table) - studentID (Foreign Key to student Table) - answer - garde - model answer - Timestamp 19. Homework Table: - HomeworkID (Primary Key) - SessionID (Foreign Key to Sessions Table) - Title - Description - Deadline 20. Homework Answers Table: - AnswerID (Primary Key) - UserID (Foreign Key to Users Table) - HomeworkID (Foreign Key to Homework Table) - Answer_Content - Timestamp 21. Certificates Table: - CertificateID (Primary Key) - UserID (Foreign Key to Users Table) - CourseID (Foreign Key to Courses Table) - Date_Issued 22. FAQs Table: - FAQID (Primary Key) - session_id - Question - Answer 23. Support Chat Table: - ChatID (Primary Key) - UserID (Foreign Key to Users Table) - Support_Team_MemberID (Foreign Key to Users Table) - Message_Content - Timestamp 24. Material Table: - MaterialID (Primary Key) - CourseID (Foreign Key to Courses Table) subject - Material_Type - Material_URL - Upload_Date - Num of downloads 25. Reviews Table: - ReviewID (Primary Key) - UserID (Foreign Key to Users Table) - CourseID (Foreign Key to Courses Table) - SessionID (Foreign Key to Session Table) - Rating - Review_Content - Timestamp 26. Schedule Table: - ScheduleID (Primary Key) - TeacherID (Foreign Key to Teachers Table) - SessionID (Foreign Key to Sessions Table) - Date - Start_Time - End_Time 27. Notifications Table: - Notification_id (Primary Key) - reciverID (Foreign Key to Teachers Table) - Date - status - content Blogs 1. User Management: - POST /api/signup (User sign up) - POST /api/login (User login) - POST /api/activate (Activate user account) - POST /api/reset_password (Reset user password) - PUT /api/user/:id (Update user info) 2. Course Management: - GET /api/courses (Get course details) - POST /api/enroll (Enroll in a course) - POST /api/payments (Pay course fees) - GET /api/payments/:userID (Get user's paid bills and payments) - DELETE /api/enroll/:enrollmentID (Exit from a course with refund) 3. Session Management: - GET /api/sessions/:userID (Get user's sessions) - POST /api/sessions/:sessionID/rate (Rate a session) 4. Quiz and Exam Management: - GET /api/quizzes/:userID (Get user's quizzes) - GET /api/exams/:userID (Get user's exams) - POST /api/quizzes/:quizID/submit (Submit quiz answers) - POST /api/exams/:examID/submit (Submit exam answers) 5. Homework Management: - GET /api/homework/:userID (Get user's homework) - POST /api/homework/:homeworkID/submit (Submit homework answers) 6. Certificate Management: - GET /api/certificates/:userID (Get user's certificates) 7. Message Management: - GET /api/messages/:userID (Get user's messages) - POST /api/messages (Send message) 9. Material Download: - GET /api/materials/:courseID/download (Download course material) 10. FAQs Management: - GET /api/faqs (Get FAQs) - POST /api/faqs (Ask question) - PUT /api/faqs/:faqID (Answer question) 11. Teacher Management: - POST /api/teacher/signup (Teacher sign up) - PUT /api/teacher/:id (Update teacher info) - POST /api/teacher/courses (Create course) - PUT /api/teacher/courses/:courseID (Update course info) - DELETE /api/teacher/courses/:courseID (Delete course) - POST /api/teacher/sessions (Create session) - PUT /api/teacher/sessions/:sessionID (Update session info) - DELETE /api/teacher/sessions/:sessionID (Delete session) - POST /api/teacher/quizzes (Create quiz) - PUT /api/teacher/quizzes/:quizID (Update quiz info) - DELETE /api/teacher/quizzes/:quizID (Delete quiz) - POST /api/teacher/exams (Create exam) - PUT /api/teacher/exams/:examID (Update exam info) - DELETE /api/teacher/exams/:examID (Delete exam) - POST /api/teacher/homework (Assign homework) - PUT /api/teacher/homework/:homeworkID (Update homework info) - DELETE /api/teacher/homework/:homeworkID (Delete homework) 12. Admin and Manager Management: - POST /api/admin/signup (Admin sign up) - POST /api/manager/signup (Manager sign up) - PUT /api/admin/:id (Update admin info) - PUT /api/manager/:id (Update manager info) - POST /api/admin/roles (Create role) - PUT /api/admin/roles/:roleID (Update role) - DELETE /api/admin/roles/:roleID (Delete role) - POST /api/admin/notifications (Send notification)

مشروع موقع تعليمي بلغة لارفيل

نقاط الجدية مشروع جاد