Help needed with normalisation

From: Evil Monkey <a_at_b.com>
Date: Fri, 19 Mar 2004 20:52:49 -0000
Message-ID: <90J6c.945$74.13@newsfe1-win>

Hi there

I have a relational model that I need to normalise to check there will be no update anomalies and get it to Boyce Codd normal form.

Could some please help me fully understand the concept of a functional dependency?

I dont quite understand how to approach converting my relational model into BCNF. Do I just assume the funtional depndancies based on what the context of the overall system is or is there a way to correctly go through each relation and check for FD's?

I undertsand FD's to some degree and the purpose of normlisations but im a little vague on how to get started

If there is can some one help me to understand one of my relations below? I really want to understand the process.

relation name:VENUE

CK VenueID

(VenueID,NameOfVenue, Address, Telephone ,EntryCost ,OpenTime
,CloseTime,Website,VenueBudget)

relation name: TRACK

CK AlbumId

(AlbumId,TrackNumber,TrackName,Length,Review,PersonId)
Received on Fri Mar 19 2004 - 14:52:49 CST