Normalization in C#

Bineesh Viswanath

13y2.2kC#

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

5 Replies

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

Iftikar Hussain13y ago
Accepted 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 Hussain13y ago
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 Viswanath13y ago
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 Viswanath13y ago
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 Hussain13y ago
Hi,
Please provide your table schema (not form)

Regards,
Iftikar