Example of Converting ERD to Star Schema

Step 1.

Separate the master ERD into separate business processes or units. Below is the ERD for the Contact Monitoring portion of the Bureau of Labor Statistics database.

Step 2.

Select many-to-many relationships in the ERD and identify measure-type attributes which would be in fact tables. Then designate fact tables.

Step 3.

Denormalize all remaining tables into flat tables.

Step 4

Make sure dimensions that connect to more than one fact table are conformed.