Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
postgres [2012/03/29 14:30] glaroc |
postgres [2012/04/04 21: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 12: | Line 18: | ||
| ===== 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]] | + | [[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 ===== | ||
