Methodik: Analysieren > Hypothese bilden > Query bauen.
| id (PK) | name | city | job |
|---|---|---|---|
| 1 | John Doe | London | Banker |
| 2 | Pierre Dubois | Paris | Artist |
| 5 | Hans Gruber | Berlin | Ex-Military |
| ... 850 weitere Einträge ... | |||
| id (PK) | person_id (FK) | origin | destination | time |
|---|---|---|---|---|
| 101 | 1 | London | Paris | 2014-10-22 14:00 |
| 102 | 5 | Berlin | Paris | 2014-10-21 09:30 |
| 103 | 9 | NY | Tokyo | 2014-10-23 18:00 |
| ... 12.400 weitere Einträge ... | ||||
| id (PK) | person_id (FK) | provider | type |
|---|---|---|---|
| 998877 | 1 | Vodafone | Private |
| 112233 | 5 | Telekom | Prepaid |
| 445566 | 2 | Orange | Business |
| id (PK) | sender (FK) | receiver (FK) | sent | message_text |
|---|---|---|---|---|
| 5001 | 112233 | 998877 | 2014-10-23 23:15 | The package is ready. |
| 5002 | 998877 | 112233 | 2014-10-23 23:16 | OK. Coming. |
| 5003 | 445566 | 112233 | 2014-10-20 10:00 | Lunch tomorrow? |
...
...