Tag: PHP

Posted on

Library Management System Using PHP, JavaScript, HTML, CSS and MySQL

Introduction

The Library Management System is an application to manage various tasks such as check out and check in of books, adding the borrowers, and fine management of the books.

Functions:

1. Search Books based on keywords.
2. Select the book and checkout if available.
3. Check in the book.
4. Pay fines for books checked in after the due date.
5. Add borrowers.

Architecture

To implement the system, various schemas were built which are described below:

1. Book
The book table contains the ISBN, title, and availability of the book. Here, ISBN acts as the primary key of the table.
2. Book Authors
The Book_Authors table contains the Author_id and ISBN number of the book written by the author. Here, Author_id and ISBN act as the primary key.
3. Authors
The Authors table contains the Author_id and name of the author. Here, Author_id is the primary key.
4. Borrower
The Borrower table contains the card_id, SSN, Name, Address, and phone number of the Borrower. Here, card_id is the primary key.
5. Book Loans
The Book_Loans table contains the Loan_id, ISBN, Card_Id, Date_out, Due_date, and Date_in of the book loans. Here, Loan_id is the primary key.
6. Fines
The Fines table contains the Loan_id and Fine_Amount of the book loans. Here, Loan_id is the primary key.

The application is built on MVC (Model View Control) Architecture.

Libraries and Software Used

Software Used: Wamp(Apache, MySQL, PHP)
Database: MySQL
Language: PHP, JavaScript, HTML, CSS, SQL
Libraries: Bootstrap

User Manual

There are 4 navigation links on the index/home page. The following are the functionalities of each tab:

1. Search Books

The user can search books from the database by typing the keywords into the search box provided and clicking the search button. If the keyword matches the records in the database, the result is displayed in tabular format. On clicking the row of the table, the user can proceed to checkout if the book is available by providing the card id.

2. Check in Books

First, the user needs to search for the record by providing the keyword in the search box and clicking the search button. After the results are fetched, on selecting the required row, the user can check in the book.

3. Pay Fines

On clicking the refresh button, the user can see the total summed fines of the borrower based on their card id. On clicking the required row, the user can pay the fines.

4. Add Borrower

By filling out the form and clicking on submit button, the user can add a borrower to the database.

Download Library Management System Project Using PHP, JavaScript, HTML, CSS, and MySQL.

Posted on

Food for Life PHP Minor Project Synopsis

Introduction

”FOOD FOR LIFE” is a food relief web project to serve food for the needy. Nowadays, One-third of the food produced is being wasted and about 9 percent of the people in this world go to bed on an empty stomach. In this Minor Project, various party palaces or hotels have to give information about their unused food on our website and we or other organisations have to collect the food and distribute the food to the needy.

Technologies to be used

 This Food for Life project will be a Web application to be developed in PHP having below technologies:

  • PHP
  • HTML
  • MYSQL
  • JavaScript

Technical feasibility

The technical needs of the Food for Life system may include:

Front-end and back-end selection

When we decided to develop the Food for Life project we went through an extensive study to determine the most suitable platform that suits the needs of the organization as well as helps in the development of the PHP & MySQL project.

Front-end selection:

    1. Scalability and extensibility
    2. Flexibility
    3. Robustness
    4. Platform independent
    5. Easy to debug and maintain

Back-end Selection:

1. Multiple user support.
2. Efficient data handling.
3. Provide inherent features for security.
4. Efficient data retrieval and maintenance.
5. Easy to install.
6. Various drivers must be available.
7. Easy to implant with the Front-end.

Objectives 

The main objectives of this Food for Life project are:

  • The main objective of our academic minor project is to reduce food wastage as many of us throw unused food in dustbins
  • The objective of this is to help the organization that serves food to the hungry people

Conclusion 

This ”Food For Life” project is to feed hungry people with the help of our system. Organizations such as hotels or restaurants have to publish the details of their food on our Food for Life website.

Posted on

College Classroom Check and Fill Mini Project Synopsis

Introduction

The Classroom Check and Fill project is to prepare a website that tells the current status of a particular room. It tells whether a class is going on or empty or there is no class in that particular room. . It uses the technologies like PHP, python, java, MySQL, and many more. With the help of this website, a teacher or a student can know the status of the room and work accordingly.

Objectives

The aim of our project is to help teachers and students to check if in the room a class is going on if the room is empty or if there is no class in that particular room.

1. To help the HODs and teachers to check whether the venue is empty or not (in one click)
2. To help students to check their timetables with ease
3. Provides user-friendly application

Methodology/ Planning of work

Step 1: GATHERING RELEVANT INFORMATION
Our project is to help teachers and students to check if in the room a class is going on or the room is empty or there is no class in that particular room. We will take the relevant information from the CR of a particular class of IT and update the status of the room accordingly.

Step 2: PLANNING

Step 3: DESIGN LAYOUT

Basically in this step, we create the front-end part of our website with the help of languages like HTML, CSS, Bootstrap, and Javascript.

Step 4: DEVELOPMENT

Step 5: TESTING, REVIEW, AND LAUNCH

Step 6: MAINTENANCE AND UPDATION

Facilities required for proposed work

Hardware Requirements: Laptop – i3 processor or higher, 4 GB RAM or higher, 100 GB ROM or higher
Software Requirements: Laptop or PC, Windows 7 or higher, Visual Studio, HTML, CSS, Javascript, Mysql, Php

References

[1] Geekathon series(2013)[Online]. Available: http://www.GeeksforGeeks.com
[2] Jimmy Wales, Larry Sanger (2001)[Online]. Available: http://www.Wikipedia.com
[3] Refnes Data (1998)[Online]. Available: http://www.w3schools.com
[4] Steve Chen (2005) [Online]. Available: http://www.youtube.com

Posted on

StellarStudent College Student and Faculty Communication Project

StellarStudent is a web application that deals with students and faculty. Ever since digitalization started in the country, schools and colleges want the best way possible to share information with their students. Some colleges use Google Drive or Whats app to share materials or collect other documents. However, the chance of data loss or misplacement is guaranteed. It is better for the college to have an admin who can look after all the happenings on the college website with just one click. With high security and validations of users, the chances of data misplacement are low with StellarStudent.

This Student and Faculty Communication project aims to connect the students with their faculty with no miscommunication. It is a web-established web-based application that involves faculty uploading study materials and notices like events and placement drives, viewing certifications, and quiz results of students. Students can also communicate with each other via the exchange of images, feedback, and discussion. This application can be handled by the admin and manage students as well as faculty.

Objective 

The StellarStudent is a web-based Student and Faculty Communication project for BVRIT-H students and faculty. The main objective of this project is to let college students interact with their faculties.  In this project, the faculties can upload materials, quizzes, etc. Even students can ask questions to faculties and can also upload the certificates. Our main goal is to ensure cost-effective, technical excellence, and secure apps.

Methodology 

To store the user data MYSQL has been used as a database. HTML and CSS have been used for front-end development. PHP is used as a server-side language, which is used to connect the front end to the back end. We can run this application in our browser.

Software requirements specifications

 Introduction:

Student and Faculty Communication SRS describes the requirements and specifications of StellarStudent, a web-based application for the college. 

Purpose:

The purpose of this document is to present a detailed description of StellarStudent.

Scope:

The project StellarStudent helps college students to interact with their faculties and many more. This web application can be accessed by students and faculty of BVRIT HYDERABAD College of Engineering for Women.

Overall description

The project StellarStudent is a web-based application with two interfaces: One is for students and another is for management. The website works on desktop computers, laptops, and mobile devices with the help of a browser.

Project Functions:

The project Student and Faculty Communication has the following product functions:

  • The web portal will provide the functionality to manage the system and the student
  • The website is secure because users must enter login details to access the
  • The system contains a huge For this reason, the search option has been provided on all report pages. The search results can be viewed in the list view.
  • The product works online with help of the internet

Assumptions and Dependencies

    • Internet connection
    • 24X7 uptime server connection
    • One assumption about the product is that it will always be used on mobile phones that have particular technical support.

Modular Decomposition of Components:

Dashboard Component

• Admin account
• Publish news
• Publish events
• Publish meeting schedule
• Add course records
• Add subject records
• Add certificate types

Faculty Component:

• Quiz materials
• Study materials
• Students record
• Faculty profile
• Certificates

Discussion Component:

• Post discussion forum
• Discussion reply
• View discussion forum

Quiz Component:

• Upload quiz question
• Attend quiz exam
• Quiz result

Study material Component:

• Upload notes
• View study materials

Certificate Component:

• Upload certificates
• View Certificates

Upload certificate by student Screen

View Uploaded Certificates

Posted on

Online Learning Management System PHP Project

Objectives of the Project:-

The general objective of this Online Learning Management System project is to provide various courses to students as well as others who are interested in learning online. The use of the internet has increased and so the courses are available to be learned online. By providing this option, it would be easy for the users to learn by sitting in a comfortable place and learning based on the time they have.

The courses will be added, deleted, etc. by the admin. This project consists of the front end and back end sides. The front end side of the website is developed for the general public who are interested to know about us and to find out the courses provided by the management system. The back end is for the users who have created their accounts and admin utilities.

Scope of the Project:-

For this project, to store all the data various tables and attributes are required. As the main idea of this project is to provide courses for the students to enroll in and learn, it will also allow the instructors to teach courses. Thus the scope of this project is limited to the following tables: COURSES, USER DETAILS, STUDENTXREF, and INSTRUCTORXREF.

User requirements:-

Following would be the basic user requirements-

  1. Users should be able to view the Home page, About Us, and login/Register page of the website.
  2. Users should be able to search for the courses in which they are interested.
  3. Users will be asked to enter the user type as Student, or Instructor while creating the account.
  4. Users who have been marked as Students will be allowed to enroll in the available courses and will be displayed the courses in which they are already enrolled.
  5. Users marked as Instructors will be able to teach the course which is not taught by anyone else. They will be able to see the courses which are taught.
  6. Admin type of user will be able to add or delete courses as well as delete instructors from the courses.

*Note – User can be general public without creating an account, student, instructor, and admin.

Business Rules:-

Below are some basic business rules-

  1. One student can enroll in many courses.
  2. Every single course can be taken by many students.
  3. One instructor can teach many courses.
  4. One course will be taught by only one instructor.
  5. Users can be students or instructors based on the details entered while creating an account.

Entities and their attributes:

In this proposal, there are basically 4 entities. The description for each is given below-

USERDETAILS Entity –.When a student or instructor wants to enroll/teach for any course, first of all, they will have to create an account on the website by using the login page. All the details entered while creating an account will be stored in this table. This table will consist of the attributes as User id, user last name, user first name, user type (it can be student or instructor), and password. The primary key of this table will be the user id. Once the user has created an account, they will be able to know about the courses.

COURSE Entity – The course table will store all the details related to the courses which are offered. This table will have the following attributes Course id, Course name, course department, course description, course start date, and course end date. Course id will be the primary key for this table. Based on the above attributes, students can decide which course they are interested in. The instructors will also be able to know about the courses which are already taught by some other instructors and the courses available for them to teach.

STUDENTXREF Entity- This table will act as a reference table between the COURSE and USER DETAILS tables. The attributes of this table are student id, course id, and user id. The primary key of this table will be the student id.

INSTRUCTORXREF entity – This table is also a reference table between COURSE and USER DETAILS tables. If the user type is instructor then the details for that user id will be stored in this table. The attributes of this table are instructor id, user id, and course id. Instructor id will be the primary key for this table. Here the course id will be unique as 1 course cannot be taught by multiple instructors.

Entity-Relationship Diagram:-

Fig 1: Entity relationship diagram for Online Learning Management System.

Website Description:-

The online learning management system is a system that provides students to learn about various courses online. Various pages have been created for the users like Home Page, About Us page, Login/Register Page, and Search courses page.

The sitemap for the online Learning management system is as:

The project consists of the Front end and back end. The front-end pages are described below:

Home Page:

This page is the main page of the project. This page gives a brief description of the management system and also posts the latest courses which are going to be added in the future. This page will be linked to all other pages. Whenever the user is interested in learning any course, then they need to create an account by clicking on the Login/Register button provided on the navigation bar.

Login/Register Page:

The login page lets the user enter their username and password to login to their account. There are three different links for students, instructors and admin in the login/register page. Students can click on the enroll/register for courses link in order to login into the account. Students who are already registered can put in their username and password to login to the account. In the case of new users, they can register for a new account by clicking Join us button. In order to sign up for an account a user needs to enter an email address, preferred username and password, and date of birth. The user has to make a selection of the account type either teacher or student from a drop-down menu. Then they can simply login into their account. 

The login page lets the user enter their username and password to login to their account. There are three different links for students, instructors and admin in the login/register page. Students can click on enroll/register for courses link in order to login into the account.

Students who are already registered can put their username and password to login to the account. In case of new users, they can register for a new account by clicking Join us button. In order to sign up for an account a user needs to enter an email address, preferred username and password and date of birth. The user has to make a selection of the account type either teacher or student from a drop down menu. Then they can simply login into their account. 

About Us Page:

This page describes the goal of developing this project. This will make clear to the users what the purpose of developing this website is and how they can use it. Contact information is also provided for the users so that if they have any doubts, they can send an email with the query. 

1.6.4 Search course Page:

When a user is interested in learning any course, before creating an account he can check whether the course in which he is interested is provided by the management system or not. This search option will help them to know about the courses and then they can decide whether to enroll in those courses or not. While using the search option, users are not required to create an account.

The back end part will come into the picture when the user has created an account. Users can be students or instructors. While creating an account, the user will be asked to select the User type from the drop-down option. The pages at the backend side are described below:

Student Page:

This page (student.php) will be displayed to the user whose user type is Student. It will display the courses which are available for a particular student to enroll. He can select multiple courses for enrolling. Checkboxes are provided in front of all courses and then finally enroll button is provided.

Once the student selects any course and clicks on Enroll button, he will be shown a thank you message for enrolling in those courses. Student.php will call enroll.php when an enroll button is clicked by the student. The back button is provided on enroll.php which will re-direct the student to student.php. The student will also be displayed the courses in which he has already enrolled on student.php. 

Instructor Page:

When a user selects the user type as an instructor, he will be directed to instructor.php page. On this page, he will be displayed with the courses which he is already teaching. The instructor will be able to teach courses that are not being taught by any other instructor. A checkbox option will be provided to the instructor to select courses and then he can click on each button. This button will direct the instructor to teach.php page where he will be displayed a thank you message.

Admin Page:

Admin page is designed for the administrator to add and delete courses in the system. In order to login as an admin the user needs to select the admin-Add/Delete courses link from the Login/Register page. Two options appears in the admin page 1.Add a course and 2.Remove a course. Add a course lets the admin add new courses in the system.

The details the admin needs to provide in order to add a course are course name, course department, course description, course start date, and course end date. The admin can simply press the Add Class button. A success message appears on the page after the submission of the details. In order to remove a class the admin can make a selection from the drop-down menu and press the Delete Class button. The success message appears afterward.

Functions provided by the website are:

  1. The following are the functions provided by the online learning management system:
  2. Browse the homepage, and about us page.
  3. Search courses without creating an account.
  4. Interested users can create an account.
  5. Students can enroll in courses.
  6. The instructor can teach courses that are not being taught by any other instructor.
  7. Admin can add/delete courses.

Usability considerations:

The online management learning system website has logical navigation. Users can easily navigate around the webpage. The home page gives the users information about the whole system. All the contents are written in simple language. It has a user-friendly interface and functions well with no broken links. All the links and sub-links are clearly represented. The procedures to log in to the account, register for courses, and add or remove the courses from the system are very clear.

The system lets the users know if their attempts of adding courses or removing courses were successful. When the users put wrong credentials while logging in, it lets users know their attempt has failed because of the wrong username or password. So, that user can put the correct information and log in to the account. The website has all the required functions based on user types. That makes the website informative and user-centered. 

FUTURE ENHANCEMENTS:

  1. Based on the entries in the database, graphs can be created to provide information about the number of students in each course.
  2. A class entity can be added to provide more information about courses like classrooms, class timings, etc.
  3. Change the template to make it more attractive and user-friendly.
  4. Passwords can be stored in an encrypted way to avoid giving away personal information.
Posted on

Covid-19 Testing Management System Python Project

Covid-19 Testing Management System is a small project developed using Python programming. Here are the application features below.

Project features:

• Adding new testing centers
• Search for available testing centers by locality
• Update and delete testing centers
• Show all testing centers by city, state
• Shows the number and type of testing kits available at each center.

Software to be used to develop this application:

• Python
• SQL for creating a database
• Library to interface between Python and SQL
• Either Django (to create a web app) or a GUI library to create the UI (not decided yet)

Implementation

1. Login page (This has a simple login prompt designed using a GUI library that asks for the user id and password.)
2. Menu:
a. Add a testing center
B. Delete testing center
C. Edit the number of testing kits available
D. Search for the testing center by district/city/state
E. Show all testing centers
3. Separate sections for:
a. Adding a new center
b. Deleting center
c. Updating center information
d. Searching for center
e. Nationwide data

Covid-19 Testing Management System can be developed by using PHP & MySQL Server with different functionalities below.

User Characteristics

The Covid 19 Testing Management system has 2 types of users they are Admin and user(patient)

General Constraints

The tools and technologies that are used to develop this project are:
The language used in this project is PHP5.6 and PHP7.x.
The database used in this project is MySQL 5.x.
The web browsers that are used in this project are Mozilla, Google Chrome, IE8, and OPERA.

Operational Scenarios

Scenario A:
How your application starts
Our application covid19 testing management system starts by login into the application, if the user is a new user, the user needs to register by providing the needed credentials.
New users need to provide testing information. A registered user needs to provide test information.

Scenario B:
Usage Scenarios like Customer Check-out
When a customer visits our application, he/she needs to log in by providing their credentials according to their role i.e., admin and user.
If the user is new, he needs to register if he is an old user, he can directly enter the login details and login directly.

Scenario C:
Database

The data that we are going to store in the database
1) Admin Login
Username
Password

2) New admin login
Admin name
Username
Password

3) User login
Username
Password

4) New user login
Name
Phone number
Username
Password

5) User Registration
Name
Current address
Gender
D.O.B
E-mail id
Phone number
Age
Aadhar card number

Posted on

Hospital Patient Medical Records Information Project App

Introduction

Information and communication technologies (ICTs) have great potential to improve health in all countries by enhancing access to health information and making health services more efficient. Mobile applications (apps) and other related software can also improve the quality of services and reduce their cost. The aim of the Patient Medical Records Information project was to enable health care practitioners such as doctors and nurses working in hospitals to be able to retrieve patient medical information remotely on any mobile device.

In this Patient Medical Records Information report, I will outline the research I conducted in choosing various technologies. I will discuss the problems I encountered and the solutions I came up with to overcome these issues in creating the specific application. I will also discuss the many technologies I used in the creation of the app including a data model representing the design.

The architecture of the solution

The overall structure of the solution is that the mobile app is being created for the hospital to maintain patients’ records and keep nurses and doctors up to date without carrying heavy paperwork around with them. The technologies I used to create this app suggested by my supervisor were Ionic, PHP, Angular JS, JavaScript, and MYSQL.

PHP provides integration of general-purpose programming and web-development scripting language. It is suited for server-side web development, and scripting and is used for professional websites. AngularJS is used for dynamic web apps and allows you to use HTML as a template language extending HTML’s syntax to express the application’s components clearly and concisely (Docs.angularjs.org, 2016). I chose both PHP and AngularJS because I had very limited knowledge of how they work and I wanted to improve my knowledge and skills in using them and they were also free. 

JavaScript is a programming language used to make web pages interactive (Chapman, 2016) and MYSQL Database is an open-source relational database management system (RDBMS) based on Structured Query Language (Search EnterpriseLinux, 2016).  Both of these programs were chosen because my supervisor requested me to use them and they were also free to use. Finally, Microsoft AZURE Cloud storage is open cloud storage, flexible, enterprise-grade cloud computing platform (Azure.microsoft.com, 2016). I decided to use this platform as my supervisor provided it to me free of cost I researched it and I found a lot of information online to help me complete this project.

The clients who are the doctors and nurses wanted to be able to log in to a mobile app to retrieve information in relation to patients. Firstly the doctors’ requirements were to be able to see all of the patients registered to him/her and the associated patient information. Nurses wanted to be able to log in and see all patient files and associated information as they worked with all patients. The second requirement was that once the doctor/nurse logged in to the mobile app they would have the ability to update the patient records for example blood pressure, heart rate, types of medicine, etc and they could also add notes or remarks. When the remarks and related updated information is added to the mobile app it then updates all the medical history and notes related to the patient. Furthermore, once the doctor/nurse checks the patient’s information in the future the patient’s information will be updated which makes it an effective and efficient method in contrast to multiple physical files.

The Hospital Patient Medical Records mobile app itself is written in AngularJS and JavaScript and through the HTTP requests the mobile app sends the requests to the PHP and the PHP then retrieves the data from the cloud MYSQL and transmits the data back to the mobile app.

Class diagram and Data Model

Through the HTTP requests the mobile app sends the requests to the PHP and the PHP then retrieves the data from the cloud MYSQL and transmits the data back to the mobile app. I designed the mobile app using these technologies as it was a requirement of the project given by my supervisor.

Technologies used

The technologies used included:

  1. JavaScript
  2. PHP
  3. AngularJS
  4. MYSQL Database
  5. Microsoft AZURE Cloud storage 
  6. Ionic

I chose both PHP and AngularJS because I had very limited knowledge of how they work and I wanted to improve my knowledge and skills in using them and they were also free. 

JavaScript and MYSQL Database were chosen because my supervisor requested me to use them and they were also free to use. I utilized Microsoft AZURE Cloud storage as my supervisor provided this platform to me free of cost and I researched it and found a lot of information online to help me complete this project.

Problems Encountered/Solved

At the beginning of the Patient Medical Record project, I was overwhelmed with the task at hand as I didn’t know where to start or what to do, so my project supervisor guided me and gave me advice about how to commence the project and what to do to begin.

The first time I tried to retrieve the data from the database it took me 4 days to retrieve it. Subsequently, I spoke to one of my colleagues and my project supervisor and did some research online and I figured out how to retrieve the information more efficiently and effectively.

Time management was an issue because I had many assessments to do and I left work late and I was running out of time in the end. For example during the Easter break, I had numerous projects due so I found it difficult to allocate time to all of the different assessments. I also wasted my time using a Google database called Firebase at the beginning of my project but later on, I decided not to use it because of the project requirements, and as a consequence, I wasted 2 weeks.

Also in relation to time management, I didn’t anticipate how time-consuming the research from the project would be. E.g. it took me a number of days to understand PHP and learn how to write a PHP script that could talk to the database. AngularJS was never taught in college so I had to take the time to teach myself. Although I completed the project in the allocated time I learned the importance of organization and prioritizing work.

Conclusions

Mobile technologies are emerging as a powerful tool for health information transfer including making patient information portable and accessible. I gained a lot of experience from using the 4 technologies and I believe I have the capability of using them if needed for future projects or for employment purposes.

I am also aware of how to solve specific problems and how to research these problems e.g. in relation to database retrieval or how to successfully manage my time. I recognize that I can overcome difficulties and achieve my goals successfully by being persistent, organized, and patient. Although working in isolation on individual projects it is important and is a necessary part of employment it is important to seek advice or guidance from superiors or colleagues that may shed light on an issue or provide a new perspective.

Recommendations

In terms of further developing the Hospital Patient Medical Records Information Project App, it could be linked to local GPs, pharmacies, and other health care providers so there is a complete holistic picture of the patient and his/her medical history. I would also have managed my time better as I was under severe pressure and time constraints and this may have affected the quality of the end product.

Posted on

Design & Development of Disaster Safety Android app

A Disaster Safety Android app that helps people inform you about everything that is nearby by using help centers before and during an accident. Also, a PHP-based website to enter data on the server-side and work with the android application successfully. The Disaster Safety mobile app also gives you the location of all your friends and family that have been accessed by the user. The app can store offline maps and information about help centers also comes through messages and is displayed on the map.

Innovation:

India being a disaster-prone country suffers a lot of casualties every year not because of the lack of resources but because of the lack of information on these resources. This app brings the resources to you, even when you are in the middle of nowhere and knows nothing about what to do in such a situation, Disaster Safety app can save your life.

Features:

  • It works in offline mode and saves the data.
  • It not only works at the time of disaster but also in various situations like you are any kind of trouble or your phone is lost.
  • Gives the news and the guidelines about the various disasters.
  • Can track the location of your friends and family in danger.
  • Notifies you when your friend or a family member is in danger.
  • Saves a lot of power consumption as works offline.
  • Locates the nearby relief centers, hospitals, and police stations not only by internet but also through SMS.

Database Model

admin user

Column

Type

Null

id

int(11)

No

username

varchar(30)

No

password

varchar(50)

No

family 

Column

Type

Null

member_id

varchar(13)

No

family_id

varchar(13)

No

permission_given

tinyint(1)

No

guidelines 

Column

Type

Null

id

int(11)

No

calamity

varchar(30)

No

before_cal

text

No

during_cal

text

No

after_cal

text

No

help 

Column

Type

Null

id

int(11)

No

latitude

double

No

longitude

double

No

type_of_help

varchar(30)

No

login 

Column

Type

Null

Default

id

varchar(13)

No

 

name

varchar(30)

No

 

status

tinyint(1)

No

1

latitude

double

No

0

longitude

double

No

0

gcm_regId

text

Yes

NULL

news 

Column

Type

Null

Default

id

int(11)

No

 

notification

text

No

 

info

text

No

 

date

varchar(10)

No

 

Posted on

System Analysis and Design for Student Hostel Management System Project

Introduction

PURPOSE

The purpose of this SRS & System Analysis and Design document is to build a Hostel Management System Site to help students book hostel rooms at their own convenience, file complaints, and write reviews about the room.

INTENDED AUDIENCE AND READING SUGGESTIONS

The Hostel Management System project is useful for both students and hostel committee members.

PROJECT SCOPE

The purpose of this Hostel Management System is to ease hostel management and to create a convenient and easy-to-use application for students. The system is based on a relational database with room allotment, review, and complaint features.

The Application will be able to perform the following operations:

  1. Allot Rooms: Students will be able to choose hostel rooms according to their convenience and pay for the same.
  2. File a complaint: Students will be able to file a complaint regarding any of the facilities and if the complaint could not be resolved within the specified time, it would be sent to the higher authorities.
  3. Review the rooms– Seniors who have already stayed in the room will get an option to review a room in which they can upload the room pictures and write about the problems(if they had faced any).

Mess: Students will be able to pay the hostel fees, see their past payments and write reviews about the food and management.

ANALYSIS

Specific requirements

External Interface Requirements

User Interfaces

The goal of this Hostel Management System is to design the web application that will be used for the proper management of hostels. The user types are listed below-

  • Students
  • Hostel Committee
  • Mess Committee

ER Model

Hostel Management System ER Diagram

DESIGN

RELATIONAL SCHEMA

  1. Users
  2. Reviews
  3. Writes rev
  4. Rooms
  5. Complaints
  6. Writes com
  7. Student

USER INTERFACE DESIGN

GOAL

MAKE INTERFACE

  1. Pleasing to the eye.
  2. Simple to Use.
  3. Minimize the effort it takes for users to accomplish the work.

PRINCIPLES OF USER INTERFACE

  1. Layout
  2. Content Awareness
  3. User experience
  4. Consistency
  5. Minimize user effort

VARIOUS USER INTERFACES

  • HOME– It includes navigation among different pages. Starting with registration and login and address of other pages.
  • REGISTRATION/log in If you are a new user you have to register and if already a user only login is sufficient. After registration and login user will be redirected to the home page.
  • ROOM ALLOTMENT– After logging in it is necessary for the user to fill room allotment form if the room is already booked user will be redirected to the allotment form.
  • DASHBOARD– After booking the room user can see the status in the dashboard including username, scholar no and room booked.
  • REVIEW A ROOM – The user can review the room he is allowed only after login. This page is accessible only when the room is allocated. The review includes the description and the photo of the room. After the submission page is directed to another page from where the user can view his review and even delete it.
  • VIEW YOUR REVIEW– It keeps the track of the user’s reviews.
  • REVIEWS OF ROOMS– Before booking the room the user can view the review of various rooms.
  • COMPLAINTS– After room allotment, if the user requires to file any complaint he can register his complaint.
  • YOUR COMPLAINTS– It keeps a record of all the complaints filed by the user.

FLOWCHART

Hostel Management System Flow Chart Diagram

CONCLUSION

Till now, room allotment is done manually and physical presence is also required for the same. Students have to come a few days prior to the beginning of classes in order to select rooms. Hence this particular project deals with the problems of managing a hostel and avoids the hecticness of carrying out tasks manually.

Posted on

Students Solution an E-learning-based platform Project

The project Students Solution is a website that is an E-learning-based platform project and it will help the first-year students of B.Tech (All Branches). In this, we will build a Students Solution site. After creating the Students Solution site, you will be able to take notes for your corresponding subjects which were provided by the developers, and you are also able to practice your basic knowledge with the help of a quiz Which was in this website we also provide some blogs which were helpful to motivate students for deeper knowledge and extracurricular activities.

This technology helps you to provide the best notes on your subject bases and gives extra knowledge along with your course.

It provides a convenient solution to the traditional notes-making system. We follow a modular approach to learning through our website.

About the Project

This Students Solution project aims to make a website for first-year students of our university. This is an e-learning website where first-year students of our university will get ready-made notes. Our website “Students Solution” is to automate the existing manual system with help of ready-made notes, fulfilling first-year students’ requirements so that they can receive a valuable education. This means no need to worry about making handwritten notes. And they can utilize their time up to the maximum. It is a need for time to switch to e-learning.

Motivation

When we joined the university we faced a lot in our very first year due to a lack of proper subject material and guidance after class. So we are thinking of developing a “Students Solution” website where first-year students of our university will get all the subject notes and materials.

To help the first-year students we are working on this project “Students Solution” so that they can feel free and study well.

Objective

The main objectives of creating the Students Solution, We will provide all the notes regarding your subject and quizzes regarding that particular subject which provide you the basic knowledge of that particular subject and we will also give vlogs to fresher’s to motivate themselves for extracurricular activities.

The main objectives are :

  • To provide a quality-based education.
  • To provide ready-made notes.
  • I-Q Test

Implementation Details

Part 1: To build a Backend of the website in which notes are to be attached.
Part 2: Develop a site for quizzes regarding that particular subject.
Part 3: To build the information of developers.
Part 4: Provide vlogs to motivate students for extracurricular activities.

FUTURE PROSPECTS

  • We will add video lectures.
  • Live classes would be there.
  • We provide all the material for different disciplines.
  • The test series will be there.
  • Gaming will be there for entertainment.

Requirements

Software Requirements (Minimum):

  • Windows 10
  • Visual Code Studio
  • Xampp

TECHNOLOGY USED

  • HTML
  • CSS
  • JAVASCRIPT
  • PHP
  • MYSQL