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
|