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 10:30] glaroc |
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 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 ===== | ||