How to convert an ER diagram to the Relational Data Model
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.