I am creating a real estate database, and it seems that I am doing something wrong, because I have several cycles in my design. is it OK or do I need to redesign the entire database schema?
Here is my current diagram:
There is nothing wrong with loops in database design. Sometimes you need to move data in several directions.
Whether this is a suitable model for your application and the needs of the application is a much more complex question that cannot be answered without complete information about the application and its needs.
, . (, "" 1 1).
, - . .
, , . ?
, . TownRegion, TownRegion , , , , ( ).
- , TownRegion, . , , , .
This is a slightly older post here, but I decided that I should mention this.