Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

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

database design for song voting system

Royce Roy 2492 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 15 Apr 2013
Royce Roy
Royce Roy

Other

Message

1 Answers

AVADHESH PATEL
AVADHESH PATEL 15 Apr 2013
Report Abuse
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
advertising