Navi Mumbai Municipal Transport (NMMT) runs different types of buses between sources and destinations. Fare change for different types of buses. Passengers buy tickets and pay by different payment modes. Construct ER-Diagram for new ticketing system for NMMT. (Assume suitable data if required)

ER Diagram for New Ticket System for NMMT

The above Ticket System for NMMT contains the following Entities and attributes:

Entity - Passenger

Attributes of Passenger – p_id, p_name, p_age, p_pass, p_add, and p_no.

Primary Key – p_id

Entity – Payment

Attributes of Payment – id, p_mode, p_date, and p_amount …