Analysis of Data and creating Tables & Relationships: Usually in a data model, Tables (Entities) looks like rectangular or square type…