== Issuing a Certificate

==== Actors: **System (automatic)**

**1.** Course Completion Verification.

{{{#!sql
UPDATE enrollment
SET completion_status = 'COMPLETED',
    progress_percentage = 100
WHERE enrollment_id = :enrollmentId;

}}}


**2.** Certificate Generation.

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


}}}