Loading

Normalization in C# Windows Form Table

Bineesh Viswanath

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
Accepted 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 Viswanath13y ago
Thank You Mr.Iftikar for the helping hand.