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 referableification in an airport database An airport is recount by its indicate and the city that the airport locates at Each airflatten has a registration enumerate and the continuance of genesis as its cecible attributes Each airflatten design is signed by a design enumerate and has a competency and a impressiveness A technician is characterized by an ID, a indicate and a phsingle enumerate Each airport accommodates a enumerate of airflatten designs, and an airflatten design may appears in separate airports · Each airflatten is of a inequitable design, e.g. Boeing 737 A enumerate of technicians toil at the airport, yet each technician toils barely at single airport Each technician is legal ce single or over flatten designs, and single flatten design has single or over technician legal ce it Each airflatten is periodically ordealed by a enumerate of technicians. A technician may ordeal separate airplanes each year. The referableification, such as the ordeal enumerate, the ordeal continuance, the ordealing development, is required to recount a ordealing of an airplane. (5 points)

    Consider the subjoined referableification in an airport database An airport is recount by its indicate and the city that the airport locates at Each airflatten has a registration enumerate and the continuance of genesis as its cecible attributes Each airflatten design is signed by a design enumerate and has a competency and a impressiveness A technician is characterized by an ID, a indicate and a phsingle enumerate Each airport accommodates a enumerate of airflatten designs, and an airflatten design may appears in separate airports Each airflatten is of a inequitable design, e.g. Boeing 737 A enumerate of technicians toil at the airport, yet each technician toils barely at single airport Each technician is legal ce single or over flatten designs, and single flatten design has single or over technician legal ce it Each airflatten is periodically ordealed by a enumerate of technicians. A technician may ordeal separate airplanes each year. The referableification, such as the ordeal enumerate, the ordeal continuance, the ordealing development, is required to recount a ordealing of an airplane.

    Expert Confutation

     

    As you enjoy referable normal everything to do, I enjoy supposing you with the ER diagram ce the airport database as per the term supposing over. Hope this conquer succor.