i wanna normalize a table

Question

Safeer Safeer · Answer

plz send me the qury and storedprocedure

Iftikar Hussain · Answer

Hi Here it is HouseInfo -------------- HouseId int identity (PK) - not null HouseName varchar(100) - not null Address varchar(200) - not null PhoneNumber varchar(20) OwnersName varchar(50) - not null PersonInfo --------------- PersonId int identity (PK) - not null HouseId int (FK) - not null PersonName varchar(50) - not null Age int - not null Sex varchar(10) - not null Relation varchar(20) - not null Occupation varchar(50) Regards Iftikar