Home > DeveloperSection > Forums > database design for song voting system
Royce Roy
Royce Roy

Total Post:134

Points:938
Posted on    April-10-2013 2:25 AM

 .NET .NET 
Ratings:


 1 Reply(s)
 1054  View(s)
Rate this:
Hi Everyone!

I have to make a simple song voting website with asp.net .
Here is the sample of my database tables and fields .

Album             User         Voting
------         ---------     ---------
albumID        userID         userID
albumName      userName       trackID
                              rate



Tracks         TrackRate
------         ---------
trackID        trackID
albumID        rate
trackTitle
composer
artist
band
genre:
It's just a simple .
In fact , i haven't much more experience in database designing and normalization .
i want to know the best database design :)



AVADHESH PATEL

Total Post:604

Points:4228
Posted on    April-15-2013 7:52 AM

Hi Royce!

I did't saw any User and album or user and track association in your DB. It can be done as follows.

Album             User         Voting
------         ---------     ---------
albumID        userID         userID
albumName      userName       trackID
userID                        rate



Tracks         TrackRate
------         ---------
trackID        trackID
albumID        rate
trackTitle
composer
artist
band
genre:
UserID

Don't want to miss updates? Please click the below button!

Follow MindStick