#Entity Sets

officer (officer _id, officer _name, officer_contact height,weight)

weapons (weapon_id, weapon_name, type, mode)

command(command_name, headquarter)

war(war_name ,war_year)

award(award_name, awarding_year)

Two officer entity sets: airmen and health_officer common attribute - officer _id airmen(rank, sector) health_officer (specialization)

#Relationship Sets

belongs 1:N command with officer, both total

uses M:N airmen with weapons, airmen partial, weapons total

participates M:N airmen with war airmen total, war partial

is awarded M:N officers with award, officers total, reward partial

#Relational Model-Schema

officer (officer _id, officer _name, officer_contact, height, weight, c_name*)

weapons (weapon_id, weapon_name, type, mode)

command(command_name, headquarter)

war(war_name ,war_year)

award(award_name, awarding_year)

participates(officer_id*, war_name*)

is rewarded(officer_id* ,award_name*)

uses(officer_id* ,weapon_id*)

airmen(officer_id, rank, sector)

health_officer (officer_id, specialization)