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
Step: 1
ERDIAGRAM OF UBER INFORMATION SYSTEM As provided in the given information the ERdiagram of the UBER ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Document Format ( 2 attachments)
635dde289f617_179544.pdf
180 KBs PDF File
635dde289f617_179544.docx
120 KBs Word File
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started