Introduction:
The Cyber Cafe Management System is
developed with a view of providing a better experience for customers
in modern cyber cafes. It resolves customers’ doubts and helps the
owner of the cyber cafe maintain a solid record of customers and
ensure the timely payment of bills. It also provides valuable feedback
about our cyber cafe. This project helps us understand the importance of
computers in our daily life, because without them there would be no cyber
cafes
Objectives of the product:
The objective of this
project is to let students apply programming knowledge to
real-world situations/ problems and expose the students to how
programming skills help in developing good software.
1. Write programs utilizing modern software tools.
2. Apply object-oriented programming principles effectively when
developing small to medium sized projects.
3. Write effective procedural code to solve small to medium sized
problems.
4. Demonstrate a breadth of knowledge in computer science,
exemplified in the areas of systems, theory, and software
development.
5. Demonstrate the ability to conduct a research or applied computer
science project, requiring writing and presentation skills that
exemplify scholarly style in computer science.
Importance of the product:
- Saves Time: Automates tasks, reduces manual work
- Increases Efficiency: Manages users, billing, and resources
smoothly
- Grows Business: Tracks usage, optimizes resources, and
increases revenue
- Improves Customer Experience: Offers self-service options,
support
Hardware and Software requirements:
[Link] SYSTEM: WINDOWS 7 AND ABOVE
II. PROCESSOR: PENTIUM(ANY) OR AMD
ATHALON(3800+- 4200+ DUAL CORE)
III. MOTHERBOARD: 1.845 OR 915,995 FOR PENTIUM 0R MSI
K9MM-V VIA K8M800+8237R PLUS
CHIPSET FOR AMD ATHALON
IV. RAM: 512MB+
V. Hard disk: SATA 40 GB OR ABOVE
VIII. MONITOR 14.1 or 15 -17 inch
IX. Key board and mouse: (if print is required – [Hard copy])
X. Printer
xi. Software: I. Windows OS
II. Python
III. Mysql
IV. Mysql python connector
Database name: ccms(Cyber Cafe Management System)
CODE:-
CREATE DATABASE ccms;
USE ccms;
CREATE TABLE Add_new_customer ( Customer_name VARCHAR(20), Age INT,
Address VARCHAR(100), Phone_no VARCHAR(10), Email_ID VARCHAR(30) );
CREATE TABLE Time_charges ( Time VARCHAR(30), Amount_charged INT );
CREATE TABLE Bill ( Customer_name VARCHAR(20), Time_accessed_in_min
INT, Total_charges INT );
TABLE: Add_new_customer :-
TABLE: Time_charges :-
TABLE: Bill :-
import [Link] as sql
conn = [Link](
host="localhost",
user="root",
password="",
database="ccms")
if conn.is_connected():
print("Database connected successfully")
cursor = [Link]()
def line():
print("--------------------------------------------
------")
def welcome():
line()
print(" AMRAVIAN CYBER CAFE MANAGEMENT
SYSTEM")
print(" WELCOMES YOU")
line()
def add_customer():
line()
print("ADD NEW CUSTOMER")
line()
name = input("Enter customer name : ")
age = int(input("Enter age : "))
address = input("Enter address : ")
phone = input("Enter phone number : ")
email = input("Enter email id : ")
query = "INSERT INTO Add_new_customer VALUES
('{}',{},'{}','{}','{}')".format(
name, age, address, phone, email)
[Link](query)
[Link]()
print("Customer details added successfully")
def add_time_charge():
line()
print("ADD TIME CHARGES")
line()
minutes = int(input("Enter minutes used : "))
amount = int(input("Enter amount charged : "))
query = "INSERT INTO Time_charges VALUES
({},{})".format(minutes, amount)
[Link](query)
[Link]()
print("Time charges added successfully")
def generate_bill():
line()
print("GENERATE BILL")
line()
name = input("Enter customer name : ")
minutes = int(input("Enter time used (minutes) :
"))
rate_per_minute = 30
total_amount = minutes * rate_per_minute
query = "INSERT INTO Bill VALUES
('{}',{},{})".format(
name, minutes, total_amount)
[Link](query)
[Link]()
print("Total amount to be paid : Rs.",
total_amount)
payment = input("Type YES to confirm payment : ")
if [Link]() == "YES":
print("Payment successful")
else:
print("Payment pending")
def view_customer():
line()
print("VIEW CUSTOMER DETAILS")
line()
phone = input("Enter phone number to search : ")
query = "SELECT * FROM Add_new_customer WHERE
Phone_no='{}'".format(phone)
[Link](query)
data = [Link]()
if data == []:
print("No customer record found")
else:
for row in data:
print("Name :", row[0])
print("Age :", row[1])
print("Address :", row[2])
print("Phone :", row[3])
print("Email :", row[4])
def show_menu():
line()
print("MAIN MENU")
line()
print("1. Add Customer Details")
print("2. Add Time Charges")
print("3. Generate Bill")
print("4. View Customer Details")
print("5. Exit")
line()
welcome()
while True:
show_menu()
choice = int(input("Enter your choice : "))
if choice == 1:
add_customer()
elif choice == 2:
add_time_charge()
elif choice == 3:
generate_bill()
elif choice == 4:
view_customer()
elif choice == 5:
print("THANK YOU VISIT AGAIN")
else:
print("Invalid choice, please try again")
again = input("\nDo you want to continue? (YES/NO)
: ")
if [Link]() != "YES":
print("Program terminated")
break
OUTPUT: -
Step1: Creation of a database in my sql so that we can store data
in [Link] name of the database is CCMS(Cyber Café Management
System).
Step2: Importing and Connecting the database to python using
mysql connector.
Step3: Creating a cursor object so that we can give commands to
mysql database.
Step4: Displaying welcome message
A welcome message” ******* BHILAI CYBER CAFE WELCOMES YOU
********”is shown
Step5: Taking customer details and inputs
Step7: Inserting customer data in databse
Step8: Billing logic
Takes time used in minutes and Calculates total bill using:
Total Charges = Time Used × Rate per Minute
Step9: Storing bill details
Step10:Bill payment confirmation
A confirmation is given to the customer if the bill is paid successfully and if
there is a problem in transaction it is told to the customer
Step11:Displaying customer details from the database
Step12:End of the program and thank you message
The program is ended and a ”THANK YOU VISIT AGAIN” message is shown.
Bibiliography: -
Computer science with
Python,Class 12,By Sumita Arora
Youtube
Google