Lecture 8 - Relational algebra - annotated

Lecture 8 - Relational algebra - annotated - Section...

Info icon This preview shows pages 1–4. Sign up to view the full content.

1 Relational algebra INFO/COM S 230: Intermediate Web Design and Programming Section Friday’s section (in part): How to install and configure Apache, PHP, and MySQL. You may want to bring your laptop. Brief review of relational DBs Last time we introduced relations and relational DBs. 201 mins. 2003 The Return of the King 113 mins. 2002 Chicago 2004 2001 2000 Year Length Title 132 mins. Million Dollar Baby 135 mins. A Beautiful Mind 155 mins. Gladiator Year Title Name 2004 Million Dollar Baby Hillary Swank 2003 Return of the King Viggo Mortensen 2001 A Beautiful Mind Russell Crowe 2000 Gladiator Russell Crowe Getting info out of a DB Today: Given a relational DB, how do we extract information that we want? E.g. What sort of questions (queries) might we ask of a movie DB? Algebra “Regular” algebra: variables (e.g. x, y, z) and constants (e.g. 1, 2, 5) combined via operators (e.g. +, -, *) (3 x + 2) * 4 z If all constants and variables stand for integers, and have operators +, -, *, the result of applying operators will always be a Easy PDF Creator is professional software to create PDF. If you wish to remove this line, buy it now.
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.