T012: Apply EF Core migration to database

[Hemavathi15sg]

Phase 2: Foundational

Task: T012
Status: Not Started
Story: Foundational (blocking all user stories)
Depends On: T011 (migration created)

Description

Apply EF Core migration to database to create Certificate-related tables.

Acceptance Criteria

• Run: dotnet ef database update --context CourseRegistrationDbContext --project CourseRegistration.Infrastructure
• All tables created successfully:
  • Certificate table exists with correct schema
  • CertificateVerification table exists
  • CertificateAuditLog table exists
• All indexes created and verified (query execution plans use indexes)
• All constraints enforced at database level
• Database schema matches data-model.md specifications
• Migration can be rolled back: dotnet ef database update <previous-migration>

Effort Estimate

1 hour

References

• data-model.md: Full schema specification
• plan.md: Technical Context (SQL Server)