Tag: cartesian product
Cartesian product or Kronecker product?
I am continuing to work my way through A. K. Dewdney‘s New Turing Omnibus – some bits are very familiar and not so interesting, but there are lots of fascinating parts and it is another book I wish I’d read two years ago, before I started the MSc. (Update: you may want to read this).…
LaTeX symbol for the cartesian product
Lots of people come here looking for this, so I might as well oblige. In mathmode the code is \times. Giving In textmode try: \texttimes (LaTeX Companion book).
Let’s try that again, shall we?
This query works for the previously mentioned SQL problem: SELECT K.BATTLE FROM (SELECT S.name AS SHIP, B.name AS BATTLE, C.country AS COUNTRY FROM Ships S, Classes C, Battles B, Outcomes O WHERE S.class = C.class AND O.battle = B.name AND O.ship = S.name) K CROSS JOIN (SELECT S.name AS SHIP, B.name AS BATTLE, C.country AS…
Solving a relational query: part 5
Found: the relational algebra to tackle the problem outlined in part 3. This is based on a solution to a similar problem found in Database Management Systems, Third Edition, though, unfortunately, that book prints a solution that is not relational algebra at all, as it relies on the order in which results are returned (relational…