| Version 10 (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)
