Unique Study Point

PROJECT REPORT

OF
PROJECT CODE - 507

BACHELOR OF COMPUTER APPLICATION

SUBMITTED BY GUIDEDE BY

Sanovar Choudhary Tajender singh

Roll No. 210995106042

DEPARTMENT OF COMPUTER APPLICATIONS,

MODERN COLLEGE OF PROFESSIONAL STUDIES

MOHAN NAGAR, GHAZIABAD
(Affiliated to CCSU Meerut)
 Acknowledgement

Project work is never the work of an individual. It is more a combination of

views and ideas, suggestions and contribution and work. This project also
bears the imprint of many people. Thus one of the most pleasant parts of
writing this project is the opportunity to thank those who have contributed
towards it.

Nothing concrete can be achieved without an optional combination of

inspiration and perspiration. No work can be accomplished without taking the
guidance of the experts. It is only the views and advice from ingenious
intellectual that help in the transformation of a product into a quality product.

I gratefully thanks to ………………………………………… (Project Guide)who

has given me the opportunity to learn at deep level to prepare this project.

Last but not the least, no acknowledgement will be complete without mentioning our
parents.
They have also supported us throughout the development of this project

Sanovar Choudhary
 Abstract
This project is aimed unique study point for consumers. customer are our
consumers. The system is an online application that can be accessed
throughout the organization and outside as well with proper login provided.

The project has been planned to be having the view of distributed

architecture, with centralized storage of the database. The application for
the storage of the data has been planned. Using the constructs of MySQL
and all the user interfaces have been designed using the Python.

The database connectivity is planned using the “Database” methodology. The

standards of security and data protective mechanism have been given a big
choice for proper usage. The application takes care of different modules and
their associated reports, which are produced as per the applicable strategies
and standards that are put forwarded by the administrative staff.

Introduction
Purpose

The purpose of Unique study Point is to automate the existing manual system by the
help of computerized equipment and full-fledged computer software, fulfilling their
 requirement, so that their valuable data/information can be stored for a longer period
with easy accessing and manipulation of the same. The required software and
hardware are easily available and easy to work with. The aim is to automobiles its
existing manual system by the help of computerized equipment and full-fledged
computer software, fulfilling their requirement, so that their valuable
data/information can be stored for a longer period with easy accessing and
manipulation of the same. Basically the project describes how to manage for good
performance and better services for the clients.

Intended Audience and Reading Suggestions

This Software Requirements document is intended for non-commercial, college project under
faculties supervision, further it can be deployed as live on its success.

• ADMIN (may be the client)

• Customers

• Product Suppliers/Distributors

• Retailers

• Testers can use this document as a base for their testing strategy.

Project Scope

At present days every organization is using web technology for their proper
functioning, so this web based project is all in all important from market aspects.
Further if this project will be uploaded, it can be used as medical site and any person
can register their self on the site to access different type of items related to
medicines.

Advantages of the project are:

• Easy access to the data

• The new system is more users friendly, reliable and flexible.

 • Pop-up menus to carry out transactions for a new user, and for other alert messages.

• Timely Report generation.

........................................................................................................................................................................

Definition, Acronyms, and Abbreviations

1. HTTPS Hyper Text Transfer Protocol
2. HTML- Hyper Text Markup Language
3. CSS- Cascading Style Sheets
4. MongoDB- Database used to store all the data of user, their feedback, and items
purchased etc.

5.Python-Hypertext Preprocessor File

6. Application Tool- Wamp 3.0

Front-end Coverage

We would be using the following technologies to design our front-end:

HTML
HTML stands for Hypertext Markup Language, and it is the most widely
used language to write Web Pages.

Hypertext refers to the way in which Web pages (HTML documents) are linked
together. Thus, the link available on a webpage is called Hypertext.

As its name suggests, HTML is a Markup Language which

means you use HTML to simply "mark-up" a text document with tags
that tell a Web browser how to structure it to display.

Originally, HTML was developed with the intent of defining the

structure of documents like headings, paragraphs, lists, and so forth to
facilitate the sharing of scientific information between researchers.
 Now, HTML is being widely used to format web pages with the help of different
tags available in HTML language.

CSS
Cascading Style Sheets, fondly referred to as CSS, is a simple design language
intended to simplify the process of making web pages presentable.

CSS handles the look and feel part of a web page. Using CSS,
you can control the color of the text, the style of fonts, the spacing
between paragraphs, how columns are sized and laid out, what
background images or colors are used, layout designs, variations in
display for different devices and screen sizes as well as a variety of other
effects.

CSS is easy to learn and understand but it provides powerful

control over the presentation of an HTML document. Most commonly,
CSS is combined with the markup languages HTML or XHTML.

JavaScript
JavaScript is a dynamic computer programming language. It is
lightweight and most commonly used as a part of web pages, whose
implementations allow client-side script to interact with the user and
make dynamic pages. It is an interpreted programming language with
object-oriented capabilities.

JavaScript was first known as LiveScript, but Netscape changed

its name to JavaScript, possibly because of the excitement being
generated by Java. JavaScript made its first appearance in Netscape 2.0
in 1995 with the name LiveScript. The general-purpose core of the
 language has been embedded in Netscape, Internet Explorer, and other
web browsers.

The ECMA-262 Specification defined a standard version of the core JavaScript

language.

• JavaScript is a lightweight, interpreted programming language.

• Designed for creating network-centric applications.
• Complementary to and integrated with Java.
• Complementary to and integrated with HTML.
• Open and cross-platform

Back-end Coverage

SQL LITES
Structured Query Language (SQL) is a specialized programming language for managing relational database data. It
allows users to store, manipulate, and retrieve data efficiently in databases like MySQL, SQL Server, Oracle, and more.

In this article, we will learn about what is SQL? and check its characteristics, rules, uses, commands, etc.

SQL stands for Structured Query Language. SQL is a computer language used to interact with relational database
systems. SQL is a tool for organizing, managing, and retrieving archived data from a computer database.

When data needs to be retrieved from a database, SQL is used to make the request. The DBMS processes the SQL query
retrieves the requested data and returns it to us. Rather, SQL statements describe how a collection of data should be
organized or what data should be extracted or added to the database.

Components of a SQL System

Some of the Key components of a SQL System are:

Databases

Databases are structured collections of data organized into tables, rows, and columns. They serve as repositories for
storing information efficiently and provide a way to manage and access data.

Tables
Tables are the fundamental building blocks of a database, consisting of rows (records) and columns (attributes or
fields). They ensure data integrity and consistency by defining the structure and relationships of the stored information.

Queries

Queries are SQL commands used to interact with databases. They enable users to retrieve, update, insert, or delete
data from tables, allowing for efficient data manipulation and retrieval.

Constraints

Constraints are rules applied to tables to maintain data integrity. They define conditions that data must meet to be
stored in the database, ensuring accuracy and consistency.

Stored Procedures

Stored procedures are pre-compiled SQL statements stored in the database. They can accept parameters, execute
complex operations, and return results, enhancing efficiency, reusability, and security in database management.

Transactions

Transactions are groups of SQL statements that are executed as a single unit of work. They ensure data consistency and
integrity by allowing for the rollback of changes if any part of the transaction fails.

Some other important components include:

 Data Types

 Indexes

 Views

 Security and Permissions

 Joins

Characteristics of SQL
 SQL may be utilized by quite a number of users, which include people with very little programming experience.

 SQL is a non-procedural language.

 We can without difficulty create and replace databases in SQL. It isn’t a time-consuming process.

 SQL is primarily based totally on ANSI standards.

 SQL does now no longer have a continuation individual.

 SQL is entered into the SQL buffer on one or more lines.

 SQL makes use of a termination individual to execute instructions immediately. It makes use of features to
carry out a few formatting.

 It uses functions to perform some formatting.

 How SQL Works?
A server machine is used in the implementation of the structured query language (SQL), processing database
queries and returning results. The following are some of the software elements that the SQL process goes
through.

Parser
The parser begins by replacing some of the words in the SQL statement with unique symbols, a process known
as tokenization. The statement is then examined for the following:

Correctness
The parser checks to see if the SQL statement complies with the rules, or SQL semantics, that guarantee the
query statement’s accuracy. The parser, for instance, looks to see if the SQL command ends with a semicolon.
The parser returns an error if the semi-colon is absent.

Authorization
The parser additionally confirms that the user executing the query has the required permissions to alter the
relevant data.

Relational Engine
The relational engine, also known as the query processor, develops a strategy for efficiently retrieving, writing,
or updating relevant data. For instance, it looks for queries that are similar to others, uses earlier data
manipulation techniques, or develops a new one. Byte code, an intermediate-level representation of the SQL
statement, is used to write the plan. To efficiently perform database searches and modifications, relational
databases use byte code.

Storage Engine
The software element that interprets the byte code and executes the intended SQL statement is known as the
storage engine, also known as the database engine. The data in the database files on the physical disc storage is
read and stored. The storage engine delivers the outcome to the requesting application after completion.

SQL Rules
The rules for writing SQL queries are given below:

 A ‘;’ is used to end SQL statements.

 Statements may be split across lines, but keywords may not.

 Identifiers, operator names, and literals are separated by one or more spaces or other delimiters.

 A comma (,) separates parameters without a clause.

 A space separates a clause.

 Reserved words cannot be used as identifiers unless enclosed with double quotes.
 Identifiers can contain up to 30 characters.

 Identifiers must start with an alphabetic character.

 Characters and date literals must be enclosed within single quotes.

 Numeric literals can be represented by simple values.

 Comments may be enclosed between /* and */ symbols and maybe multi-line.

What are SQL commands?

Developers use structured query language (SQL) commands, which are specific keywords or SQL statements, to
work with data stored in relational databases. The following are categories for SQL commands.

1. Data Definition Language

SQL commands used to create the database structure are known as data definition language (DDL). Based on
the needs of the business, database engineers create and modify database objects using DDL. The CREATE
command, for instance, is used by the database engineer to create database objects like tables, views, and
indexes.

Comman
d Description

CREATE Creates a new table, a view of a table, or other object in the database.

ALTER Modifies an existing database object, such as a table

DROP Deletes an entire table, a view of a table, or other objects in the database

2. Data Manipulation Language

A relational database can be updated with new data using data manipulation language (DML) statements. The
INSERT command, for instance, is used by an application to add a new record to the database.

Command Description

SELECT Retrieves certain records from one or more tables.

INSERT Creates a record.

 Command Description

UPDATE Modifies records.

DELETE Deletes records.

3. Data Query Language

Data retrieval instructions are written in the data query language (DQL), which is used to access relational
databases. The SELECT command is used by software programs to filter and return particular results from a SQL
table.

4. Data Control language

Data control language (DCL) is a programming language used by database administrators to control or grant
other users access to databases. For instance, they can allow specific applications to manipulate one or more
tables by using the GRANT command.

Command Description

GRANT Gives a privilege to the user.

REVOKE Takes back privileges granted by the user.

5. Transaction Control Language

To automatically update databases, the relational engine uses transaction control language (TCL). For instance,
the database can reverse a mistaken transaction using the ROLLBACK command.

Uses of SQL
SQL is used for interacting with databases. These interactions include:

1. Data definition: It is used to define the structure and organization of the stored data and the relationships
among the stored data items.

2. Data retrieval: SQL can also be used for data retrieval.

3. Data manipulation: If the user wants to add new data, remove data, or modifying in existing data then SQL
provides this facility also.
4. Access control: SQL can be used to restrict a user’s ability to retrieve, add, and modify data, protecting stored
data against unauthorized access.

5. Data sharing: SQL is used to coordinate data sharing by concurrent users, ensuring that changes made by one
user do not inadvertently wipe out changes made at nearly the same time by another user.

SQL also differs from other computer languages because it describes what the user wants the computer to do
rather than how the computer should do it. (In more technical terms, SQL is a declarative or descriptive
language rather than a procedural one.)

SQL contains no IF statement for testing conditions, and no GOTO, DO, or FOR statements for program flow
control. Rather, SQL statements describe how a collection of data is to be organized, or what data is to be
retrieved or added to the database. The sequence of steps to do those tasks is left for the DBMS to determine.

Why SQL?
 SQL is an interactive question language. Users type SQL instructions into an interactive SQL software to retrieve
facts and show them on the screen, presenting a convenient, easy-to-use device for ad hoc database queries.

 SQL is a database programming language. Programmers embed SQL instructions into their utility packages to
access the facts in a database. Both user-written packages and database software packages (consisting of
document writers and facts access tools) use this approach for database access.

 SQL is a client/server language. Personal computer programs use SQL to communicate over a network with
database servers that save shared facts. This client/server architecture is utilized by many famous enterprise-
class applications.

 SQL is Internet facts access language. Internet net servers that interact with company facts and Internet utility
servers all use SQL as a widespread language for getting access to company databases, frequently through
embedding SQL databases get entry to inside famous scripting languages like PHP or Perl.

 SQL is a distributed database language. Distributed database control structures use SQL to assist distribute
facts throughout many linked pc structures. The DBMS software program on every gadget makes use of SQL to
speak with the opposite structures, sending requests for facts to get entry to.

 SQL is a database gateway language. In a pc community with a mixture of various DBMS products, SQL is
frequently utilized in a gateway that lets one logo of DBMS speak with every other logo. SQL has for this reason
emerged as a useful, effective device for linking people, pc packages, and pc structures to the facts saved in a
relational database.

SQL Injection
A cyberattack known as SQL injection involves tricking the database with SQL queries. To retrieve, alter, or
corrupt data in a SQL database, hackers use SQL injection. To execute a SQL injection attack, for instance, they
might enter a SQL query in place of a person’s name in a submission form.
What is SQL Server?
Microsoft’s relational database management system, which uses SQL to manipulate data, is formally
known as SQL Server. There are various editions of the MS SQL Server, and each is tailored for
particular workloads and requirements.
Finally, SQL is not a particularly structured language, especially when compared with highly
structured languages such as C, Pascal, or Java. Instead, SQL statements resemble English
sentences, complete with “noise words” that don’t add to the meaning of the statement but make it
read more naturally. SQL has quite a few inconsistencies and also some special rules to prevent
you from constructing SQL statements that look perfectly legal but that don’t make sense.
Despite the inaccuracy of its name, SQL has emerged as the standard language for using relational
databases. SQL is both a powerful language and one that is relatively easy to learn. So, SQL is a
database management language. The database administrator is answerable for handling a
minicomputer or mainframe database and makes use of SQL to outline the database shape and
manipulate get entry to the saved data.

Conclusion:
SQL(Structured Query Language) is a programming language designed for managing and
manipulating data stored in relational databases. It is used for interacting with DBMS like MySQL,
SQL Server, Oracle, and PostgreSQL.
In this article we have covered about SQL and understood it’s characteristics, rules to write SQL
queries, commands, uses and many important concepts. We also covered the SQL injection and
how it can be harmful for database security. After completing this guide, you will be equipped with
all necessary information about SQL.

PHP
Hypertext Preprocessor (or simply PHP) is a server-side scripting language designed for web
development but also used as a general-purpose programming language.
It was originally created by Rasmus Lerdorf in 1994.
The PHP reference implementation is now
produced by The PHP Group. PHP originally stood for Personal Home
Page, but it now stands for the recursive acronym PHP: Hypertext
Preprocessor.
PHP code may be embedded into HTML code, or it can be used in
combination with various web template systems, web content
management systems, and web frameworks. PHP code is usually
processed by a PHP interpreter implemented as a module in the web
server or as a Common Gateway Interface (CGI) executable.
 The web server combines the results of the interpreted and executed PHP
code, which may be any type of data, including images, with the
generated web page. PHP code may also be executed with a command-
line interface (CLI) and can be used to implement standalone graphical
applications.

Django
In this first Django article, we answer the question "What is Django?" and give you an overview of what makes this web
framework special.

We'll outline the main features, including some of the advanced functionality that we won't have time to cover in detail
in this module. We'll also show you some of the main building blocks of a Django application (although at this point you
won't yet have a development environment in which to test it).

Prerequisit A general understanding of server-side website programming, and in

es: particular the mechanics of client-server interactions in websites.

To gain familiarity with what Django is, what functionality it provides, and
Objective:
the main building blocks of a Django application.

What is Django?

Django is a high-level Python web framework that enables rapid development of

secure and maintainable websites. Built by experienced developers, Django takes care
of much of the hassle of web development, so you can focus on writing your app
without needing to reinvent the wheel. It is free and open source, has a thriving and
active community, great documentation, and many options for free and paid-for
support.

Django helps you w Django helps you write software that is:

Complete

Django follows the "Batteries included" philosophy and provides almost everything
developers might want to do "out of the box". Because everything you need is part of
the one "product", it all works seamlessly together, follows consistent design principles,
and has extensive and up-to-date documentation.

Versatile

Django can be (and has been) used to build almost any type of website — from content
management systems and wikis, through to social networks and news sites. It can work
with any client-side framework, and can deliver content in almost any format (including
HTML, RSS feeds, JSON, and XML).

Internally, while it provides choices for almost any functionality you might want (e.g.
several popular databases, templating engines, etc.), it can also be extended to use
other components if needed.

Secure

Django helps developers avoid many common security mistakes by providing a

framework that has been engineered to "do the right things" to protect the website
automatically. For example, Django provides a secure way to manage user accounts
and passwords, avoiding common mistakes like putting session information in cookies
where it is vulnerable (instead cookies just contain a key, and the actual data is stored
in the database) or directly storing passwords rather than a password hash.

A password hash is a fixed-length value created by sending the password through a

cryptographic hash function. Django can check if an entered password is correct by
running it through the hash function and comparing the output to the stored hash value.
However due to the "one-way" nature of the function, even if a stored hash value is
compromised it is hard for an attacker to work out the original password.

Django enables protection against many vulnerabilities by default, including SQL

injection, cross-site scripting, cross-site request forgery and clickjacking (see Website
security for more details of such attacks).

Scalable
Django uses a component-based "shared-nothing" architecture (each part of the
architecture is independent of the others, and can hence be replaced or changed if
needed). Having a clear separation between the different parts means that it can scale
for increased traffic by adding hardware at any level: caching servers, database servers,
or application servers. Some of the busiest sites have successfully scaled Django to
meet their demands (e.g. Instagram and Disqus, to name just two).

Maintainable

Django code is written using design principles and patterns that encourage the creation
of maintainable and reusable code. In particular, it makes use of the Don't Repeat
Yourself (DRY) principle so there is no unnecessary duplication, reducing the amount of
code. Django also promotes the grouping of related functionality into reusable
"applications" and, at a lower level, groups related code into modules (along the lines of
the Model View Controller (MVC) pattern).

Portable

Django is written in Python, which runs on many platforms. That means that you are not
tied to any particular server platform, and can run your applications on many flavors of
Linux, Windows, and macOS. Furthermore, Django is well-supported by many web
hosting providers, who often provide specific infrastructure and documentation for
hosting Django sites.rite software that is:

Where did it come from?

Django was initially developed between 2003 and 2005 by a web team who were
responsible for creating and maintaining newspaper websites. After creating a number
of sites, the team began to factor out and reuse lots of common code and design
patterns. This common code evolved into a generic web development framework, which
was open-sourced as the "Django" project in July 2005.

Django has continued to grow and improve, from its first milestone release (1.0) in
September 2008 through to the version 5.0 in late 2023. Each release has added new
functionality and bug fixes, ranging from support for new types of databases, template
engines, and caching, through to the addition of "generic" view functions and classes
(which reduce the amount of code that developers have to write for a number of
programming tasks).
Django is now a thriving, collaborative open source project, with many thousands of users and contributors.
While it does still have some features that reflect its origin, Django has evolved into a versatile framework that
is capable of developing any type of website.

How popular is Django?

There isn't any readily-available and definitive measurement of popularity of server-side frameworks (although
you can estimate popularity using mechanisms like counting the number of GitHub projects and
StackOverflow questions for each platform). A better question is whether Django is "popular enough" to avoid
the problems of unpopular platforms. Is it continuing to evolve? Can you get help if you need it? Is there an
opportunity for you to get paid work if you learn Django?

Based on the number of high profile sites that use Django, the number of people contributing to the codebase,
and the number of people providing both free and paid for support, then yes, Django is a popular framework!

High-profile sites that use Django include: Disqus, Instagram, Knight Foundation, MacArthur Foundation,
Mozilla, National Geographic, Open Knowledge Foundation, Pinterest, and Open Stack (source: Django
overview page).

Modules

Node has many built-in modules to aid in interactions with the command line, the
computer file system, and the Internet. These include
 HTTP and HTTPS for creating web servers.

 File System, OS, and Path for interacting with the file system, operating system,
and file/directory paths.
You can view the full docs to see more of Node’s built-in features.

Per the Node.js homepage, Node “uses an event-driven, non-blocking I/O model.” In
practice, this means that Node is built well to handle asynchronous JavaScript code to
perform many asynchronous activities such as reading and writing to the file system,
handling connections to database servers, or handling requests as a web server.

To handle asynchronous code, Node uses a callback-based system. Node functions and
methods that will implement some asynchronous activity take a callback function.
This callback will be called whenever the asynchronous operation has resolved. By
convention, the first argument of this callback is an error placeholder. If an error
occurred in the asynchronous operation occurred (trying to read a non-existent file, for
example), the error argument will be an Error object, but it will be null if no error
occurs.
Overall Description

Product Perspective

An online Medical, which is based on web technology. We can say that “Time is
Money” in the presents scenario. Internet acts as the backbone as a quick response
results. Many people in the world using Internet to meet their needs. Many
cooperative societies and organizations are in contact with their customers through
Internet only. Things which are done manually take a lot of time. To overcome these
situations, the concept of Online Medical is developed. It describes the modular
structure of Online Medical application and provides an in-depth of several pieces of
module. The modules in the Online Medical are:

 Admin module
After login, admin have administrative privilege. He can delete, update item check
transaction within time and manage business.

 User module
User has a lot of function in this module. In this module user can: -

 Search items
 View items’ description
 See if the stock is available or not
 Checkout the products

Product Features

Functional Requirements

a) The system must be able to register a new user.

 b) Confirmation message will pop to the new user when signing up will be successful.

c) Database having information regarding users can be accessed only by admin for
security purpose.

d) The system will provide adding items to the cart for the registered user.
e) The system should offer a feedback section for the registered user for any query or
enhancement suggestion.

f) The system must be able to process orders including payment handling when the
customer places an order.

Non Functional Requirements

a) Secure access of confidential data (user’s details).

b) 24x7 availability.
c) Better component design to get better performance at peak time.
d) Flexible service based architecture will be highly desirable for future extension.

User Classes and Characteristics

The users can be:

• Administrator • Users (Common People) Characteristics:

• Manager should have knowledge of internet & browsing.

• Customers can be members or visitors who are accessing this system.

• User should be literate enough to use the computer and place orders.

Operating Environment

The operating environment means need of platform where the project run.
 The requirement for running of the project: -

1. It will run all the operating system like-Window, Linux etc. 2. It will
Support Almost All Web Browser like Chrome, Safari, Firefox, etc.

We need lowest configuration at which project is able to run.

Hardware and Software Requirements

Minimum Server Side Requirements

Software

Technology Python

Web Technologies HTML, CSS, SQL, Django

JavaScript

Web Server Wamp 3.0

Database SQL
 Hardware

Processor 1.0 GHz or above

RAM 512 MB

Hard Disk 3 GB of free space

Minimum Client Side Requirements

Software

Operating System Windows XP or above

Web Browser IE, Firefox, Chrome, Opera, Safari

HARDWARE

Processor 1.0 GHz or above

RAM 512 MB
 Hard Disk 1 GB (if downloading is required)

Unique Study Point System Project

Proposal
Study Point is one of the top-running businesses all over the world. The study business has
emerged with massive growth over the last decades. Educations are also one of the main reasons
for tourism growth.. of Unique Study Point is one of those study for whom we are going to
develop a system to make courses for customers.

Study Point is one using a manual system for study reservations, bill settlement, and others.
Managing the task manually can be very hard and time-consuming. There comes the role of the
Education System. The Study point is system helps customers to reserve hotel Courses from
anywhere at any time with the medium of the internet.

The unique study point is system for this works as the mechanism through which guests can
create a secure online reservation. The study management system is capable of handling various
activities like Guest details, Reservation details, invoice details, and many more. This system
provides good information sharing to both customers and staff of the study point. The study
reservation system will be the means to eliminate the manual system which then provide faster
and more efficient operation in the study point. The Education reservation system is also
considered to offer an efficient, informative, and user-friendly website. Customers will be able to
easily make accommodation reservations, for different types of Courses, and select course within
their range simply by going to the our website.

Problem Statement
The problem that our system might face are:

1. Lack of study point and website

2. Inability to match guest
3. As guests can arrive directly to hotels and reserve course and if the admin forgets to set the
courses reserved in the system it can create confusion and
4. If the admin does not view the guest reservation and acknowledge them guests might have to
wait for a long period to assure that their reservation is
5. Guest cannot access every detail of the
6. The guest does not know what the surrounding of the study point looks
7. A technical problem like a server down may be another
 Objectives
The Unique Study Point system will be involved in the following actions:

1. To avoid manual and repetitive

2. To keep track of available course and
3. To create a database where every customer’s detail is
4. To secure all the data and records.
5. To provide speed reservation and registration service.
6. To retrieve records simply whenever
7. To authorize the users to have access to the records.
8. To generate a proper
9. To inform the availability of course in real-time.
10. To provide the ability to reserve course anytime from anywhere with an internet

Methodology
For our project on the Course reservation system, we will be using the waterfall method as it is
easy to manage because of its rigidity.

Working Mechanism of the Study reservation system

Requirement identification
Study of the existing system
The current system of Study management is fully based on paperwork. All the records of
customers and course which are available in the study point are managed by the education
management through paper. There may be some problems or delays in allocating courses and
providing services by a human. Manually handling the courses records, customer details, and
other management is hard and time-consuming. While all the records are kept in files they may
get torn out, lost, or get damaged due to water or fire. Calculations done by staff may not be
accurate sometimes. And even transferring the records or finding records is a big problem and
also creates a mess. The manual system of course reservation is also time-consuming as a
customer have to visit the website first and ask for available course then inspect those courses
then only if the customer like it, he will take the course or else he won’t and for all these
processes cost a lot of time.

There are also many course booking websites but those websites create competition among the
hotels. Those websites also create confusion for customers to choose between many study
points.. Those websites may also charge some fee for linking up the institute site. Those websites
may also take paid promotions from the big course and refer only those courses to the customers.
 Disadvantages of the existing system:

1. Time-consuming system for making reservations and recording

2. Mixing of two or more customers
3. Recording of data manually is not
4. A lot of space can be taken from
5. It may face the problem of human
6. Possibility of losing customers 7. Unwanted duplication of the record.
8. Difficulty in maintaining file security and
9. Easy access to guest information by unauthorized users.
10. Reusing and retrieves of guest records are extremely difficult.

Requirement Collection
Functional requirement

1.
1. The administrator can check the information of users.
2. Users have to register and log in.
3. The system accepts the user registration only if the required fields are
4. Users can search and book rooms according to their
5. Booking confirmation should be sent to the user’s email and
6. Confirmation of room reservations should be stored in a
7. Users can also cancel the booking without any
8. The system will be able to display the available
9. The system allows the customer to check the
10. Displaying their charges and other

Non-Functional requirement

1.
1. It is easy to use, efficient, and
2. It will be developed in such a way that the system is available both day and
3. Any modification like insert, delete, update, etc. for the database can be synchronized
quickly and can only be executed by the
4. System payment will be accepted via various
5. The system must recover easily from any kind of
6. The system must be protected from unauthorized

Feasibility Study
A courses reservation system is a system that is highly feasible for these kinds of study point.
This system is being developed after a high-level study of the entire system analysis and design
process which helps the hotel in every aspect. The system being developed will be flexible to
support the course to acquire more guests. There are three types of feasibility studies we kept in
our mind for the development of the system for this study point.

Technical feasibility
The proposed system of course reservation is very technically feasible as we are going to
develop the system using existing technology. The required hardware and software for the
development of the system are available. The software developed for the hotel management
system is used in a client-server architecture where HTML, CSS, and JavaScript are used as the
front end and Django is used as the back end for this project. With every knowledge of working
with programming languages, we are going to develop the system.

Operational feasibility
The course reservation system is very feasible regarding the operation of the course reservation.
The system is just an advancement of the manual system. The main purpose of the system is to
provide an online reservation service to guests which is easy to operate and staff to handle that
reservation easily. The system helps to promote the course and also creates a user-friendly
environment for course booking that saves time. The system helps in recording the details and
providing invoices for both guests and the staff without having to deal with time-consuming
paperwork.

Economical feasibility
The system will help reduce the traditional record-keeping style which will eventually reduce the
expense of hotels for registers and files. Keeping records in a digital format is less costly yet
reliable. The system also does work alone which requires two or more people to do it. The cost
for the development of the system is also one time cost as the system is reliable in the long run.
High-Level Design of System
Figure 2: Use Case Diagram

In the figure above, the guest and admin are the actors, and gives are the actions performed by
them in the system. Both of them have to log into the system for performing any task. The guest
has to insert their details while booking the room which will be verified by the admin when the
guest checks in at the hotel. Whenever the guest makes or cancels the reservation admin has to
acknowledge it. Guests always check for the rooms before making a reservation. The guest
receives the bill and the admin
should provide him with the bill. Admin is responsible to establish room rates and also categorize
the rooms.
Flowchart diagram

Figure 3: Flowchart diagram

The above diagram shows the flowchart of the user logging into the system for the reservation.
When the guest visits the website, he/she sees the home page from where he/she can log in. If the
guest is not registered in the database, he/she has to register first then only they can explore the
room information given on the website. If he/she likes the room they check for its availability. If
the room is available, they have to insert their details to confirm their reservation.

Expected Outcomes
When the project is completed then the users can register and log in to their account in this
application and can easily book their choice of courses in the Unique study point. This system
also helps to minimize the work of the staff by digitally storing records. It also increases the
reservations of the course. People can book rooms at the course from anywhere at any time. The
invoices are printed within a second with full accuracy. From this system, we expect to
introduce the hotel internationally. The well-developed website creates a userfriendly
environment which makes it easy to use the website.
Coding & Output

Code of Navbar
Code of Carousel
Code of Key Supporter
Code of Courses
Code of Accordion
Code of About Section
Code of Contact Us
Code of Footer
Code of Register Form
Code of Login Form
Code of Form (join us Our Study Point )
Code of Table (Where data Save )

Admin Panel