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:
Things you need
- Database software
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.
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.
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)
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."
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for