View Single Post
  #1 (permalink)  
Old March 25th, 2008, 09:23 PM
williamlove williamlove is offline
Authorized User
 
Join Date: Mar 2008
Location: , , .
Posts: 20
Thanks: 1
Thanked 0 Times in 0 Posts
Default Academic vs practical design question

Consider two tables:

tblSongs
-SongID (primary key)
-SongTitle
-ArtistID (foreign key)

tblArtists
-ArtistID
-ArtistName

Is tblSongs normalized? In 3NF? It is possible to wind up with this anomoly:

SongID SongTitle ArtistID
131 Lifes Good 5387
221 lifes Good 5387
258 Lifes Good 5387

To cast more light on my question consider a customer table where the social security number is not allowed so the primary key is some arbitrary unique value

tlbCustomers
-CustID
-FullName
-City

The same question applies...is this normalized? If it is not, you'd have to have tables for the FullName and City, but that would be a lot of work and unwieldy. What would an academic do? A practical designer? I'm very curious.


Reply With Quote