Building Smart Home Management System

COS20031 - Database Design Project

A comprehensive web-based Building Management System designed for monitoring and controlling building infrastructure, including rooms, devices, sensors, and automated scheduling. Built as a full-stack application with a modern React frontend and Node.js backend.

---

📋 Project Overview

This is a Swinburne University Database Design course project that implements a Building Management System. The system provides real-time monitoring of room conditions (temperature & humidity), device management, automated scheduling, maintenance tracking, and room booking capabilities.

Key Features

• Real-Time Monitoring: Track temperature and humidity across multiple rooms with live sensor data
• Device Management: View and control active/inactive devices with state management
• Automated Scheduling: Schedule device operations with cron-based automation
• Notifications & Alerts: Receive real-time notifications and alerts for system events
• System Logs: Comprehensive logging of all system activities for audit trails
• Room Bookings: Manage and view room availability and bookings
• Worker Management: Track maintenance workers and assignments
• User Authentication: Secure login system with role-based access control
• Historical Data: Access sensor historical data and trends with visualization

---

🛠️ Technology Stack

Frontend

• React 19 - UI library
• Vite - Fast build tool and dev server
• TailwindCSS - Utility-first CSS framework
• Material-UI - Pre-built UI components
• Recharts - Data visualization library
• React Router - Client-side routing
• Supabase JS Client - Backend integration

Backend

• Node.js - Runtime environment
• Express 5.x - Web framework
• Supabase - Backend-as-a-Service (Database, Authentication)
• Node-cron - Job scheduling
• CORS - Cross-origin resource sharing

Database

• PostgreSQL - Relational database (via Supabase)
• Sensor readings and device state management
• User and worker information
• System logs and notifications

---

📁 Project Structure

Smart-Home-Management-System/
├── Backend/                          # Node.js Express API server
│   ├── index.js                      # Main server entry point
│   ├── package.json                  # Backend dependencies
│   └── functions/
│       ├── get/                      # GET endpoints for data retrieval
│       │   ├── getAllDevices.js
│       │   ├── getAllSensors.js
│       │   ├── getCurrentData.js     # Real-time sensor data
│       │   ├── getSchedules.js
│       │   ├── getNotifications.js
│       │   ├── getSystemLogs.js
│       │   ├── getMaintenance.js
│       │   └── ... (other get functions)
│       ├── insert/                   # POST endpoints for data creation
│       │   ├── insertSchedule.js
│       │   └── insertBooking.js
│       ├── update/                   # PUT endpoints for data updates
│       │   ├── updateDeviceState.js
│       │   └── updateSchedules.js
│       └── delete/                   # DELETE endpoints
│           └── deleteSchedule.js
├── Frontend/                         # React Vite application
│   ├── index.html                    # Main HTML template
│   ├── indexlogin.html               # Login page
│   ├── package.json                  # Frontend dependencies
│   ├── vite.config.js                # Vite configuration
│   ├── tailwind.config.js            # TailwindCSS configuration
│   └── src/
│       ├── main/
│       │   ├── App.jsx               # Main app component with routing
│       │   ├── main.jsx              # Entry point
│       │   └── index.css             # Global styles
│       ├── pages/                    # Page components
│       │   ├── DashboardPage.jsx     # Main dashboard
│       │   ├── Logs.jsx              # System logs viewer
│       │   ├── Notifications.jsx     # Notifications page
│       │   ├── Login.jsx             # Login page
│       │   ├── RoomComponents/       # Room-related pages
│       │   │   ├── SystemOverview.jsx
│       │   │   ├── RoomDetails.jsx
│       │   │   └── SensorHistorical.jsx
│       │   └── BookingComponents/    # Booking-related pages
│       │       ├── Booking.jsx
│       │       └── MakeBooking.jsx
│       ├── components/               # Reusable components
│       │   ├── Header.jsx
│       │   ├── Sidebar.jsx
│       │   ├── Layout.jsx
│       │   └── ProtectedRoute.jsx
│       ├── hooks/                    # Custom React hooks
│       │   ├── getApiData.jsx        # API data fetching
│       │   ├── getDetailData.jsx
│       │   └── useTheme.jsx
│       └── assets/                   # Images and fonts
├── ScheduleJob.sql                   # PostgreSQL scheduled jobs
└── README.md                         # This file

---

🚀 Getting Started

Prerequisites

• Node.js (v16 or higher)
• npm or yarn
• Supabase account and project credentials
• Environment variables configured

Installation

1. Clone the Repository

git clone <repository-url>
cd Smart-Home-Management-System

2. Backend Setup

Navigate to the backend directory and install dependencies:

cd Backend
npm install

Create a .env file in the Backend directory with your Supabase credentials:

PORT=8000
SUPABASE_URL=your_supabase_url
SUPABASE_KEY=your_supabase_key

Start the backend server:

# Development mode with auto-reload
npm run dev

# Production mode
npm start

The backend will run on http://localhost:8000

3. Frontend Setup

Navigate to the frontend directory and install dependencies:

cd Frontend
npm install 

Create a .env.local file in the Frontend directory:

VITE_SUPABASE_URL=your_supabase_url
VITE_SUPABASE_KEY=your_supabase_key
VITE_API_URL=http://localhost:8000

Start the development server:

npm run dev

The frontend will run on http://localhost:5173

---

📊 API Endpoints

Data Retrieval (GET)

• GET / - Welcome message
• GET /rooms-sensors - Get all rooms with their sensors
• GET /rooms-devices - Get all rooms with their devices
• GET /notifications - Get all notifications
• GET /alerts - Get all alerts
• GET /schedules - Get all device schedules
• GET /device/:deviceid - Get specific device details

Updates (PUT)

• PUT /devices/:id - Update device state
• PUT /schedules - Update device schedules
• PUT /schedules/manual/:id - Manually update specific schedule

Creation (POST)

• POST /schedules - Create new schedule
• POST /login - User login
• POST /booking - Create room booking

Deletion (DELETE)

• DELETE /schedules/:id - Delete schedule

---

🔄 Automated Processes

The backend includes a cron job that runs every minute to:

• Check and execute scheduled device operations
• Update device states based on schedules
• Monitor sensor readings
• Generate system alerts

---

👥 Team Members

Name	Role	Responsibilities
Do Gia Huy	Supporter	Database Designer, Full-stack Developer
Huynh Trung Chien	Leader	Database Designer, Full-stack Developer
Tran Nguyen Khai Nghi	Member	IoT Engineer
Le Pham Tu Quynh	Member	Technical Writer

---

📝 Database Schema

Key tables in the PostgreSQL database:

• users - User authentication and profiles
• device - Device information and states
• sensor - Sensor configurations per device
• sensorreading - Historical sensor data (temperature, humidity)
• temphumsensor - Temperature and humidity specific readings
• notification - System notifications and alerts
• schedule - Device operation schedules
• booking - Room booking records
• systemlog - Audit and system operation logs

---

🔐 Security Features

• User authentication with secure login
• Protected routes for authenticated users only
• CORS enabled for secure cross-origin requests
• Role-based access control
• Environment variables for sensitive credentials

---

📄 License

This project is part of COS20031 - Database Design at Swinburne University.

---