Welcome Guest, Not a member yet? Register   Sign In
Real estate Database
#5

(This post was last modified: 11-09-2015, 04:43 AM by sintakonte.)

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 Wink

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
Reply


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



Theme © iAndrew 2016 - Forum software by © MyBB