Spot checking assignment #4


Here are some checks to confirm that you did assignment #4 correctly:

  1. You should have exactly 42 pilots in your database (this includes the five from assignment #2).

    • Exactly nine of these pilots should be certified to fly the Millenium Falcon.
    • Four pilots should be certified to fly a colonial Viper.
    • Only two pilots should be certified on the U.S.S. Enterprise.
  2. There should be exactly ten regularly scheduled flights servicing planet Vulcan, either departing from, or arriving at, that planet.
  3. The earliest flight (where “earliest” means “the earliest date”) to Centauri Prime in your database should have had exactly 51 passengers, while the latest flight to this planet has only 5 so far.
  4. Exactly one of the scheduled flights should be sold out. The other 600 scheduled flights should have (or did have, at the time) tickets still available for purchase. (Note that this 600 figure includes the five flights scheduled in assignment #2.)


If all these check out, I think it’s pretty darn likely that your bulk import was successful.