DATABASE DESIGN FOR SONG VOTING SYSTEM

Royce Roy

Total Post:149

Points:1043
Posted by  Royce Roy
.NET 
 1340  View(s)
Ratings:
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 :)

  1. AVADHESH PATEL

    Post:604

    Points:4228
    Re: database design for song voting system

    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

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!