---
title: "database design for song voting system"  
description: "database design for song voting system"  
author: "Royce Roy"  
published: 2013-04-10  
updated: 2013-04-15  
canonical: https://www.mindstick.com/forum/759/database-design-for-song-voting-system  
category: ".net"  
tags: [".net"]  
reading_time: 1 minute  

---

# database design for song voting system

Hi Everyone!\
I have to make a [simple](https://yourviews.mindstick.com/story/1469/5-simple-ways-to-stay-fit-amp-healthy) song [voting](https://yourviews.mindstick.com/view/80761/impeachment-voting-donald-trump-is-not-guilty) [website](https://www.mindstick.com/articles/13110/why-copywriting-is-crucial-for-new-website-build) with [asp.net](https://www.mindstick.com/articles/934/default-folders-available-inside-the-asp-dot-net-application-folder) .Here is the sample of my database tables and fields .\
Album User Voting------ --------- ---------albumID userID userIDalbumName [userName](https://www.mindstick.com/forum/12798/there-is-no-viewdata-item-of-type-ienumerable-selectlistitem-that-has-the-key-username) trackID rate\
\
\
Tracks TrackRate------ ---------trackID trackIDalbumID ratetrackTitlecomposerartistbandgenre:It's just a simple .In fact , i haven't much more [experience](https://www.mindstick.com/articles/12276/how-timely-order-deliveries-can-improve-customer-experience) in database designing and [normalization](https://www.mindstick.com/articles/855/introduction-to-database-normalization) .i want to know the best [database design](https://www.mindstick.com/forum/34620/database-design) :)\

## Replies

### Reply by AVADHESH PATEL

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 userIDalbumName userName trackIDuserID rate\
\
\
Tracks TrackRate------ ---------trackID trackIDalbumID ratetrackTitlecomposerartistbandgenre:UserID


---

Original Source: https://www.mindstick.com/forum/759/database-design-for-song-voting-system

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.