Relational | Dimensional Data Modeling: Relational Data Modeling is used in OLTP systems which are transaction oriented and Dimensional Data…