Relational (OLTP) Data Modeling: Relational Data Model is a data model that views the real world as entities and relationships.…