# A Framework of Vehicle Usage Optimization for Tour Purposes
## 5 Methodology
### Database Model
For Route 2 in \(K\) city: \(PK(2)+=PC(3)=1+2=3\). For Route 3 in \(K\) city: \(PK(3)+=PC(1)=3+5=8\). **Step 7:** Update the passenger list \(PC\):

For Route 1 in \(K\) city: \(PC(3)-=SK=2-4=-2\) (assuming negative values represent no passengers). For Route 2 in \(K\) city: \(PC(3)-=SK=2-4=-2\). For Route 3 in \(K\) city: \(PC(1)-=SK=5-4=1\). The updated matrices would be:

\[ \begin{split} PC&=\begin{bmatrix}0&0&1\end{bmatrix}\\ PK&=\begin{bmatrix}4&3&8\end{bmatrix}\end{split} \]

## 6 Experimental Analysis

We conduct the experiments and execute HTML, CSS, the Tailwind Framework, React, and Node.js in different software to successfully run our website. By using this language, we design our front-end and back-end design. This website includes package options for tourists, blogs, booking options, etc. For the purpose of our experiment, we set an optimization option on our website. Here, we show the final result of our website. ### Result

In this section, we show some UI designs of our website. Here, we find both the user page and the admin page Table 4. First, we will describe the user page of the UI design in a tabular form. Then, we will show the admin page as a picture. Using this interface, the admin can optimize the bus for every city. Moreover, here, we mention the seat number, tourist list with their destination, and payment status. The admin can also see the navigation bar, search option, and notification option on this page (Figure 3). \begin{table}
\begin{tabular}{p{142.3 pt} p{142.3 pt}} \hline \hline
**Name of Feature in User Page** & **Short Description** \\ \hline Navigation Bar & In this section, we provide our software name and logo. Additionally, this includes the home, profile, package, blog, and about us pages. We also mention the search option and notification option. \\ \hline Slider & Here, users see the book option. Tourists can book their tour by clicking here. \\ \hline Package & In this section, we mention all of the blogs of tourist spots. Users can see the package details by clicking this option. They can also book their tour by clicking “Book Your”. \\ \hline Blog & Users can see the blog of tour spot details. They can also book their tour by clicking “Book Your”. \\ \hline Payment & When users want to book a package, they should pay some amount as advance payment. \\ \hline \hline \end{tabular}
\end{table} 
Table 4: Tabular form of the user page. ## 7 Performance Evaluation

The methodology section discusses the database and mathematical models with a matrix. We have implemented our project in these two ways, but we have decided on an efficient approach for the final work. A database model is an efficient approach from our side. A database model is efficient for our project because it allows for the organization, storage, and retrieval of large amounts of data related to the project, which can be difficult to manage with a mathematical model alone. A mathematical model may be useful for analyzing and optimizing specific aspects of the project, such as the routing or scheduling of vehicles. However, a mathematical model relies on limited input data, assumptions, and simplifications to make predictions and recommendations. This can make it challenging to incorporate all relevant factors and real-world complexities affecting vehicle usage for tour purposes, such as traffic patterns, weather conditions, and customer preferences. On the other hand, a database model can store and integrate a wide range of data sources and variables related to the project, including customer profiles, vehicle capacities, and availability. This can enable a more comprehensive and accurate analysis of vehicle usage factors and generate custom reports and insights based on specific user queries. In addition, a database model can allow for greater flexibility and scalability in managing and updating project data over time. New data sources and variables can be added as needed, and data can be easily modified or deleted as circumstances change.