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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!