Bobs taxi management company provides management services


Please draw ERD diagram with Crow's Foot Model.

Bob's taxi management company provides management services to several independent taxi companies in a large city. You have been asked to make a database to help manage these companies' fleet of cars and drivers. Given the following business rules, create the appropriate ER Diagram for each of the specified relationships. NOTE: This should be one diagram, not a separate one for each business rule. You must include all relationships, connectivity and cardinalities.

  • A taxicab company can own up to 10 cabs
  • To maximize profit 2 drivers may be assigned to each taxi.
  • Each driver is only assigned to one taxi
  • Each of the taxis may or may not (yet) have a maintenance record
  • Each of the drivers may or may not have a driving history

Solution Preview :

Prepared by a verified Expert
Basic Computer Science: Bobs taxi management company provides management services
Reference No:- TGS02344160

Now Priced at $10 (50% Discount)

Recommended (98%)

Rated (4.3/5)