The ER (Entity-Relationship) model is a conceptual data model used in database design. It represents the data in terms of…