Vehicle Management System Project using Python and SQLite

 

The complete development of this Vehicle Management System project using Django as the backend and sqlite3 as the database. This Python project has main sections Login/Signup, Dashboard, Vehicle, Driver, Booking, Repair, and Report which are explained in the coming slides in detail.

Functions Below:

Login/Signup

Users can signup/log in to the portal with this page. It takes in the necessary fields required for the user details

Dashboard

This is the dashboard in which you can view your details is shown and the user can edit the details.

Driver

Driver Section has two pages, one is to add a driver and the other is to view the list of drivers available. This section is only visible to the users which have admin access. The Driver list has the features to search and sort lists according to the fields.

Vehicles

In this section there are two pages one is to add vehicles and the other is to list the vehicles owned by the user. On the vehicle list page, the user can view individual details, edit the details and delete the vehicle.

Booking

The booking section has four pages one is the form to book a trip the second one is the success page where the booking details including the distance, cost, and duration are displayed using google maps API. On the success page, you have the option to pay which will take you to the payment page.

The payment page lets you enter the card details to pay. There is a page to display all the bookings made by the user wherein the user can search for the bookings. The admin will have another option which is to confirm the booking and a driver will be allotted and a mail will be sent to the user saying the mail is confirmed. The map option in the booking list page displays the route using google maps API. When the admin confirms the booking a confirmation mail will be sent to the user.

Repair

The repair section has two pages, one for reporting the issue and another page to show the issues made by the user. On the issues page, the admin has an option to solve the issue made by all the users.

Report

Each user can have a report of the trips that he has made. There is an option to mail the user the report for further use. Demo Here is the live demo of our project. The quality of the gif is a bit low.

Database tables:

Vehicle Table

Owner
Cost per KM
Price
Registration Plate
Vehicle Status
Insurance Status
Total KM traveled
Fuel Type
Mileage
Vehicle Type
Image

Report Table

Registered Date
Registered User
Vehicle Mileage
Issue

Driver Table

First Name
Last Name
National ID
Address
Email
Phone Number
License Category

BookingTable

Source
Destination
Distance
Booking Date
Start Date
End Date
Security Deposit
Allotted User
Allotted Driver
Vehicle
Cost
Duration

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