Normalization in C#

Question

Sir, I am weak a bit in C# normalization of sql tables. I have three tables to normalize If you are wiling to do a normalization of sql table, I will upload the photos of my forms in next reply

Iftikar Hussain · Answer

Here it is ProductInfo - ProductId int identity (PK) - ProductName varchar(100) - Purchase Rate money - Sales Rate money PurchaseInfo - PurchaseId int identity (PK) - VoucherNo int - PurchaseDate datetime - PurchaseInvNo varchar(20) - VendorName varchar(100) PurchaseItemInfo - ItemId int identity (PK) - PurchaseId int (FK) - ProductId int (FK) - Quantity int - Discount money - Total money Regards, Iftikar

Iftikar Hussain · Answer

You have send me 4 form, out of these 1 form is using data from other 3 form. You can see the field information. Regards, Iftikar

Bineesh Viswanath · Answer

Ok, thank you for sending the normalized table and columns. I want to know more about this tables. let me know the followings;- 1) which are columns?( describe with why they is repeating?) 2) which are redundant,why? 3) which are dependent and independent? I asking these because I missed the class of normalization.

Bineesh Viswanath · Answer

Ok, here i uploading a rar file consisting my forms please take a look to those forms and send reply with the followings:- 1)please give the the normalized table and it's columns for all three forms. 2)guide me to create normalized table for each forms. I like to know one more from you. 3)let me know the repeating and non repeating columns of these forms please find the attached file

Iftikar Hussain · Answer

Hi, Please provide your table schema (not form) Regards, Iftikar