Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

: 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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Document Format ( 2 attachments)

PDF file Icon
635dde289f617_179544.pdf

180 KBs PDF File

Word file Icon
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

Recommended Textbook for

Intermediate Accounting

Authors: Loren A. Nikolai, John D. Bazley, Jefferson P. Jones

11th edition

978-0538467087, 9781111781262, 538467088, 1111781265, 978-0324659139

More Books

Students also viewed these Databases questions