Re: 3 value logic. Why is SQL so special?

JOG wrote:
Paul wrote:
"JOG" <jog@xxxxxxxxxxxxx> wrote:
...
The illogic of using nulls has been covered to death in the literature.
Surely you ought have read it given your job?
...

Right. If I may go further, if a single 'table' is seen as desireable for some reason, AFAIAC, actual departure time can be safely deemed to be equal to estimated departure time until the biz rules dictate that a plane has departed. I say 'biz rules' because the purpose of the system should dictate interpretation, not the viewpoint of an objective observer. I don't think this violates any RM principle.

Some misconceived queries might use actual departure time to determine that a flight has departed (note the word 'flight' as opposed to 'airplane', this is a common abstraction in the airline biz', one of the few that makes sense, along with 'flight segment'), but the writers of those queries should think twice, assuming that the purposes of the schema have been explained to them. After all is said and done, a schema is an arbitrary abstraction, the fact that this is so is what allows us to make systems that are models of other systems.

p
.

Relevant Pages

  • Hide all controls inside another control
    ... controls in them and just display the appropriate one based on a value on the ... IE if this was a direct flight I would display the box with just the ... original flight number departure time, arrival time at connecting aiport, ...
    (microsoft.public.access.forms)
  • Re: program
    ... >> Prompt the user to type in the hour and minute departure time for an ... >> Calculate the total number of minutes the flight will be in the air. ... >> Display the departure time, the arrival time, and the flight time (in ... Robbing banks is much more difficult than programming. ...
    (comp.lang.java.programmer)
  • Re: European trip ?s
    ... >> The last time I flew on a ticket from a consolidator, the departure time of ... >> the flight was moved back, ... > Would you have expected it to be any different had you bought the ticket ... Which airline anyway? ...
    (rec.travel.europe)
  • Re: Suvarnabhumi Transfer
    ... "googling" this information re Bangkok Airport. ... Can anyone tell me if 2.5 hours from landing time to departure time is ... Asia flight BKK to Chiang Mai. ...
    (rec.travel.asia)