In a lively city like those in Bahrain, there's a popular app called "CityWheelsBH" that's making it easier for people to travel around. This app is a bridge between people who need a ride and those who can offer one.

Let's explore a typical day with CityWheelsBH through the experiences of some local Bahrainis:

Ali has recently begun his journey as a CityWheelsBH driver. He carefully entered his details into the app, including his name, contact number, and preferred method for receiving payments. Ali also had to show his driving license and insurance documents, important for proving he's a safe and legal driver. After each day of driving, Ali eagerly checks his rating in the app. This rating, given by the passengers he drives, tells him how well he is doing and helps him get more rides. Depending on the availability of vehicles, CityWheelsBH assigns Ali to any of the available vehicles in its inventory. Management at CityWheelsBH also keeps detailed records which of each vehicle$$s maintenance to prevent any unforeseen event. CityWheelsBH also keeps records of each of its drivers schedule for efficient ride assignment and vehicle utilization.

On the other side of the app is Fatima, who regularly uses CityWheelsBH for her daily trips. She's known for being a respectful and punctual passenger, which is reflected in her high passenger rating. Each morning, Fatima opens the app, selects her location and where she wants to go$,$ often choosing a comfortable car type like a sedan for her ride.

The system then automatically assigns drivers based on availability, proximity, and preferences using its database, updating both parties with the ride details for confirmation or cancellation. When Fatima reaches her destination, the payment for the ride is automatically made through her stored credit card details in the app. It's convenient and quick. Later, she leaves a rating and some feedback about her ride experience, which helps Ali and CityWheelsBH know about their service quality. In the evenings, Fatima sometimes browses through her past rides in the app's history section. She fondly remembers various journeys she's made, like a special trip to a friend's wedding, all facilitated by CityWheelsBH.

Hassan, another user of the app, recently had a problem with a ride. To resolve this, he used CityWheelsBH to submit a support request, describing his issue in hopes of getting it fixed. This feature is crucial in maintaining a trustworthy and reliable service for everyone.

CityWheelsBH also knows how to keep its users happy. They often release special promotions and discounts. For example, Mariam, who just started using the app, was delighted to find a promo code for a discount on her first ride.

Then there's the Al Mashaq family, who planned a family outing to a popular park. They needed more space and a child seat for their youngest member, so they chose to book a larger vehicle through CityWheelsBH. The pricing for their ride was dynamically calculated, considering factors like the larger vehicle type and the additional requirement of a child seat. This approach ensured that the Al Masherq family was charged a fair and accurate rate, tailored to their specific needs, enhancing their overall experience with both comfort and cost$-$effectiveness.

At the end of each day, the CityWheelsBH team diligently examines all the ride$-$specific feedback and ratings, as well as the general user feedback gathered throughout the day. This includes insights from the day's journeys, addressing both the performance of individual rides and the overall user experience with the app. They utilize this comprehensive feedback to enhance the service continually, ensuring it remains attuned to the evolving needs and expectations of its users.

In this vibrant city, each trip, each user's feedback, and every interaction on CityWheelsBH contributes to a larger picture. The app brings together drivers, passengers, their journeys, the payments, and the feedback in a well$-$organized system. This scenario showcases how everything works together to provide a reliable and convenient service for people in Bahrain.

Problem Statement:

You will need to design a database to be used for the back end of the above$-$mentioned mobile app. CityWheelsBH is a new startup company and do not have any infrastructure in place yet. When you design your model take into consideration the growth of the company and produce a model that is normalized.

If you discover that the data in the case study is incomplete, you are expected to add necessary assumptions. You are also expected to include suggestions that would improve the system and justify your assumptions. Decide on relevant attributes for your tables.

$$

Task $1$ and $2$ ERD Modelling

In these tasks, you must create a Context ERD $($Task $1)$ and Physical ERD $($Task $2)$ for CityWheelsBH. The designs should be presented in a report and the respective Power Architect files should also be attached.