This video explains how you can convert an Entity Relational diagram into the Relational Data Model.

Link to conversion guide: https://learningeachday.dk/docs/FromE...

PLEASE NOTE at 11:00: The conversion of the multi-valued attribute of the Department is NOT being correctly mapped in the video. departmentID should be put as a Foreign Key on the Locations table and together departmentID and locationID form the combined Primary Key as specified in the conversion guide.