Entities & Relationships
Embedded Files
Entities & Attributes
Entities & Attributes
Entities
Attributes
War
WarID, Name, Year Started, Year Ended, Outcome, Description
Battle
BattleID, Name, Date, Outcome, Description
Treaties
TreatyID, Name, Date Signed, Signatories
Casualty
CasualtyID, Killed, Wounded, Missing
Alliances
AllianceID, Name, Formation Date
Country
CountryID, Name, Government Type, Region, Population
Commander
CommanderID, Name, Rank, Birth Date, Death Date
Relationships
Relationships
1. War and Battle have many to many relationships.
2. War and Treaties have one to many relationships.
3. War and Alliances have many to one relationship.
4. Battle and Casualty have one to many relationships.
5. Battle and Country have many to one relationship.
6. Battle and Commander have one to many relationships.
7. Alliances and Country have many to one relationship.
8. Country and Commander have one to many relationships.
Page updated
Google Sites
Report abuse