The core business rules of the Uber information system to draw the ERD



Question 1 – Entity-Relationship Diagrams

Draw an entity-relationship diagram for the following scenario. Your diagram must include

  • entities, attributes, relationships
  • primary & foreign keys for all entities
  • cardinality & modality for all relationships
  • A driver (defined by DriverID, Driver Name, DOB) drives at least one car (defined by CarID, Rego Number, Make), but may drive more than one car. Each car is driven by exactly one driver.
  • A car is registered in exactly one area (defined by CityID, City Name) and each area can have several registered cars.
  • A car can fulfill 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.
  • A customer (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.

as stated in the scenario. Follow the notation presented in Weeks 3 & 4. You must use software to draw your diagram, e.g., Microsoft Word/PowerPoint, LibreOffice Impress/Draw or

Paste a screenshot of your completed diagram into your Assignment Answers document.


The core business rules of the Uber information system to draw the ERD are:

-- Note: DriverID, CarID, CityID, RideID, and CustomerID are unique identifiers.

The complete diagram consists of 48 items.

An item is: an entity / an attribute / a key (primary or foreign) / a relationship / a cardinality / a modality.

For each item that is correct, you get 0.2 points. In addition, you get up to 0.4 points for presentation (that is if everything is readable and unambiguous).

Related Questions in business category

The ready solutions purchased from Library are already used solutions. Please do not submit them directly as it may lead to plagiarism. Once paid, the solution file download link will be sent to your provided email. Please either use them for learning purpose or re-write them in your own language. In case if you haven't get the email, do let us know via chat support.