News for hackers. Stuff that matters.
Re:What the Heck is a Relation? From Tables to Cartesian Pro... by chris_wot on Thursday December 26, 2013 @12:20AM (#6965339)
You have the following material implications:

    EMPLOYEE(Daniel Smith, Marketing)  →  TRUE
    EMPLOYEE(Jebediah Vargas, Marketing)  →  FALSE
However, if the employee name in the function is not Daniel Smith but the employee is in marketing, the first predicate is true. How does that fit into relational databases?

P.S. Great article!

Re:What the Heck is a Relation? From Tables to Cartesian Pro... by siddboots on Thursday December 26, 2013 @02:07AM (#6965500)
The arrow notation here is not material implication, but function evaluation. The function itself can be interpreted as an Indicator Function[1] for the employee set, or alternatively, as simply evaluating the predicate.

In terms of tables, the rows are exactly the subset of predicates that are TRUE. So FALSE statements like the second one are indicated by their absence in the employee table.

[1] http://en.wikipedia.org/wiki/Indicator_function

Re:What the Heck is a Relation? From Tables to Cartesian Pro... by chris_wot on Thursday December 26, 2013 @06:42PM (#6968671)
Thanks! I had no idea