Schema

The D-Day Invasion Schema

Summary of Key Relationships

treaties to signatories: treaty_id -> treaty_id

signatories to country: country_id -> country_id

war to battle: war_id -> war_id

battle to casualty: battle_id -> battle_id

alliances to member: alliance_id -> alliance_id

member to country: country_id -> country_id

provide: country_id -> country_id, commander_id -> commander_id

Treaties Table

1NF: Satisfied (atomic values, primary key present).

2NF: Satisfied (single attribute primary key, all columns depend on it).

3NF: Satisfied (no transitive dependencies).

Signatories Table

1NF: Satisfied (atomic values, primary key present).

2NF: Satisfied (single attribute primary key, all columns depend on it).

3NF: Satisfied (no transitive dependencies).

War Table

1NF: Satisfied (atomic values, primary key present).

2NF: Satisfied (single attribute primary key, all columns depend on it).

3NF: Satisfied (no transitive dependencies).

Battle Table

1NF: Satisfied (atomic values, primary key present).

2NF: Satisfied (single attribute primary key, all columns depend on it).

3NF: Satisfied (no transitive dependencies).

Casualty Table

1NF: Satisfied (atomic values, primary key present).

2NF: Satisfied (single attribute primary key, all columns depend on it).

3NF: Satisfied (no transitive dependencies).

Alliances Table

1NF: Satisfied (atomic values, primary key present).

2NF: Satisfied (single attribute primary key, all columns depend on it).

3NF: Satisfied (no transitive dependencies).

Country Table

1NF: Satisfied (atomic values, primary key present).

2NF: Satisfied (single attribute primary key, all columns depend on it).

3NF: Satisfied (no transitive dependencies).

Member Table

1NF: Satisfied (atomic values, primary key present).

2NF: Satisfied (single attribute primary key, all columns depend on it).

3NF: Satisfied (no transitive dependencies).

Commander Table

1NF: Satisfied (atomic values, primary key present).

2NF: Satisfied (single attribute primary key, all columns depend on it).

3NF: Satisfied (no transitive dependencies).

Provide Table

1NF: Satisfied (atomic values, primary key present).

2NF: Satisfied (single attribute primary key, all columns depend on it).

3NF: Satisfied (no transitive dependencies).

Participate Table

1NF: Satisfied (atomic values, primary key present).

2NF: Satisfied (single attribute primary key, all columns depend on it).

3NF: Satisfied (no transitive dependencies).

Located Table

1NF: Satisfied (atomic values, primary key present).

2NF: Satisfied (single attribute primary key, all columns depend on it).

3NF: Satisfied (no transitive dependencies).

Endure Table

1NF: Satisfied (atomic values, primary key present).

2NF: Satisfied (single attribute primary key, all columns depend on it).

3NF: Satisfied (no transitive dependencies).

Page updated

Google Sites

Report abuse