: Your company is required to design system for Uber information system. You are required to draw
Question:
: Your company is required to design system for Uber information system. You are required to draw the ERD as per following scenario: Store information of driver as DriverID, Driver Name, DOB, each driver can drive at least one car, but may drive more than one cars. Each car has information defined by CarID, Rego Number, Make. Each car is driven by exactly one driver. A car is registered in exactly one area. Each area can be defined by: CityID, City Name and each area can have several registered cars. A car can fulfil more than one ride defined by: RideID, Ride Date, Ride Time, Kilometres, but a car may not have fulfilled any ride. Each ride is fulfilled by exactly one car. You are required to store customer information as defined by: CustomerID, Customer Name can request more than one ride, but a customer may not have requested any ride. Each ride is requested by exactly one customer. Please identify unique identifiers for all entities
Intermediate Accounting
ISBN: 978-0324659139
11th edition
Authors: Loren A. Nikolai, John D. Bazley, Jefferson P. Jones