forum

home / developersection / forums / database design for song voting system

Ask Question

database design for song voting system

Royce Roy 2395 10-Apr-2013
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 :)

.net .net 
Updated on 15-Apr-2013
Royce Roy

Other

Message
Can you answer this question?
Answer

1 Answers

AVADHESH PATEL

AVADHESH PATEL

15-Apr-2013
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
MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy