As we continue our consulting work, we are approached by an entrepreneur starting a ride-sharing platform to compete with the likes of Uber and Lyft but within a very niche geographical market. The entrepreneur has already designed the conceptual model containing what his team considers important for operational success but wants our help to implement the database. As such our job is to:

GOAL: Transform the conceptual model we were presented into a logical model so that we can proceed with the implementation at a later date.

The conceptual model presented to us is found below. Please use the transformation rules discussed in class to convert it into an appropriate logical model making sure it matches the conceptual model presented to us.

Make sure that:

1. All necessary tables are recorded.
2. You properly identify the PKs of each table.
3. You properly identify the FKs of each table.
4. Record the lines and arrows (pointing in the proper direction) that connect these tables.

PASSENGER PK Driver Name TRIP LOCATION PK Trip ID PK Trip Start_Time End Time Address Price DRIVER PK Driver D Name