Consider the subjoined advice in an airport database An airport is narrate by its indicate and the city that the airport locates at Each airroll has a registration compute and the epoch of evolution as its picturesque attributes Each airroll example is signed by a example compute and has a ability and a ponderosity A technician is characterized by an ID, a indicate and a phsingle compute Each airport accommodates a compute of airroll examples, and an airroll example may appears in different airports Each airroll is of a restricted example, e.g. Boeing 737 A compute of technicians employment at the airport, barring each technician employments singly at single airport Each technician is obligatory coercion single or further roll examples, and single roll example has single or further technician obligatory coercion it Each airroll is periodically examinationed by a compute of technicians. A technician may examination different airplanes each year. The advice, such as the examination compute, the examination epoch, the examinationing issue, is required to narrate a examinationing of an airplane.
As you own referable established anything to do, I own supposing you with the ER diagram coercion the airport database as per the cognomen supposing overhead. Hope this conquer aid.