@startuml
!define Table(name,desc) class name as "desc" << (T,#FFAAAA) >>
!define primary_key(x) <b>x</b>
!define foreign_key(x) <color:purple>x</color>
hide methods
hide stereotypes

' entities
Table(facts, "FactTable") {
  foreign_key(member_ID)
  foreign_key(Item_ID)
  foreign_key(Office_ID)
  foreign_key(Policy_ID)
  foreign_key(Period_ID)
  foreign_key(Claim_ID)
  Policy_Premium
  Deductible
  Monthly_Claim_Total
}

Table(members, "Member") {
  primary_key(member_ID)
  Name
  Address
}

Table(insured_items, "InsuredItem") {
  primary_key(Item_ID)
  Description
  Address
  CoverageType
}

Table(coop_offices, "CoopOffice") {
  primary_key(Office_ID)
  Address
  Manager_name
}

Table(policies, "Policy") {
  primary_key(Policy_ID)
  Type
}

Table(periods, "Period") {
  primary_key(Period_ID)
  Date_Key
  Fiscal_Period
}

Table(claims, "Claim") {
  primary_key(Claim_ID)
  Claim_Description
  Claim_Type
}

members --> facts : "belongs to"
insured_items --> facts : "belongs to"
coop_offices --> facts : "belongs to"
policies --> facts : "belongs to"
periods --> facts : "belongs to"
claims --> facts : "belongs to"
@enduml