Muhammad Fari Madyan
Hire me
Laravel · bagian 3 dari 11

Laravel E-Learning Part 3: Desain Skema Database

Mendesain skema database yang robust untuk platform e-learning dengan users, mata pelajaran, ujian, soal, dan hasil menggunakan Laravel migrations.

Muhammad Fari Madyan

· 4 menit baca

Read in English →

Gambaran Entity Relationship

Sebelum menulis kode, mari kita pahami model datanya terlebih dahulu:

Entity Relationship Diagram

E-Learning Database ERD

Gambaran Tabel

TabelDeskripsiRelasi Utama
usersSemua user (Admin, Guru, Siswa)Punya role via Spatie
subjectsMata pelajaran (Matematika, Fisika, dll.)Milik Guru
examsUjian/tes individualMilik Subject, punya banyak Question
questionsSoal ujianMilik Exam
exam_attemptsSesi ujian siswaMilik Exam dan Student
answersJawaban siswaMilik ExamAttempt dan Question

Relasi Laravel Eloquent

ModelRelasiModel Terkait
User (Guru)hasManySubject
SubjectbelongsToUser
SubjecthasManyExam
ExambelongsToSubject
ExamhasManyQuestion
ExamhasManyExamAttempt
QuestionbelongsToExam
ExamAttemptbelongsToUser (Siswa)
ExamAttemptbelongsToExam
ExamAttempthasManyAnswer
AnswerbelongsToExamAttempt
AnswerbelongsToQuestion

Step 1: Buat Migrations

Tabel Subjects

BASH
php artisan make:migration create_subjects_table
PHP
<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    public function up(): void
    {
        Schema::create('subjects', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->string('code')->unique();
            $table->text('description')->nullable();
            $table->foreignId('teacher_id')->constrained('users')->onDelete('cascade');
            $table->boolean('is_active')->default(true);
            $table->timestamps();
        });
    }

    public function down(): void
    {
        Schema::dropIfExists('subjects');
    }
};

Tabel Exams

BASH
php artisan make:migration create_exams_table
PHP
<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    public function up(): void
    {
        Schema::create('exams', function (Blueprint $table) {
            $table->id();
            $table->string('title');
            $table->text('description')->nullable();
            $table->foreignId('subject_id')->constrained()->onDelete('cascade');
            $table->integer('duration_minutes')->default(60);
            $table->integer('passing_score')->default(60);
            $table->integer('total_questions')->default(0);
            $table->dateTime('start_time');
            $table->dateTime('end_time');
            $table->enum('status', ['draft', 'published', 'closed'])->default('draft');
            $table->boolean('shuffle_questions')->default(false);
            $table->boolean('show_result')->default(true);
            $table->timestamps();
        });
    }

    public function down(): void
    {
        Schema::dropIfExists('exams');
    }
};

Tabel Questions

BASH
php artisan make:migration create_questions_table
PHP
<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    public function up(): void
    {
        Schema::create('questions', function (Blueprint $table) {
            $table->id();
            $table->foreignId('exam_id')->constrained()->onDelete('cascade');
            $table->text('question_text');
            $table->enum('question_type', ['multiple_choice', 'true_false', 'essay'])->default('multiple_choice');
            $table->json('options')->nullable(); // Untuk pilihan ganda
            $table->string('correct_answer');
            $table->integer('points')->default(1);
            $table->integer('order')->default(0);
            $table->timestamps();
        });
    }

    public function down(): void
    {
        Schema::dropIfExists('questions');
    }
};

Tabel Exam Attempts

BASH
php artisan make:migration create_exam_attempts_table
PHP
<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    public function up(): void
    {
        Schema::create('exam_attempts', function (Blueprint $table) {
            $table->id();
            $table->foreignId('exam_id')->constrained()->onDelete('cascade');
            $table->foreignId('student_id')->constrained('users')->onDelete('cascade');
            $table->dateTime('started_at');
            $table->dateTime('completed_at')->nullable();
            $table->integer('score')->nullable();
            $table->integer('correct_answers')->default(0);
            $table->integer('total_answered')->default(0);
            $table->enum('status', ['in_progress', 'completed', 'timed_out'])->default('in_progress');
            $table->timestamps();
            
            $table->unique(['exam_id', 'student_id']);
        });
    }

    public function down(): void
    {
        Schema::dropIfExists('exam_attempts');
    }
};

Tabel Answers

BASH
php artisan make:migration create_answers_table
PHP
<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    public function up(): void
    {
        Schema::create('answers', function (Blueprint $table) {
            $table->id();
            $table->foreignId('exam_attempt_id')->constrained()->onDelete('cascade');
            $table->foreignId('question_id')->constrained()->onDelete('cascade');
            $table->text('answer')->nullable();
            $table->boolean('is_correct')->nullable();
            $table->integer('points_earned')->default(0);
            $table->timestamps();
            
            $table->unique(['exam_attempt_id', 'question_id']);
        });
    }

    public function down(): void
    {
        Schema::dropIfExists('answers');
    }
};

Step 2: Buat Models

Model Subject

BASH
php artisan make:model Subject
PHP
<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasMany;

class Subject extends Model
{
    use HasFactory;

    protected $fillable = [
        'name',
        'code',
        'description',
        'teacher_id',
        'is_active',
    ];

    protected $casts = [
        'is_active' => 'boolean',
    ];

    public function teacher(): BelongsTo
    {
        return $this->belongsTo(User::class, 'teacher_id');
    }

    public function exams(): HasMany
    {
        return $this->hasMany(Exam::class);
    }
}

Model Exam

PHP
<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasMany;

class Exam extends Model
{
    use HasFactory;

    protected $fillable = [
        'title',
        'description',
        'subject_id',
        'duration_minutes',
        'passing_score',
        'total_questions',
        'start_time',
        'end_time',
        'status',
        'shuffle_questions',
        'show_result',
    ];

    protected $casts = [
        'start_time' => 'datetime',
        'end_time' => 'datetime',
        'shuffle_questions' => 'boolean',
        'show_result' => 'boolean',
    ];

    public function subject(): BelongsTo
    {
        return $this->belongsTo(Subject::class);
    }

    public function questions(): HasMany
    {
        return $this->hasMany(Question::class);
    }

    public function attempts(): HasMany
    {
        return $this->hasMany(ExamAttempt::class);
    }

    public function isActive(): bool
    {
        $now = now();
        return $this->status === 'published' 
            && $now->between($this->start_time, $this->end_time);
    }
}

Model Question

PHP
<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;

class Question extends Model
{
    use HasFactory;

    protected $fillable = [
        'exam_id',
        'question_text',
        'question_type',
        'options',
        'correct_answer',
        'points',
        'order',
    ];

    protected $casts = [
        'options' => 'array',
    ];

    public function exam(): BelongsTo
    {
        return $this->belongsTo(Exam::class);
    }
}

Step 3: Jalankan Migrations

BASH
php artisan migrate

Step 4: Buat Seeders

BASH
php artisan make:seeder SubjectSeeder
PHP
<?php

namespace Database\Seeders;

use App\Models\Subject;
use App\Models\User;
use Illuminate\Database\Seeder;

class SubjectSeeder extends Seeder
{
    public function run(): void
    {
        $teacher = User::first();

        $subjects = [
            ['name' => 'Matematika', 'code' => 'MATH101'],
            ['name' => 'Fisika', 'code' => 'PHYS101'],
            ['name' => 'Bahasa Inggris', 'code' => 'ENG101'],
            ['name' => 'Ilmu Komputer', 'code' => 'CS101'],
        ];

        foreach ($subjects as $subject) {
            Subject::create([
                ...$subject,
                'teacher_id' => $teacher->id,
            ]);
        }
    }
}

Ringkasan

Kita sudah mendesain skema database lengkap dengan:

  • ✅ Mata pelajaran yang dikelola guru
  • ✅ Ujian dengan pengaturan yang fleksibel
  • ✅ Soal dengan berbagai tipe
  • ✅ Sesi ujian (attempt) dan jawaban siswa
  • ✅ Relasi dan constraint yang tepat

Selanjutnya

Di Part 4, kita akan mengimplementasikan autentikasi dan role user:

  • Akses berbasis role (Admin, Guru, Siswa)
  • Panel Filament terpisah untuk setiap role
  • Manajemen permission dengan Spatie

Lanjut ke Part 4: Autentikasi & Role User →

BagikanLinkedInXWhatsApp

Ditulis oleh Muhammad Fari Madyan

Senior Backend Engineer dan co-founder LampungDev. Saya menuliskan apa yang saya bangun supaya orang lain bisa ikut belajar.

Ajak kerja sama
← bagian 2Setup Laravel 12 dengan Filament Admin Panelbagian 4 →Autentikasi & Role User

Muhammad Fari Madyan

Senior Backend Engineer building real-time, high-concurrency systems that hold up in production. Co-founder of LampungDev. Based in Bandar Lampung, Indonesia (UTC+7), working remote.

Work

Case studiesCahTixExam platform, 4 stacksOpen source

© 2026 Muhammad Fari Madyan

Designed and built by Muhammad Fari Madyan