Question 1 – Entity-Relationship Diagrams
Draw an entity-relationship diagram for the following scenario. Your diagram must include
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 draw.io.
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).