Issuing a Certificate

Actors: System (automatic)

1. Course Completion Verification.

UPDATE enrollment
SET completion_status = 'COMPLETED',
    progress_percentage = 100
WHERE enrollment_id = :enrollmentId;

2. Certificate Generation.

INSERT INTO certificate (enrollment_id, issue_date, certificate_code, status)
VALUES (
    :enrollmentId,
    CURRENT_DATE,
    :certificateCode,
    'ISSUED'
);