The Australian Computer Society ( ACS), organizes numerous meetings annually for its members. To ensure the success
Question:
The Australian Computer Society ( ACS), organizes numerous meetings annually for its members. To ensure the success of these meetings, ACS would like you o develop an application that supports the organizational processes. Each meeting accommodates a varying number of participants, ranging from five to 500 (sometimes even more). Moreover, each meeting occurs at a specific hotel within a particular city and state.
For effective organization, the ACS organizers require the complete names, phone numbers, and email addresses of all participants. Additionally, ACS intends to maintain general information regarding dietary restrictions for each participant. However, the restrictions must also be confirmed and recorded separately for each meeting.
In order to facilitate planning, the organizers need to know the travel arrangements of each member attending a specific meeting, including their expected arrival and departure times.
Lastly, ACS must have the capability to generate accurate reports on the number of meetings organized in a particular city or state.
Create an ERD for the above scenario that describes its business rules.
Use Crow's Foot notations and make sure to include all of the following:
- All entities correctly identified with Primary key and any foreign key attributes
- All relationships between entities correctly identified
- All M: N relationships identified and resolved
Understanding Business Ethics
ISBN: 9781506303239
3rd Edition
Authors: Peter A. Stanwick, Sarah D. Stanwick