Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Normalisation - BCNF, 4NF and 5NF

Status
Not open for further replies.

NavGo

Technical User
Jan 3, 2003
2
GB
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__
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top