I am coming from the asp.net - background and worked a lot with db-driven websites.

My basic question: How can I model content from a "database-centric" point of view... For example to show Appartments in a District in a City...

Like:

Table Cities:
CityID (int) primary key
City (string)

Table District:
DistrictID primary key
CityID foreign key
District (string)

Table Appartment:
AppartmentID primary
DistrictID foreign
AppartmentName
NrOfRooms
.....etc....

How would I create content types (?) to do this...