MINIDBMS

COVID BED-SLOT BOOKING
CHAPTER 1
INTRODUCTION
This web based application can be used in following ways.
• Allow covid patients to arrange appointments in nearby hospitals.

• Regular monitoring is done.
• Patient’s health updates and information is readily available in one place.
• It can be used in times of need by a certified medical practitioner.
• Regular monitoring is done and a report is sent to hostel/pg. heads.
Dept. of ISE, DSATM 2021-22

Page 1
CHAPTER 2
REQUIREMENTS ANALYSIS
The requirement analysis specifies the requirements needed to develop a graphic
project. In this phase, we collect the requirements needed for designing the project.
The requirements collected are then analysed and carried to the next phase.
2.1 SOFTWARE REQUIREMENTS:
• Operating System: Windows 7 or above
• Programming Language: Python
• Front-end Development: HTML, CSS, JAVASCRIPT, XML
• Back-end Development: PYTHON
• Operating System(Client side):Android OS(Version 4.1& above)
2.2 HARDWARE REQUIREMENTS

• Processor – Pentium IV or above
• RAM – 2 GB or more
• Hard disk – 3 GB or more

Page 2
CHAPTER 3
DESIGN
3.1 ER DIAGRAM
An Entity – Relationship model (ER model) describes inter-related things of

interest in a specific domain of knowledge. An ER model is composed of entity
types (which classify the things of interest) and specifies relationships that can exist
between instances of those entity types.
Figure 1: Entity – Relational diagram of student performance analysis
The ER Diagram above shows all the entities, their attributes and the relation between
them. Gives the relation between a Admin, User , and the Hospital user. These entities
describe various attributes which serves as data for the database.

Page 3
Figure 2: Relational Schema Diagram of student Performance

Analysis
The term "schema" refers to the organization of data as a blueprint of how the database
is constructed (divided into database tables in the case of relational databases).

Page 4
Figure 3: Use case diagram of Student Performance Analysis
The main purpose of a use case diagram is to show who interacts with your system, and
the main goals they achieve with it.

Page 5
CHAPTER 4
IMPLEMENTATION
4.1 INTRODUCTION TO FRONT END TOOL
4.1.1 HTML 5
HTML stands for Hyper Text Markup Language. It is used to design web pages using
markup language. HTML is the combination of Hypertext and Markup language.
Hypertext defines the link between the web pages. Markup language is used to define
the text document within tag which defines the structure of web pages. HTML 5 is the
fifth and current version of HTML. It has improved the markup available for documents
and has introduced application programming interfaces(API) and Document Object
Model(DOM).
4.1.2 CSS
Cascading Style Sheets, fondly referred to as CSS, is a simply designed language

intended to simplify the process of making web pages presentable. CSS allows you to
apply styles to web pages. More importantly, CSS enables you to do this independent
of the HTML that makes up each web page.
CSS is easy to learn and understood but it provides powerful control over the
presentation of an HTML document.\
4.1.3 JAVASCRIPT
• JavaScript was initially created as a browser-only language, but it is now

used in many other environments as well. Today, JavaScript has a unique
position as the most widely-adopted browser language with full integration
in HTML/CSS. If you want to display static content, for example, a set of
images, then HTML can do the job for you. However, static pages are
slowly becoming a thing of the past. Most of the content today is
interactive and includes flashy slideshows, forms, and menus. They
enhance user experience and add dynamicity to the website.

Page 6
4.2 INTRODUCTION TO BACK END TOOL
4.2.1 Python
Python is a dynamic, interpreted (bytecode-compiled) language. There are no type

declarations of variables, parameters, functions, or methods in source code. This
makes the code short and flexible, and you lose the compile-time type checking of
the source code. Python tracks the types of all values at runtime and flags code that
does not make sense as it runs. Python is a full-stack language. It is used in
backend development while its frameworks are used in frontend development. A
Python program can be written in MAC OS and the same program can run in Linux,
therefore Python is also a cross-stage language.
4.3 DATABASE CONCEPT USED

4.3.1 SQLite
SQLite is a relational database management system (RDBMS) contained in a C library.

In contrast to many other database management systems, SQLite is not a client–server
database engine. Rather, it is embedded into the end program. SQLite is ACID-
compliant and implements most of the SQL standard, generally following PostgreSQL
syntax. However, SQLite uses a dynamically and weakly typed SQL syntax that does
not guarantee the domain integrity. This means that one can, for example, insert a string
into a column defined as an integer.
4.3.2 DATABASE USED
In this project we use 6 Databases. Namely,
1.Coviddbms.db
2.Information_schema.db
3.mysql.db
4.Performance_schema.db
5.phpmyadmin.db
6.Test.db

Page 7
With 5 Database Classes . Namely
1.TEST
2.USER
3.HOSPITALUSER
4.HOSPITALDATA
5.TRIG
6.BOOKINGPATIENT
4.4 CONNECTIVITY OF THE DATABASE
4.4.1 XAMP
XAMPP is a cross-platform web server that is free and open-source. XAMPP is a short
form for Cross-Platform, Apache, MySQL, PHP, and Perl. XAMPP is a popular cross-
platform web server that allows programmers to write and test their code on a local
webserver. It was created by Apache Friends, and the public can revise or modify its
native source code. It includes MariaDB, Apache HTTP Server, and interpreters for
PHP and Perl, among other computer languages. Because of XAMPP’s simplicity of
deployment, a developer can quickly and easily install a WAMP or LAMP stack on an
operating system, with the added benefit that common add-in apps like WordPress and
Joomla can also be loaded.
Need for a XAMPP
• XAMPP is simply a local host or server.
• This local server runs on your personal computer, whether it’s a desktop or a
laptop.
• It is used to test clients or websites before publishing them to a remote web
server.
• On a local computer, the XAMPP server software provides a suitable
environment for testing MYSQL, PHP, Apache, and Perl projects. Because

Page 8
most real-world web server deployments share the same components as
XAMPP, moving from a local test server to a live server is straightforward.
Database Inspector:
• Database Inspector shows all the tables included in our project.
• It also shows all the attributes in a particular table.
• The “key” (blue colour) symbol indicates that the entity is a Primary Key.
• Database Inspector also allows has the feature to write the query, execute it and get/check
the required values.

Page 9
4.4 MODULES
1.main.py

Page 10

Page 11

Page 12

Page 13

Page 14

Page 15
2.covid.sql

Page 16

Page 17

Page 18

Page 19
3.launch.json
4.configjson

Page 20
5.main.js

Page 21

Page 22

Page 23
6.style.css

Page 24

Page 25

Page 26
CHAPTER 5

Page 27
TESTING
5.1 TESTING
Testing is the process of executing a program to find the errors. A good test has the
high probability of finding a yet undiscovered error. A test is vital to the success of
the system. System test makes a logical assumption that if all parts of the system
are correct, then goal will be successfully achieved.
• TYPES OF TESTING
5.2.1 Module Testing.
5.2.2 Integration Testing.
Module Testing
Module testing is the testing of complete code objects as produced by the complier
when built from source.
A library may be composed of a single complied object or several complied objects.

There is only a slight difference between unit testing and module testing. Modules are
fully formed chunks of coherent source code that can typically be tested by driving a
few functions signatures with various stimuli. On the other hand, unit testing (which is
considered as part of the implementation phase for this software development process)
may involve testing one small part of a function that will never formally implement any
function interface.
As a result of modules being more self-contained, module testing will likely require
less testing infrastructure such as test harness and test stubs. The testing of modules
could perhaps even be automated so that they can be included in regression test suites
or a acceptance test suites.
Integration Testing
Integration testing (sometimes called integration and testing, abbreviated I&T) is the
phase in software testing in which individual software modules are combined and tested
as a group. It occurs after unit testing and before validation testing. Integration testing

Page 28
takes as its input modules that have been unit tested, groups them in larger aggregates,
applies tests defined in an integration test plan to those aggregates, and delivers as its
output the integrated system ready for system testing.
1 Register Click on Move to the Button working Pass

button
Register Screen
2 Login Click on Move to Home Button Working Pass

button
Screen
3 Add Click on Allow user to enter Successfully Pass

button the data enters the Data
4 View Click on Allow user to view by Data is displayed Pass

button date for selected date
5 Update Click on Allow user to Displays the Pass

button update the existing updated data
data
6 Delete Click on Allow user to delete Deletes the Pass

button the unwanted data selected data
7 View by Click on Allow user to select Category selected Pass

button the required successfully
Category
category
8 View by Click on Allow user to select Mode selected Pass

button the required mode of successfully
Mode
transaction
9. Select Click on Allow user to check User gets Pass

button expense of a monthly expense
Month
particular month of a details
And Year year
10 Select Click on Allow user to check User gets yearly Pass

button expense of a expense details
Year
particular year

Page 29
CHAPTER 6
SNAPSHOTS
Snapshot 1: “HOMEPAGE”
Snapshot 2: “HOMEPAGE”

Page 30
Snapshot 3: “LOGIN OPTIONS”
Snapshot 4: “admin login”
Snapshot 5: “ADDING HOSPITAL USER

Page 31
Snapshot 6: “AFTER LOGIN BY HOSPITAL USER
Snapshot 7: “ADDING HOSPITAL”
Snapshot 8: “ADD HOSPITAL DATA”

Page 32
Snapshot 9: “HOSPITAL DATA ADDDED”
Snapshot 10: “LOGGING OUT”
Snapshot 11: “USER LOGIN”

Page 33
Snapshot 12,13,14: “USER LOGGING PROCESS”

Page 34
Snapshot 15: “SLOT BOOK”
Snapshot 16: “DATA OF AVAILABILITY OF BEDS”
Snapshot 17: “SLOT BOOKED”

Page 35

Page 36
Snapshot 18,19,20,21: “DATA STORED AT LOCALHOST”

Page 37
CONCLUSION AND FUTURE ENHANCEMENTS

To conclude the description about the project: The project developed using HTML,
CSS, JavaScript, Node.js and MySQL on the requirement specification of the user and
the analysis of the existing system, with flexibility for future enhancement.
The expanded functionality of today’s software requires an appropriate approach

towards software development. The Student Performance Analysis is designed for
Teachers and faculties whom want to check the records of the student and for those who
want to see the performance of the branch.
In future enhancements, Teachers and faculties would have the option to render the
database by inserting the records through the website, this software can be converted
into a mobile application ( most probably using PWA) which further reduces the need
to visit the website.

Page 38
REFERENCES
1). Google.
• https://www.codingconnect.net/android-application-makes-use-database/
•https://www.journaldev.com/9438/android-sqlite-database-example-tutorial
• https://developer.android.com/

Page 39

MINIDBMS

Uploaded by

Copyright:

Available Formats

MINIDBMS

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

MINIDBMS

Uploaded by

Copyright:

Available Formats

COVID BED-SLOT BOOKING

• Allow covid patients to arrange appointments in nearby hospitals.

Dept. of ISE, DSATM 2021-22

2.1 SOFTWARE REQUIREMENTS:

• Operating System: Windows 7 or above

• Programming Language: Python

• Front-end Development: HTML, CSS, JAVASCRIPT, XML

• Back-end Development: PYTHON

• Operating System(Client side):Android OS(Version 4.1& above)

2.2 HARDWARE REQUIREMENTS

Dept. of ISE, DSATM 2021-22

An Entity – Relationship model (ER model) describes inter-related things of

Figure 1: Entity – Relational diagram of student performance analysis

Dept. of ISE, DSATM 2021-22

Figure 2: Relational Schema Diagram of student Performance

Dept. of ISE, DSATM 2021-22

Figure 3: Use case diagram of Student Performance Analysis

Dept. of ISE, DSATM 2021-22

4.1 INTRODUCTION TO FRONT END TOOL

Cascading Style Sheets, fondly referred to as CSS, is a simply designed language

• JavaScript was initially created as a browser-only language, but it is now

Dept. of ISE, DSATM 2021-22

4.2 INTRODUCTION TO BACK END TOOL

Python is a dynamic, interpreted (bytecode-compiled) language. There are no type

4.3 DATABASE CONCEPT USED

SQLite is a relational database management system (RDBMS) contained in a C library.

4.3.2 DATABASE USED

In this project we use 6 Databases. Namely,

Dept. of ISE, DSATM 2021-22

With 5 Database Classes . Namely

4.4 CONNECTIVITY OF THE DATABASE

Need for a XAMPP

• XAMPP is simply a local host or server.

• It is used to test clients or websites before publishing them to a remote web

• On a local computer, the XAMPP server software provides a suitable

Dept. of ISE, DSATM 2021-22

most real-world web server deployments share the same components as

XAMPP, moving from a local test server to a live server is straightforward.

• Database Inspector shows all the tables included in our project.

• It also shows all the attributes in a particular table.

Dept. of ISE, DSATM 2021-22

Dept. of ISE, DSATM 2021-22

Dept. of ISE, DSATM 2021-22

Dept. of ISE, DSATM 2021-22

Dept. of ISE, DSATM 2021-22

Dept. of ISE, DSATM 2021-22

Dept. of ISE, DSATM 2021-22

Dept. of ISE, DSATM 2021-22

Dept. of ISE, DSATM 2021-22

Dept. of ISE, DSATM 2021-22

Dept. of ISE, DSATM 2021-22

Dept. of ISE, DSATM 2021-22

Dept. of ISE, DSATM 2021-22

Dept. of ISE, DSATM 2021-22

Dept. of ISE, DSATM 2021-22

Dept. of ISE, DSATM 2021-22

Dept. of ISE, DSATM 2021-22

Dept. of ISE, DSATM 2021-22

Dept. of ISE, DSATM 2021-22

A library may be composed of a single complied object or several complied objects.