| Version 11 (modified by , 15 hours 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)
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)
Viewing Enrolled Students per Course (Instructor)
