← Back to Portfolio C++ · MySQL · Database Normalization

Homestay Booking & Management System

Full-Stack Console App MySQL Database Business Rules Tax Compliance (RM10/night)
Homestay Booking & Management Cover Page
Duration
Workshop 1, 2025/2026
Technology Stack
C++ Console / MySQL
Database Structure
3NF Normalized Schema

What the Project Does

This C++ console application is designed to streamline homestay accommodation operations in Melaka, Malaysia. Manual property tracking often leads to scheduling conflicts, pricing math errors, and incomplete expense ledgers. This system provides a unified administration console that manages reservations, enforces specific local hospitality taxes, records costs, and visualizes monthly profit and loss analysis.

  • Role-Based Access Control: Enforces distinct operation panels for Super Administrators (system settings & accounts), Administrators (property setup & expense logging), and Customers (searching rooms & reservations).
  • 5 Core Modules: Structured modular system containing User Management, Property Management, Booking Reservation, Expense Management Ledger, and Report Analytics.
  • Regulatory Tax Integration: Automatically collects guest IC validation and computes the mandatory Malaysian Tourism Tax (RM10 per room per night as mandated by the Malaysian Tourism Industry Act 1992).
  • Financial Tracking: Logs utility, maintenance, and tax expenses, correlating them to specific properties to analyze net profit/loss.

Output Examples & Performance

The system implements complex calculations to dynamically calculate seasonal rates, promotional discounts, and Malaysian tourism taxes. The billing and reporting modules demonstrate high reliability and accuracy:

1. System Billing Calculation Structure

    BILLING SUMMARY
    ==================================================
    Customer Name: Muhammad Asynawi
    Property: Jonker Heritage Suite (Melaka)
    Duration: 3 nights (Base Rate: RM 250.00 / night)

    Subtotal base charges:             RM 750.00
    Peak Season Multiplier (+30%):     +RM 225.00
    Promo Code Applied (SAVE10 -10%):  -RM  97.50
    Malaysian Tourism Tax (RM10/night): +RM  30.00
    --------------------------------------------------
    TOTAL DUE (FPX Simulation):        RM 907.50
    ==================================================

2. Analytics & Reporting (ASCII Visual Chart)

The system prints visual ASCII graphs representing monthly revenue directly in the terminal interface for quick management summaries:

    MONTHLY REVENUE ANALYTICS (JANUARY)
    ==================================================
    Jonker Suite:  [████████████████████] RM 12,450.00
    Klebang Villa: [██████████████]       RM  8,900.00
    Stadthuys Apt: [████████]             RM  5,200.00
    --------------------------------------------------
    Total Monthly Profit: RM 18,340.50 (After Expenses)

System Architecture & Database Design

Homestay Database ERD
Entity Relationship Diagram (ERD)

Entity schema normalized to Third Normal Form (3NF). Establishes relational integrity constraints between Users, Properties, Bookings, Expenses, and Transaction tables.

Homestay System Flowchart
Main System Process Flowchart

Details database connection checks, authentication routing loops for super admin/admin/customers, and memory lifecycle cleanup upon system termination.

Application Interface Designs

Homestay System Landing Page
System Landing Page & Console Menu

The initial menu layout prompting users to log in, register a new account, or explore available homestays anonymously with custom input sanitization.

Homestay Admin Control Panel
Administrator Management Dashboard

Control dashboard showing administrative tasks: room bookings verification, user audit trails, system performance overview, and custom report query triggers.

Expense Management Ledger Screen
Expense Ledger Console Interface

Administrative screen demonstrating expense records: logging property upkeep, utility bills, tourism taxation deposits, and mapping costs to specific rooms.

What I Learned

  • Console Software Engineering: Deepened skills in modular C++ coding, data validation, pointers, arrays, and robust keyboard error exception traps.
  • Database Schema & ERD Design: Learned to structure entity-relationship diagrams (ERD) and normalize database columns to 3rd Normal Form (3NF) to eliminate anomalies.
  • Business Logic Enforcements: Implemented regulatory and commercial rules programmatically (e.g. tourism tax calculations, refund policies based on cancellation dates).
  • Data Export Pipelines: Programmed file output functions to generate structured spreadsheet-compatible CSV summaries for external accounting tasks.
← Back to Portfolio