i really need help ... about normalization

Question

i want know about normalization .... here is the form i put it down
i have got the normalized table but stil i don't know .., how it's each column normalised... please anyone help me and breifly explain the each text box and the column.... i hope you guys can
i am waiting ur response .

Sanjeeb Lenka · Answer

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

Safeer Safeer · Answer

u only gave it to this normalized table ...

Safeer Safeer · Answer

HouseInfo -------------- HouseId int identity (PK) HouseNo varchar(100) Address varchar(200) PhoneNumber varchar(20) OwnersName varchar(50) PersonInfo --------------- PersonId int identity (PK) HouseId int (FK) PersonName varchar(50) Age int Sex varchar(10) Relation varchar(20) Occupation varchar(50)

Sanjeeb Lenka · Answer

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

Safeer Safeer · Answer

explain simply and each part of

Safeer Safeer · Answer

pls explain i want to deeply dig them

Safeer Safeer · Answer

here it is that family registration ... form

Sanjeeb Lenka · Answer

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.

i really need help ..., about normalization