assignments/3/question-1.puml


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44

@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>
!define unique(x) <color:green>x</color>
!define not_null(x) <u>x</u>
hide methods
hide stereotypes

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

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

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

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

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

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