Homework Solution: Consider the following information in an airport database An airport is describe by its name and…

    5. Consider the following information in an airport database An airport is describe by its name and the city that the airport locates at Each airplane has a registration number and the date of production as its descriptive attributes Each airplane model is identified by a model number and has a capacity and a weight A technician is characterized by an ID, a name and a phone number Each airport accommodates a number of airplane models, and an airplane model may appears in several airports · Each airplane is of a specific model, e.g. Boeing 737 A number of technicians work at the airport, but each technician works only at one airport Each technician is responsible for one or more plane models, and one plane model has one or more technician responsible for it Each airplane is periodically tested by a number of technicians. A technician may test several airplanes each year. The information, such as the test number, the test date, the testing result, is required to describe a testing of an airplane. (5 points)
    Consider the following information in an airport database An airport is describe by its name and the city that the airport locates at Each airplane has a registration number and the date of production as its descriptive attributes Each airplane model is identified by a model number and has a capacity and a weight A technician is characterized by an ID, a name and a phone number Each airport accommodates a number of airplane models, and an airplane model may appears in several airports Each airplane is of a specific model, e.g. Boeing 737 A number of technicians work at the airport, but each technician works only at one airport Each technician is responsible for one or more plane models, and one plane model has one or more technician responsible for it Each airplane is periodically tested by a number of technicians. A technician may test several airplanes each year. The information, such as the test number, the test date, the testing result, is required to describe a testing of an airplane.

    Expert Answer

     
    As you have not stated anything to do, I have provided you with the ER d

    5. 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. (5 points)

    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.

    Expert Reply

     

    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.