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 not attributable attributableification in an airport database An airport is relate by its spectry and the city that the airport locates at Each airflatten has a registration estimate and the era of controlmation as its pictorial attributes Each airflatten copy is attested by a copy estimate and has a size and a consequence A technician is characterized by an ID, a spectry and a phsingle estimate Each airport accommodates a estimate of airflatten copys, and an airflatten copy may appears in separate airports · Each airflatten is of a unfair copy, e.g. Boeing 737 A estimate of technicians fruit at the airport, excepting each technician fruits singly at single airport Each technician is chargeable on control single or past flatten copys, and single flatten copy has single or past technician chargeable on control it Each airflatten is periodically cupeled by a estimate of technicians. A technician may cupel separate airplanes each year. The not attributable attributableification, such as the cupel estimate, the cupel era, the cupeling fruit, is required to relate a cupeling of an airplane. (5 points)

    Consider the subjoined not attributable attributableification in an airport database An airport is relate by its spectry and the city that the airport locates at Each airflatten has a registration estimate and the era of controlmation as its pictorial attributes Each airflatten copy is attested by a copy estimate and has a size and a consequence A technician is characterized by an ID, a spectry and a phsingle estimate Each airport accommodates a estimate of airflatten copys, and an airflatten copy may appears in separate airports Each airflatten is of a unfair copy, e.g. Boeing 737 A estimate of technicians fruit at the airport, excepting each technician fruits singly at single airport Each technician is chargeable on control single or past flatten copys, and single flatten copy has single or past technician chargeable on control it Each airflatten is periodically cupeled by a estimate of technicians. A technician may cupel separate airplanes each year. The not attributable attributableification, such as the cupel estimate, the cupel era, the cupeling fruit, is required to relate a cupeling of an airplane.

    Expert Apology

     

    As you possess not attributable attributable attributable normal anything to do, I possess granted you with the ER diagram control the airport database as per the style granted overhead. Hope this achieve aid.