← Back to Projects CASE STUDY · DIPLOMA FINAL YEAR PROJECT
DESKTOP APPLICATION · DATABASE SYSTEM

Log Reporting System

A Windows desktop application developed as a Diploma Final Year Project to manage staff access, log-report submission, supporting evidence, search/filtering and report viewing.

VB.NETWindows FormsMicrosoft SQL Server
Project TypeDiploma Final Year Project
Team StructurePair Project
PlatformWindows Desktop
Case Study ContextLembaga Air Perak
PROJECT CONTEXT

An academic system based on a real organizational setting.

The project used Lembaga Air Perak as an academic case study for a log-reporting workflow. It was developed as a pair project and was not an official client system for the organization.

THE PROBLEM

Log records need structure, access control and easier retrieval.

The system was designed around the need to record staff log reports in a consistent format, store supporting information, manage users and make historical records easier to search, review and reproduce when needed.

CORE FUNCTIONALITY

Desktop workflows connected to a relational database.

AuthenticationAdministrator and staff login workflows.
Staff RegistrationRegister and manage staff information within the application.
Log Report SubmissionCreate and save structured log-report records.
Image EvidenceAssociate supporting image evidence with reports.
Search & FilteringFind existing reports using searchable and filterable records.
Report ViewingReview stored report information from the desktop interface.
Print / SaveSupport report output and document-related operations.
Staff ManagementMaintain user information from the administrative side.
SQL Server StoragePersist application data in a relational database.
TECHNICAL APPROACH

A classic desktop application architecture.

VB.NET

Used for application logic and event-driven desktop functionality.

Windows Forms

Provided the graphical desktop interface for staff and administrator workflows.

Microsoft SQL Server

Stored staff accounts, report records and related application data.

Database-Driven Forms

Connected user actions in the interface with create, retrieve and management operations in the database.

IMPORTANT DESIGN DECISIONS

Keep the workflow clear for everyday desktop use.

01
Separate administrator and staff access

Different user roles support different responsibilities inside the system.

02
Centralize records in SQL Server

A structured relational database makes report history easier to manage than disconnected files or documents.

03
Support evidence alongside text reports

Images provide additional context for log entries instead of relying only on written descriptions.

04
Include search and filtering

Historical reporting data becomes much more useful when users can retrieve relevant records efficiently.

PROJECT BOUNDARY

Academic case study, not client deployment.

Lembaga Air Perak was used as the organizational context for this Diploma Final Year Project. The application should not be interpreted as an official Lembaga Air Perak system or commercial client delivery.
WHAT THIS PROJECT DEMONSTRATES

My foundation in database-backed application development.

Desktop Development

Building event-driven Windows applications with a graphical user interface.

Relational Database Integration

Connecting application workflows to Microsoft SQL Server for persistent data management.

Authentication & CRUD Workflows

Implementing common software patterns such as login, registration, submission, search and record management.

Progression as a Developer

This earlier project shows the database and application-development foundation that later expanded into web, mobile and AI-focused systems.

Back to Home Contact Me