Management department at scholars university holds


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.

Request for Solution File

Ask an Expert for Answer!!
Operation Management: Management department at scholars university holds
Reference No:- TGS01627967

Expected delivery within 24 Hours