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

User Login

New User Registration

Purchasing a Subscription

Viewing Available Courses (Public Access)

Enrolling in a Course

Client Registration

Watching Lessons and Taking a Quiz

Issuing a Certificate

Creating a Course (Instructor)

Adding Modules and Lessons (Instructor)

Viewing Enrolled Students per Course (Instructor)

Support Tickets (Admin)

Viewing All Support Tickets (Admin)

Most Important Use Cases

Store and Owner Registration

Client Registration

Placing an Order

Submitting a Customer Request

Product Update

Generating Reports (Monthly / Yearly / Sales / Profit)

Refund Processing