Reference no: EM133221475

Please DRAW ERD for the following situation. If you believe that you need to make non-obvious assumptions, please state them clearly.

A professional society, CAM, organizes hundreds of meetings for its members every year, and it would like to develop an application to support the organizational processes needed to ensure the success of these meetings. Each of the meetings will have five to 500 participants (sometimes even more), and each meeting takes place in a specific hotel in a specific city in a specific state. The organizers need to know each participant's full name, cell phone number, and e-mail address. CAM wants to maintain information regarding dietary restrictions for each participant at the general level, but the restrictions also need to be confirmed and recorded separately for each meeting. For each member's participation for a specific meeting, the organizers need to know how he or she will travel to the meeting and when he or she is planning to arrive and leave. It is important that CAM can produce an accurate report on how many meetings have been organized in a specific city or a specific state

Requirements

- You must provide the entities, relationships, cardinalities, all the identifiers and the attributes. Remember, primary identifiers should be bolded and underlined. - State any assumptions you believe you have to make in order to develop a complete diagram. You may add additional entities and attributes if you think they improve the ERD, but you should explain why they'd improve the solution. - This is a design exercise that involves some creative decision-making. So, there is no single correct answer. You should reflect on our class discussions on creating the most direct relationship among entities, avoiding redundant relationships, seeking clarification if the business rules are not clear, etc. - If you believe your diagram will impose some non-obvious constraints on what data can be stored, you should outline them as well