| Version 6 (modified by , 7 days ago) ( diff ) |
|---|
Application Design – Use Cases and Database Access Scenarios – SQL Views
Actors
Guest User (Unauthenticated User)
A user who does not have an active session. Can access only public information such as the list of courses and categories.
Registered User (USER)
A logged-in user. Can purchase subscriptions, enroll in courses, watch lessons, take quizzes, and receive certificates.
Instructor (INSTRUCTOR)
A privileged user who creates and manages courses, modules, and lessons, and can review enrolled students’ progress.
Administrator (ADMIN)
A user with full privileges who manages support tickets and oversees platform operations.
Scenarios
Viewing Available Courses (Public Access)
Watching Lessons and Taking a Quiz
Creating a Course (Instructor)
Adding Modules and Lessons (Instructor)
Viewing Enrolled Students per Course (Instructor)
Viewing All Support Tickets (Admin)
Most Important Use Cases
Viewing Available Courses (Public Access)
Watching Lessons and Taking a Quiz
