Question: : Your company is required to design system for Uber information system. You are required to draw the ERD as per following scenario: Store

: 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

Step by Step Solution

3.45 Rating (152 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

ERDIAGRAM OF UBER INFORMATION SYSTEM As provided in the given information the ERdiagram of the UBER ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

635dde289f617_179544.pdf

180 KBs PDF File

Word file Icon

635dde289f617_179544.docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!