AIS is the largest Information Systems organization and organizes several academic conferences for academic individuals every year. AIS would like to develop a database to support the organizational processes of these conferences. Each CONFERENCE attracts several ACADEMICS (also known as scholars) and each of them may attend several conferences from AIS. Each conference has its unique identification code, its own title and takes place in a specific hotel. AIS needs to know each scholar’s full name, cell phone number, and e-mail address. A unique identification number is also provided to each scholar.
When an academic register [REGISTRATION] to attend a conference, Als records how he or she will travel to the meeting and the date when he or she is planning to arrive and leave. It is also important that Als produce an accurate report on how many academics from each UNIVERSITY attend the conference. For this purpose, each university name, city and state are saved. This report is important even if some universities do not send any scholar to a conference. Each university may send multiple academics or none at all.
Hint: Als is not an Entity but you need a total of four (4) tables [ENTITIES]: 3 main entities (e. g., ACADEMIC, UNIVERSITY, etc.) and 1 Associative Entity.