Chapter $3$ design concepts use the database shown and figure P$3\mathrm{.}24$ to answer problems $24$ through $31.$ Ava Coe is an aircraft charter company that supplies on demand charter flight services using a fleet of four aircraft aircraft are identified by unique registration number therefore the aircraft registration number is an appropriate primary key for the aircraft tableanswer $24$ through $31$