How to Create a Music Chart Database

Written by cristina puno
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Create a Music Chart Database
Information from music charts can be stored in databases. (music image by Edvin selimovic from Fotolia.com)

Music charts are a way of keeping track of the latest popular music. Billboard charts and the numerous top ten countdowns on radio stations and music shows are examples. One of the best ways to keep information such as music chart rankings is to store them in a database. Databases help keep information organised, enabling fast retrieval. Making a database also satiates the ever-present need of music buffs to keep score of who the hottest, up-and-coming artists are and how their songs fare in popularity.

Skill level:
Moderate

Other People Are Reading

Things you need

  • Database software

Show MoreHide

Instructions

  1. 1

    Choose a database program. There are many different database programs available to choose from. Examples include Microsoft Access, which comes bundled with the Microsoft Office Suite, or MySQL, which is offered online for free. Choosing a database depends on how it will be used. If putting a database online, the most preferred ones would be MySQL or Microsoft SQL Server. See "Resources" to learn more about these databases and how to use them.

  2. 2

    Create one table per chart. Once a database program is chosen, you can begin creating the database structure. To begin, create a single table for each type of chart. For example, one table will be named "Pop Music Chart," another named "Country Music Chart" and so on.

  3. 3

    Create fields for each table. Each field will contain the information for each type of music chart. To have the most relevant information, you will need to create the following fields -

    Date (of when the song was ranked)

    Song rank

    Song title

    Artist

  4. 4

    Populate your database. Type in the information for each chart in each table and field.

Tips and warnings

  • You can also create one single table for your database to save space. To determine which song belongs to a particular chart, in addition to the four fields mentioned earlier, you can add a "Type of Chart" field. This will indicate whether a particular song is in the "Country Music Charts" or the "Pop Music Charts."

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.