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:

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


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


The same question 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