Music Analytica

Words: 759
Pages: 4
Open Document
Music Analytica
Music Analytica is a company with the purpose of allowing music producers and recording labels to gain and keep a competitive edge in the music industry. Being able to process information and apply it in a way that can be used to make informed decisions is what allows a company to progress in their industry. This means that there needs to be a place that the data can be stored and organized in a way that it can be used for such activities. Music Analytica’s Database is designed to accommodate a music company in order to progress. Music Analytica’s database utilizes an MS Access for the construct of the DB (Database). Within the database itself, there are several aspects that make it not only scalable but also highly adaptable. …show more content…
The primary keys that are the unique identifier for the entities in the other tables are also in the index. Although they are primary keys in their respective table, once they are used to reference their table in the index they become foreign keys. The keys themselves are made using an alpha numeric system. This was done with the intent to keep all the keys identifiable to their respective fields. For example, if one wanted to enter a new instance into the genre data table, the key, primary key that would be entered would be g-### depending on the amount of existing entries in the table. This concept is the same for the artist table and the index table. The slight difference is that the index table uses s-### in reference to the fact that is also categorized the songs as well. Utilizing these tables, we can query a number of different aspects that allow us then see what is occurring in the industry or within a company …show more content…
Also, one can use previously made queries to show any type of comparison that the need. As the tables are all related to one another and parameters for the DB have been applied, including referential integrity; if any of the data within the tables is changed or new data are added; the queries will changes based on the data. This is extremely important as it ensures congruence though out the DB; furthermore, is also ensuring that the reports being produces are as an accurate a possible and not miss leading as bad or incorrect data can lead to misinformed
Show More

Related Documents: Music Analytica

Essay about Mapping The Arts Marketing Literature

for scholarship”. Within the international academy, there are many scholars outside marketing who have a stake in the theorisation of art and its relationship with the market, including, e.g. cultural economists, sociologists of art, aestheticians, music scholars, researchers in film and performance studies and psychologists. It is important that arts marketing, arts management and indeed mainstream marketing scholars should listen to what they have to say. For example, Rentschler and Kirchner’s (2010)…

Words 5538 - Pages 23

Essay on Bric Analysis

Polity . Volume 42, Number 1 . January 2010 r 2010 Northeastern Political Science Association 0032-3497/10 www.palgrave-journals.com/polity/ Brazil, the Entrepreneurial and Democratic BRIC* Leslie Elliott Armijo Portland State University Sean W. Burges University of Ottawa By most objective metrics, Brazil is the least imposing of the ‘‘BRICs countries’’— less populous than China and India, slower-growing in recent years than China, India, or Russia, and the only member of the group lacking…

Words 11120 - Pages 45