Real estate Database |
i think this table names are not really intuitive especially with your illustration
i would prefer your first attempt because we don't have to much to fix here ![]() your proprietati table need an adress id not an zone id because if you just know the zone you don't know which address it is take zone -> strazi -> adrese and in proprietati make an id_adresa as relational field the other thing which comes to mind is your strazi table; if you use one extra table for streets - you should think about a junction table between streets and zones because if your db grows you avoid duplicate street names i don't understand the 2nd attempt at all - to much duplication |
Messages In This Thread |
Real estate Database - by sebastianvirlan - 11-06-2015, 12:36 AM
RE: Real estate Database - by PaulD - 11-06-2015, 07:26 PM
RE: Real estate Database - by solidcodes - 11-06-2015, 08:14 PM
RE: Real estate Database - by sebastianvirlan - 11-09-2015, 12:47 AM
RE: Real estate Database - by sintakonte - 11-09-2015, 04:41 AM
RE: Real estate Database - by sebastianvirlan - 12-07-2015, 07:24 AM
|