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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!