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
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
Step by Step Solution
3.47 Rating (157 Votes )
There are 3 Steps involved in it
Step: 1
EntityRelationship Diagram ERD for ACS Meeting Management System Entities Participant Primary KeyParticipantID unique identifier AttributesFullNamePho...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started