Quick question on normalizing...

  • Thread starter Thread starter Smakit
  • Start date Start date
S

Smakit

It has been forever since I've really done any SQL sort of stuff, and
want to see if I remember how to normalize things pretty well. Here i
a simple example, something a friend is doing in class.

Say I have 3 tables, one for songs, one for bands, and one for cd's..
would the following be normalized?

BAND TABLE
band_id band_name
--------- ---------
(AutoNum) (Text)

CD TABLE
cd_id cd_name
--------- ---------
(AutoNum) (Text)

SONG TABLE
song_id song_name cd_id band_id
--------- --------- ----- -------
(AutoNum) (Text) (Num) (Num)


Would that be a workable database, or should something different b
done? At first I thought of having only song_id / song_name as a table
but then they wouldn't be linked in any way. Any fixes ,advice, o
messages saying *crosses fingers* I am right
 
Back
Top