Bus Pass Management System - DBMS Mini Project (VTU - Vth semester)

The "Bus Pass Management System" is developed and implemented using Java and MySQL database.

1️⃣ Introduction

Bus Pass Management System used to store all the data of the student who are enrolling for bus pass. It has made work faster and easier for the university, that the staff of the college working in this department can get the details of the student who are enrolling for college bus pass in very efficient manner. Whenever an administrator enters the Bus Pass system it shows the basic information like Drivers Records, Vehicles Records, boarding point records, students who have registered records. The software is used to store the data most securely and in proper arrangement way This is even help to store all the relevant data about students boarding point details and it generates a bus pass card for the student automatically

2️⃣ Architecture Diagram

3️⃣ Prerequisites

Hardware Specification
✔ Processor : Intel(R) Core(TM) i5-8265U CPU @ 1.60GHz 1.80 GHz
✔ RAM : 8.00 GB
✔ Hard Disk : 1TB
✔ Input Device : Standard keyboard and Mouse
✔ Output Device : Monitor

Software Specification
✔ Database : MySQL 8.0
✔ Programming language : Java jdk-20
✔ IDE : Apache Netbeans

4️⃣ Steps

Step 1: Install MySQL and Apache Netbeans or any other suitable IDE.

Step 2: Create a New Database Navigate to the "Databases" tab. Enter a name for your new database in the "Create database" field, i.e, "bpms"

Step 3: Establish a Connection to the Database using JDBC connection.

Step 4: Design Tables and Relationships - Click on "Create Table" to define the structure of the tables. Specify the columns, data types, and constraints for each table.

Step 5: Insert data after creating the tables.

Step 6: Write SQL Queries to perform various operations like data retrieval, insertion, and updates.

Step 7: Test the Application.

5️⃣ Output