Question: Write a c++ program using OOP's concept onBUS RESERVATION SYSTEMthat should be able to add bus, add passenger, add route,reserve seat, remove seat, etc and
Write a c++ program using OOP's concept onBUS RESERVATION SYSTEMthat should be able to add bus, add passenger, add route,reserve seat, remove seat, etc and store them into sqlite database.
Following are the details of tables and their attributes for a Bus Reservation System:
a)Table name:Bus
Attributes:Bus Id(PK), Bus Type, Bus Registration Number, Bus Make, Bus Driver Id
b)Table name: Driver
Attributes:Driver Id(PK), Driver Name, Driver Salary, Driver Depot Id, Driver Experience
c) Table name: Route
Attributes:Route Id(PK), Bus Id(FK), Driver Id(FK), Origin, Destination, Number of Stops, Start Time, End Time
d) Table name: Reservation
Attributes:Reservation Id(PK), Passenger Id(FK), Route Id(FK), Journey Date, Boarding Point, Reservation Status, Fare
e) Table name: Passenger
Attributes:Passenger Id(PK), Passenger name, Gender, Address
Do not use array or file handling use sqlite
use SQLITE for database, use SQLITE for database, use SQLITE for database, use SQLITE for database, use SQLITE for database, use SQLITE for database, use SQLITE for database, use SQLITE for database, use SQLITE for database, use SQLITE for database, use SQLITE for database, use SQLITE for database, use SQLITE for database, use SQLITE for database
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
