Skip to content

dbms project for college purpose. For 5th sem Engineering

Notifications You must be signed in to change notification settings

akashb2003/dbms-project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Apartment Management System

Contents

  • Project Description
  • Basic Structure
  • Functionalities
  • Tech Stack

Project Description

In this project we created a Apartment management system with user interface and database support.This project is a part of our curriculum, here we solved the problem of manual entry of data in apartments by creating user interface and storing data in mysql database.

How to Run

  • Install the dependencies first
  • First run the client server
cd client
npm start
  • Then run the backend server
cd server
npm start

Basic Structure

Functionalities

  • Admin

    • Admin can login.
    • Admin can view the tenant and owner details.
    • Admin can create owner.
    • Admin can allot parking slot.
    • Admin can view the complaints.
    • Admin can see total Owners.
    • Admin can see total Tenants.
    • Admin can see total Employee.
  • Owner

    • Owner can see the Tenant details of his/her owned room.
    • Owner can create Tenant.
    • Owner can see the complaints from his/her owned room.
    • Owner can see the Room Details.
    • Owner can see Total Complaint.
    • Owner can see Number of Employee.
  • Tenant

    • Tenant can see the alloted parking slot.
    • Tenant can pay maintenance fee.
    • Tenant can raise complaints.
    • Tenant can see his/her Tenant id.
    • Tenant can see his/her Name.
    • Tenant can see his/her Age.
    • Tenant can see his/her DOB.
    • Tenant can see his/her Room no.
  • Employee

    • Employee can see all the complaints.
    • Employee can see Total number of Complaints
  • All the admins, owners, tenant, employees can login and logout.

Tech Stack

  • Frontend - HTML5, Tailwind css, React JS
  • Backend - NodeJS, ExpressJS
  • Database - MySql

Login Credentials

image

Screenshots

tenant schema owner login er-diagram employee admin

Thank you!🧑‍💻

About

dbms project for college purpose. For 5th sem Engineering

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published