Normalisation - BCNF, 4NF and 5NF (Normal Form)
Hello People,
Does anyone have “normalisation” (BCNF, 4 and 5 NF) expertise?
I’ve Normalised my data to 3NF, and I’m having difficulty Normalising to it to BCNF, 4NF and 5NF. Can anyone help Normalise my data?
Below is the data upto 3NF.
-3NF-
(The data with the underscore(__) next to them are Candidate keys)
__Memcode__
Name
Address
Title
Sex
Dob
__Occupation__
Occupation
__Category__
Address
Region
__Memcode__
__Subject__
Num-sent
Num-replied
__Offercode__
Title
Subject
__OfferCode__
__Date__
Price
Num-sold
__OfferCode__
__Date__
__Target-category__
__Age-group__
__Target-region__
__Suppcode__
Name
Address
Phoneno
__Itemcode__
Description
__Offercode__
__Itemcode__
__Qty__
__Offercode__
__Itemcode__
__Suppcode__
Hello People,
Does anyone have “normalisation” (BCNF, 4 and 5 NF) expertise?
I’ve Normalised my data to 3NF, and I’m having difficulty Normalising to it to BCNF, 4NF and 5NF. Can anyone help Normalise my data?
Below is the data upto 3NF.
-3NF-
(The data with the underscore(__) next to them are Candidate keys)
__Memcode__
Name
Address
Title
Sex
Dob
__Occupation__
Occupation
__Category__
Address
Region
__Memcode__
__Subject__
Num-sent
Num-replied
__Offercode__
Title
Subject
__OfferCode__
__Date__
Price
Num-sold
__OfferCode__
__Date__
__Target-category__
__Age-group__
__Target-region__
__Suppcode__
Name
Address
Phoneno
__Itemcode__
Description
__Offercode__
__Itemcode__
__Qty__
__Offercode__
__Itemcode__
__Suppcode__