Miscellaneous
Examples
The Relations Database
Table:
PEOPLE
this table lists general characteristic of people
Person |
Sex |
YrBorn |
Nationality |
char(30) |
char(1) |
dec(4) |
Char(30) |
NOT
NULL |
NOT
NULL |
|
|
KEY |
|
|
|
Table:
FAMILY
this table lists the name of persons along with a parent
- both columns are foreign keys referencing Person in the People table
Parent |
Child |
char(30) |
char(30) |
NOT
NULL |
NOT
NULL |
KEY |
KEY |
- List people whose
father had a different nationality to them
- List Fred's Aunts
- [watch this space]
|