Lab 6 Design:
Committee Officers

The Assignment

Design Deliverables Summary

• During Design Phase no changes are allowed to the team database.

• watch from Canvas the Lab 6 design video that discusses the conceptual data model for normalizing several tables:
  The conceptual data model are based on the following data:
  • The SCAOfficers2017-2018.xlsx Excel file
• No logical and physical data models assignment for Lab 6. Study the logical and physical data models avaliable on Canvas in the assignment L6i-DB

Analyst Notes & Deliverables Details

• Committee: A committee that is in charge of certain tasks. It has a name, meeting time, budge, etc. NOTE: this information has been captured in Lab 5
• Position: a type of job, such as secretary, treasurer, chair, etc. [Sometimes called an "office", but not by us because "office" has many other (conflicting) meanings as well.] The name of a type of position is often referred to as a "position title", a "job title", or simply a "title".
• Committee Position: a particular position on a particular committee, e.g. "Tateyama Secretary" or "Finance Co-chair". [Sometimes called an "office" or just a "position", but not by us.]
  Business rule: According to the by-laws of your sister city association, "Committee Positions must be officially authorized by the relevant committee. The approved on date should be recorded" For example, the Finance committee can authorize a new position for the Finance committee. Officially authorized positions are listed in the blue fields in the spreadsheet. (A Committee Position could also be called an "Authorized Committee Position").
• Service History: the time served by a particular person in a particular committee position. In other words, (1) who served, (2) on what committee, (3) in what position, (4) from when (5) to when? [Sometimes called "Officer Roster" or "Officer Record". We're okay with those terms too.]

End of Instructions