¼Ùé¨Ñ´·Ó              Ẻ½Ö¡ËÑ´              à©ÅÂẺ½Ö¡ËÑ´              HOME

à©ÅÂ

  1.  (1,2,3), (1,2,4) , (1,3,4)  áÅÐ R = (2,3,4)
  2. 4-tuples (1,1,2,3), (1,2,1,3)
  3. (Nadir,122,34,Detroit,08:10)

    4. (Acme,221,22,Denver,08:17)
    (Acme,122,33,Anchorage,08:22)
    (Acme,323,34,Honolulu,08:30)
    (Nadir,199,13,Detroit,08:47)
    (Acme,222,22,Denver,09:10)
    (Nadir,322,34,Detroit,09:44)
  4. Primary key ¢Í§ Table 3 ¤×Í Course

    5. Primary key ¢Í§ Table 5 ¤×Í Course Number
    Primary key ¢Í§ Table 6 ¤×Í Course Number
    Primary key ¢Í§ Table 8 ¤×Í Departure Time
  5. ä´éá¡è Airline áÅÐ Flight Number ¡Ñº Airline ¡Ñº  departure time
  6. ¼ÅÅѾ¸ì¤×Í (b,c,e)
  7. Projection P3,5,6 ¢Í§ 6-tuples
Airline Flight Number Destination
Nadir 122 Detroit
Acme 221 Denver
Acme 122 Anchorage
Acme 323 Honolulu
Nadir 199 Detroit
Acme 222 Denver
Nadir 322 Detroit

9.
 
Airline Destination
Acme Denver
Acme Anchorage
Acme Honolulu
Nadir Detroit

  1. ÁÕ 10 Êèǹ ä´é¨Ò¡ (3+8-10)=10
11.
 
Part Number Project Quantity Color Code  Supplier
1001 1 14 8 33
1092 1 2 2 23
1101 3 1 1 23
3477 2 25 2 31
4975 3 6 2 31
6984 4 10 1 32
9048 4 12 2 23
9191 2 80 4 32