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, as in this example:

    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?