The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Jul 2017 |
| Last Sign in: | 304 Weeks Ago, 4 Days Ago |
| Questions Answered: | 15833 |
| Tutorials Posted: | 15827 |
MBA,PHD, Juris Doctor
Strayer,Devery,Harvard University
Mar-1995 - Mar-2002
Manager Planning
WalMart
Mar-2001 - Feb-2009
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
----------- Â ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly