Database Design Problem

Model the three many-to-many relationships listed below. You will need to model the classes, their attributes, and the relationship between them. Describe each class in English. Draw the class diagram, including association classes if required. Describe each association in English (both directions). Draw the relation scheme.

1. You have a list of job applicants, and a list of interviewers. Each applicant goes through multiple interviews with different interviewers, and each interviewer hosts multiple interviews with different applicants. The applicant meets with each interviewer once.

2. Developers write Technical Articles. Their Articles can be can be published in multiple Publications. Each of those Publications publish many articles.

3. A hotel tracks customer reservations and the payments made for each of those reservations. A guest can have multiple reservations under their name as well as multiple payments for their stay recorded in their name.