| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
01-13-09, 07:28
|
|
Registered User
|
|
Join Date: Nov 2008
Posts: 6
|
|
|
NORMALISATION CHALLENGE! not easy!!
|
|
UNNORMALISED: (batchno, agentno, agent name, holiday code, cost quantity, booked airport, code, airport name)
CAN ANYONE GET THIS INTO 1NF
THEN 2NF
THEN 3NF?
I struggled!!
|
|
01-13-09, 07:40
|
|
vaguely human
|
|
Join Date: Jun 2007
Location: London
Posts: 2,519
|
|
Why don't you post your final attempt so we can comment on that rather than simply just do your homework for you.
Mike
PS very few of us would ever go through the individual stages of 1NF,2NF ... but this is a useful exercise for the student.
|
|
01-13-09, 07:41
|
|
Registered User
|
|
Join Date: Nov 2008
Posts: 6
|
|
|
|
It is not my homework...I am doing for "fun".
(batchno,agentno,agentname,(holidaycode,cost,quant ity,airportc,airportn))
Agentno->agentname
Holidaycode->cost
airportc->airportn
That is as far as I got, I am confused about quantity as it doesn not depend on any PK!
|
|
01-13-09, 07:48
|
|
Jaded Developer
|
|
Join Date: Nov 2004
Location: out on a limb
Posts: 9,246
|
|
in which case you need to think what "quantity" represents, find what entity its dependent on. if you cant find any dependency then its probably an entity in its own right
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton 
|
|
01-13-09, 09:14
|
|
vaguely human
|
|
Join Date: Jun 2007
Location: London
Posts: 2,519
|
|
Quote:
|
It is not my homework...I am doing for "fun".
|
Yeah, right 
As a student do you often set yourself database work and then include fields you don't know the meaning of?
|
|
01-13-09, 09:15
|
|
Registered User
|
|
Join Date: Dec 2007
Location: London, UK
Posts: 732
|
|
Quote:
|
Originally Posted by gdanelian
It is not my homework...I am doing for "fun".
(batchno,agentno,agentname,(holidaycode,cost,quant ity,airportc,airportn))
Agentno->agentname
Holidaycode->cost
airportc->airportn
That is as far as I got, I am confused about quantity as it doesn not depend on any PK!
|
Then maybe your list of attributes is incomplete. Determining dependencies based only on a list of hypothetical names is a pretty arbitrary exercise. The answer can be whatever you want it to be.
|
|
01-13-09, 09:35
|
|
World Class Flame Warrior
|
|
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
|
|
|
|
01-13-09, 09:42
|
|
Moderator.
|
|
Join Date: Sep 2002
Location: UK
Posts: 5,171
|
|
From your original question:
That implies to me that there is one attribute called "cost quantity", or perhaps one attribute "cost" that is of type "quantity"?!
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
NORMALISATION CHALLENGE! not easy!!
