Management department at Scholars University holds workshops annually in collaboration with two other universities. The department wishes to create a database with the following entities and attributes:
Faculty delivering workshop – FacultyID, Name, Email, Address (street, city, state, zip code) and Contact number
Workshop – Workshop ID, Year, Theme, Venue
Venue – LocationID, University Name, Address (street, city, state, zip code), Contact number
Participants – ParticipantID, Name, Designation, Affiliating Institute, Charges
The participating universities have come up with the following rules:
Venue rotates among the three universities, repeating every three years.
A total of 50 participants are allowed in each workshop each year on first come first serve basis.
Charges vary with designation of the participant.
Accommodation is not provided by any host and other expenses are also not entertained.
Draw an ERD for this situation.