Problem
An ER diagram needs to be made using Visio
ACE Communications runs conferences for various trade organizations (customers). The conferences are generally held in a city and hotel of their customers choosing. Each conference has various sessions that the attendees of the conference can enroll in. ACE needs a database to maintain information about their customers, conferences, sessions, and attendees. The customer information would include the name of the company as well as the contact name, address information, and phone information. A customer may have employed ACE for many conferences. The conference information would include the customer, the name of the conference, the date(s) of the conference, the hotel name, and the city where the hotel is located. The session information would include the topic, the speaker(s), the room in the hotel where the session is taking place, and the date/time of the session. Each session may have more than one speaker. Keep in mind that sessions are related to a particular conference. The attendee information would include the name of the attendee and the sessions that they have enrolled in for a particular conference. Each attendee can enroll in as many sessions as they want. Some of the other goals that ACE wants to accomplish with their database include:
1) Need to know the attendees for each session at a particular conference.
2) Need to know the speakers for each session at a particular conference.
3) Need to know the speaker that each attendee has seen at any session for a particular conference.
A. Identity the obvious entities and draw them out. They are usually nouns in the requirement.
B. Fill in obvious attributes for each entity and identify primary keys.
C. Identify obvious relationships.
D. Resolve many-to-many relationships.
E. Check all relationships for links.
F. Make sure all table are in 3rd normal form.
G. Make an ER Diagram using appropriate software such as Visio.