Create a conceptual data using the information below. What to include in your data model.

• Carefully re-read Information about SCA Data Requirements below.
• Create the entities (only need the entity name and the identifier of the entity) you feel are needed to properly store the information needed by SCA.

Analyst's Notes on SCA Data Requirements

Membership: The Sister Cities Association wants to keep record of current memberships.

• Memberships come in several predefined types, such as Family, Student, Individual, and Corporate. Each type of membership has a different membership fee level. All memberships are for one year, beginning on the date the member joined. This database does not need to keep track of payment of membership fees. (That is done with an accounting application.) But it does need to record the basic fee for each type of membership.
• Some memberships, such as Student or Individual, are for one person only. Others, such as Family and Corporate, may include multiple people.
• The database tracks only current membership information. It does not need to be able to show how many times a person renewed his or her membership.

People: The Sister Cities Association never wants to delete a person from the database, even after that person is no longer a member. This is because the association would like to continue sending the newsletter to as many people as possible, and because they would like to be able to contact the former members to invite them to events and to do volunteer work, such as translating foreign languages or homestay hosting.

• The association would like to be able to reach people by e-mail, phone, or mail.

Languages: The Sister Cities Association often needs people who can translate or interpret foreign languages.

• The database should be able to record which people speak which foreign languages. A given person may speak more than one language. It is also important to know how well they speak each language. A scale has been set up with these predefined levels: Words and Phrases Only, Light Conversation, Fluent Foreign Speaker, Native Speaker, and Professional Translator. A person might be Words and Phrases Only in one language and Native Speaker in another. If a person is listed as speaking a language, the fluency level must be recorded as well. Of course, a person's own native language should be listed, even if the person speaks no other languages.

Committees: The Sister Cities Association is composed of numerous committees. There are two basic types of committees: “City” and “Support.”

• The city committees are linked to exactly one sister city. For example, the Cheungju Committee is responsible for only the Cheungju sister city relationship.
• The support committees have functional duties, such as Programs, Membership or Finance. They serve all sister cities and are therefore not linked to any particular sister city.

Cities: The Sister Cities Association has seven sister cities: Tateyama, Japan; Port Stephens, Australia; Nakhodka, Russia; Punta Arenas, Chile; Cheungju, Korea; Vaasa, Finland; and Tsetserleg, Mongolia. The association would like to be able to display basic information about the sister cities on its Website. This information will be stored in the database and read by the Web page application. The information includes the name and country of the sister city, the population, the name of the mayor, a description of the city, and a link to the sister city’s Web site.

Events: Sister city events will also be listed on the Website.

• An event may consist of multiple activities which take place on different days or times at different locations. For example, the annual Ski to Sea competition includes the arrival of a sister city team, a welcome party for the team, a tour of the race course, the Ski to Sea Parade, the race itself and the departure of the sister city team. All activities are listed as the Ski to Sea event, but each occurs at a different place and time.
• At least one committee must be assigned responsibility for an event.
• Throughout the year, a given committee may be responsible for several events.

Volunteers: People can volunteer in a variety of ways. The association would like to define and record specific types of volunteer activities so it can easily search for people who fill common needs, such as providing local transportation for sister city guests or hosting foreign guests at their homes (this is called a "homestay").

• The pre-defined volunteer categories are:
  • Homestay Host
  • Reception Host
  • Local Guide
  • Local Transportation
  • Interpreting/Translating
  • Sister city Center Volunteer Staff
  • Unspecified
• A person may volunteer in many categories.
• Many people may volunteer in a given category.
• The association wants to record only who is willing to volunteer. No history is kept of who actually has been a homestay host or an interpreter.

Officers: The Sister City Association would like to keep track of current and past officers.

• Each committee has a set of officers. Some sample offices include chair, co-chair, publicity, secretary, treasurer, and programs.

Answer rating: 100% (QA)

The entities that should be included in the data model for the Sister Cities Association SCA Members... View the full answer