Question: Draw an ERD for this database situation below: Management department at Scholars University holds workshops annually in collaboration with two other universities. The department wishes
Draw an ERD for this database situation below: 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: 1- Faculty delivering workshop: ( FacultyID, Name, Email, Address (street, city, state, zip code) and Contact number). 2- Workshop : (Workshop ID, Year, Theme, Venue) 3- Venue : (LocationID, University Name, Address (street, city, state, zip code), Contact number) 4- 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.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
