Chapter $3$ design concepts use the database shown and figure P$3\mathrm{.}24$ to answer problems $24$ through $31.$ In chapter $3$ Ava is an aircraft carrier company that supplies on demand charter flight services using in a fleet of four aircraft aircraft are identified by unique registration registration number therefore the aircraft registration number is an appropriate primary key for the aircraft tablenumber $24$ for each table identify each of the following when possible