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
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