Normalization in C# Windows Form Table

Question

Sir I am in a ADO.NET Project. I want the normalization SQL Server table. I attaching windows form here. Please provide the sql normalized table for this form controls.

Iftikar Hussain · Answer

Hi Here it is HouseInfo -------------- HouseId int identity (PK) HouseName 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) Regards Iftikar

Bineesh VP · Answer

Thank You Mr.Iftikar for the helping hand.