Exercise

healthmodels

For this exercise you will

1. create four models with associations

2. use script/console to populate models with data and verify the associations

1. Create a new rails application called healthmodels

2. Create the models and associations shown below

Hint: To learn how to use has_one see railsbrain.com

Fund

  • name:string
  • description:text

Project

  • name:string

Location

  • name:string

Person

  • name:string

4a. Add the following data to the locations table using script/console

  • Butare
  • Byumba
  • Cyangugu
  • Gisenyi
  • Gitarama
  • Kibeho
  • Kibungo
  • Kibuye
  • Kigali
  • Nyanza
  • Ruhengeri
  • Rwamagana
  • Gikongoro
  • Gasarenda

4b. Add the following Funds and their descriptions

  • USAID
    • “The United States Agency for International Development (USAID) is the United States federal government agency primarily responsible for administering civilian foreign aid”
  • Global Fund
    • “established in January 2002 to dramatically increase global financing for interventions against the two pandemics (malaria is actually endemic). It is the largest international funder of programs to combat malaria and tuberculosis, providing two-thirds of all financing, and provides 20% of all international funding to combat HIV/AIDS. ”
  • UNICEF “
    • “The United Nations International Children’s Fund was created by the United Nations General Assembly on December 11, 1946, to provide emergency food and healthcare to children in countries that had been devastated by World War II”

4c. Add the following Projects

  • Health Systems 20/20
  • EPED

4d. Add the following People

  • Batistuta
  • Javier Zanetti
  • Lionel Messi
  • Pablo Aima
  • Cafu
  • Dida
  • Rivaldo
  • Roberto
  • Bobby Moore
  • Michael Owen
  • Steven Gerrard
  • Ryan Giggs
  • Wayne Rooney

5. Map the data below

Fund = UNICEF

Project = EPED

Location = Nyanza

People => Cafu, Dida,Rivaldo, Roberto, Bobby Moore

Fund = USAID

Project = Health Systems 20/20

Location = Byumba

People = Michael Owen, Steven Gerrard, Ryan Giggs, Wayne Rooney

Fund = Global Fund

Project = Health Systems 20/20

Location = Kigali

People = Batistuta, Javier Zanetti, Lionel Messi, Pablo Aima, Cafu, Dida, Rivaldo