tables
what’s in a relational database
- an RDB consists of a collection of tables or relations
- each table has a name
- columns have names too (called attributes)
- each row is a sequence of values one for each column
these may be numbers, booleans, strings, etc
- rows are also called tuples or records
example
- EVENTS table
EVENT CAFEMEISTER HOURS
java-jump ben 10
tour-de-café alice 15
seattle-sleepless carol 8
- ATHLETES table
NAME SPONSOR
alice coffee-connection
ben starbucks
carol green-mountain