Skip to content

kwizeras/kentuckians-for-the-common-wealth

 
 

Repository files navigation

Milestone 1

Business Rules

  1. A member can belong to only one chapter, but a chapter can have one or many members.
  2. A member can attend one or many events, but an event can be attended by one or more members.
  3. A chapter can organize zero or multiple events, but an event can be organized by one or more chapters.
  4. A member can be anybody who attends an event or fills out a survey created by the chapter.
  5. A member has an engagement score that keeps track of how active or inactive they are.
  6. An engagement score can be obtained when a member attends an event or makes a donation.
  7. A donation can be in the form of monetary, equipment, or service.
  8. A chapter can have only one chapter leader at a time.
  9. A member's demographics include their race, gender, and pronouns.

Entities

1. Chapter

A chapter is a group of members in a certain geographical area who have similar interests.

Attributes:

  • Name: The name of the chapter.
  • Number of Members: The number of participants in a chapter.
  • Chapter Lead: The person who is in charge of the chapter.

2. Member

Someone who attends an event or makes a donation.

Attributes:

  • Name: The name of the member (can be first and last name).
  • ID: The identification number of the member.
  • Address: The address or mailing address of the member.
  • Phone Number: The phone number of the member.
  • Engagement Score: A metric system that keeps track of how active members are within the chapter.
  • Demographics: The demographics of the member entail things like race, gender, and pronouns.
  • Number of Events Attended: This entails the number of events attended.

3. Event

An event is a gathering that has one or more members participating.

Attributes:

  • Name: Event name (event objective).
  • Date: Date when the event took place (MM/DD/YYYY).
  • Venue: Location of the event.
  • Attendance: The number of people at the event.

ER Diagram

ER Diagram


Document Link: https://docs.google.com/document/d/1xs227zgCnU8y_3lzEl-bQvKeSdAjbs4DNt9NGn95F_c/edit

About

A Flask web tutorial using PostgreSQL, with Codespace configuration.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 51.2%
  • HTML 26.9%
  • Shell 14.7%
  • Dockerfile 6.3%
  • CSS 0.9%