The sample source data shown in the table below provides the information about employees, their residential state, county, city and…
Relational (OLTP) Data Modeling: Relational Data Model is a data model that views the real world as entities and relationships.…