Lab 1: Introduction

The team project

Teamwork

• Brief notes on teamwork: Peer Programming (Click the menu link at left.)
• Team Communication & Coordination Click the menu link (at left) to download this template. Together with your teammate, fill out your Contact & Communication document in MS Word.
  Each week after the Tuesday class, you will begin creating Logical and physical data models for the Thursday's class. Your goal in filling out the Team Communication Instrument is to find the earliest times when all of your teammates can meet to begin working on the task in the computer lab. The earlier the better.
  Save this document as TeamName_CommCoord.docx. (where TeamName is your, uh, team name.)

Lab 1: Introduction Deliverables

• Turn in the conceptual data model in Visio by the due time on Canvas (see the assignment on Canvas).
  
  This is an individual task for the team project. Everyone must submit a conceptual data model developed in Visio. Remember, in a conceptual data model, you only need to include Entity, including entity name and identifier, and relationships between entities. This exercise will be graded based on effort.
  Quickly read Information about SCA Data Requirements (below). Also, to gain a little understanding of a real-life "sister city" organization, spend a few minutes visiting the Bellingham Sister City Association website. Using skills and techniques you learned in MIS 320 and 321, In Visio develop a "conceptual" data model of the entities and relationships (with maximum and minimum cardinalities). Include only the "identifying attribute", but no other attributes. This exercise will help you recall the design skills you learned in MIS 321. We will evaluate the model based primarily on effort. We want you to demonstrate that you have thought carefully about this task.
  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.
• Turn in the Conatct and Communication document and the Work Record document (this one should be simple for the lab 1. If everyone has provided their contact and communication information, just enter student names in one of the student columns) online by the due time. This is a group task (see the assignment on Canvas)

Analyst's Notes on SCA Data Requirements

• 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.

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

• 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.

• 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.

• 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.

• 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.

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

End of Instructions