Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
postgres [2012/03/28 17:14] glaroc created |
postgres [2012/04/04 17:15] (current) glaroc |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Introduction to Database Management Systems with PostgreSQL ====== | ====== Introduction to Database Management Systems with PostgreSQL ====== | ||
+ | **Many-to-many** | ||
+ | Solution: additional table with both Keys. | ||
+ | |||
+ | **Hierarchy** | ||
+ | |||
+ | **Recursive relationships** | ||
===== Exercise 1 - Import data into PostgreSQL ===== | ===== Exercise 1 - Import data into PostgreSQL ===== | ||
Line 11: | Line 17: | ||
===== Exercise 5 - Functions ===== | ===== Exercise 5 - Functions ===== | ||
+ | |||
+ | [[http://www.postgresql.org/docs/9.1/interactive/functions-math.html| Click here of a list of mathematical functions and operators]] | ||
+ | |||
===== Exercise 5 - Dealing with multiple tables ===== | ===== Exercise 5 - Dealing with multiple tables ===== | ||