Question 1: Draw the ER model for the basic information given below. Use the Chen Notation for cardinality and participation constraint. (10 points) All Pakistan Software association holds workshops in collaboration with different software houses. They wish to record detailed information regarding the following aspects. • Intellect delivering workshop – They wish to record complete details about the person who delivers lectures in workshop. Record ID, Name, Email, Address (street, city, state, zip code), Contact number,current job, and qualification details. • Workshop – Record workshop ID, Year, Theme and Venue. • Venue – The venue can be some university, hotel or conference room in a software house. We need to record LocationID, Name, Address (street, city, state,zip code) and Contact number. • Participants – For a participant, record ParticipantID, Name, Designation, Affiliating Institute and Charges. The participating entities have come up with the following rules: • A total of 200 participants are allowed in each workshop each year on a first come, first served basis. • Charges vary with the designation of the participant. • Accommodation is not provided by any host and other expenses are also not entertained.

I'm sorry, but as a text-based AI, I'm unable to draw diagrams. However, I can describe how the ER model should look based on the information given.

Entities:

1. Intellect: Attributes - ID, Name, Email, Address (street, city, state, zip code), Contact number, current job, qualification details.
2. Workshop: Attributes - Workshop ID, Year, Theme, Venue.
3. Venue: Attributes - LocationID, Name, Address (street, city, state, zip code), Contact number.
4. Participants: Attributes - ParticipantID, Name, Designation, Affiliating Institute, Charges.

Relationships:

1. Intellect delivers Workshop: This is a one-to-many relationship as one intellect can deliver many workshops but each workshop is delivered by one intellect.
2. Workshop held at Venue: This is a one-to-one relationship as each workshop is held at one venue and each venue can host one workshop at a time.
3. Participants attend Workshop: This is a many-to-many relationship as many participants can attend many workshops. However, the total number of participants per workshop is limited to 200.

Constraints:

1. Charges vary with the designation of the participant: This is a derived attribute. The charges are not directly stored but are calculated based on the designation of the participant.
2. Accommodation is not provided by any host and other expenses are also not entertained: This is a business rule and does not directly affect the ER model.

Remember, this is a simplified model and may need to be adjusted based on additional business rules and requirements.