i really need help ..., about normalization

hi ,

your tables are normalized form.

consider without normalization then your two table  become one table.
when you insert data into to that table duplicate entry problem, data redundancy  and at the time of selecting the data you will face problem.

thats why your table is divided in to two tables with a relation of houseid as foreign key then no duplicate values and easy to maintain data.


refer to this link for detail about normalization with example try to understand that example then you will get a clear picture how your tables are normalized.

http://www.dotnet-tricks.com/Tutorial/sqlserver/756N210512-Database-Normalization-Basics.html

hi,

as you said you have already normalized tables. plz share these table designs so i can able to make you understand your problem.

and remove the images on this page . it taking long time to load

pls explain i want to deeply dig them

hi Nizam,
Sorry for replying late to your problem in our forum. Plz share your table schema or design i will make you understand how your tables are normalized.