Cyber Cafe Management System DBMS Project

The Cyber Cafe Management System is a database management system project that enables the management of customers, computers, and transactions in a cyber cafe. Here are the complete details of the project:

Overview

The Cyber Cafe Management System is a web-based application designed to automate the processes involved in a cyber cafe. The system allows customers to browse the internet using the available computers and pay for the usage online. The system also enables the employees to manage the customers, computers, and transactions efficiently.

Features

The Cyber Cafe Management System has the following features:

Customer Management

  • Customer Registration: Customers can register themselves on the system by providing their details like name, email address, phone number, and password.
  • Customer Login: Registered customers can log in to the system using their email address and password.
  • View Profile: Customers can view their profile details and edit them if necessary.
  • Account Balance: Customers can view their account balance and recharge their account by making payments online.

Computer Management

  • Computer Inventory: Employees can manage the inventory of computers by adding new computers, updating the details of existing computers, and deleting computers from the system.
  • Computer Availability: Employees can view the availability of computers and assign them to customers.
  • Computer Usage Time: The system records the usage time of each computer and calculates the amount to be charged from the customer.

Transaction Management

  • Payment Management: The system allows customers to pay for the usage of computers online. It also records the payment details and updates the customer’s account balance accordingly.
  • Transaction History: Customers and employees can view the transaction history of each customer.

Employee Management

  • Employee Registration: Employees can register themselves on the system by providing their details like name, email address, phone number, and password.
  • Employee Login: Registered employees can log in to the system using their email address and password.
  • View Profile: Employees can view their profile details and edit them if necessary.

Database Design

The database of the Cyber Cafe Management System consists of the following tables:

Customers Table

  • Customer ID (Primary Key)
  • Name
  • Email Address
  • Phone Number
  • Password
  • Account Balance

Computers Table

  • Computer ID (Primary Key)
  • Computer Name
  • Computer Type
  • Availability Status
  • Usage Time
  • Last Usage Date

Transactions Table

  • Transaction ID (Primary Key)
  • Customer ID (Foreign Key)
  • Computer ID (Foreign Key)
  • Usage Time
  • Amount Charged
  • Payment Date
  • Payment Method

Employees Table

  • Employee ID (Primary Key)
  • Name
  • Email Address
  • Phone Number
  • Password

Technologies Used

The Cyber Cafe Management System is developed using the following technologies:

  • Programming Language: PHP
  • Database Management System: MySQL
  • Web Technologies: HTML, CSS, JavaScript

Conclusion

The Cyber Cafe Management System is an efficient way of managing the customers, computers, and transactions in a cyber cafe. It automates the manual processes involved in a cyber cafe and makes the operations more streamlined and organized.

Leave a Comment