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 2 - Insert statement

Exercise 3 - Select statement

Exercise 4 - More advanced queries

Exercise 5 - Functions

Click here of a list of mathematical functions and operators

Exercise 5 - Dealing with multiple tables