Consider the EER diagram for the small AIRPORT database shown in Figure 4.12. Build this design using a data modeling tool such as ERwin or Rational Rose. Be careful how you model the category OWNER in this diagram.

Figure 4.12

Transcribed Image Text:

Salary Shift Model Capacity Weight M. WORKS ON ΕMPLOYE N PLANE_TYPE MAINTAIN Restr Lic_num M 1 FLIES PILOT OF TYPE Date Workcode Date/workcode SERVICE Hours Reg# N AIRPLANE PLANE SERVICE N Pdate STORED_IN OWNS OWNER M HANGAR CORPORATION Ssn PERSON Number Location Name Phone Name Phone Сарacity Address Address