Data Dictionary

Song Title (text)- name of the song

 

Artist (text)- name of the artist

Album Cover (attachment)- displays an image of the album which the song came from

Genre (text)- which music style it is

Duration (number)- the entire song’s length in seconds

Cost (currency)- price of the song in dollars

Song Sample (attachment)- provides a short preview of the song

Assignment !

Discuss what advantages such a system has over pre-electronic methods of organizing and previewing music?

There are several advantages in which a system has over pre - electronic methods of organizing and previewing music. Precisely the advantages of convenience and initial access to the database. With the assistance of having an electronic database, it's simpler as well as efficient for customers to seek a variety of songs. With the use of a database in comparison to pre electronic methods, customers will have the ability to type their criteria, single, album or demo in contrary to manually finding it. It's also simpler to access via the internet which also enables consumers to purchase the songs from the convenience from their home or wherever else they may be. Other advantages are as follows:
The Availability of the song: it is faster to check for the song you want by a digital system for instance a database. A database allows the consumer to separate the time,  they would usually be looking for a song in a store by simply typing the song into the database and to check if its available or not. 
Organization and layout of the database: having a digital music store is easier to organize. The database is able to be edited in a few clicks, music can be added and track uploaded. The data (songs) can be easily sorted according to the customers wants.
Cost less to the consumer and income to the producer: The music available in a digital database is much cheaper compared to buying a single in a store. This is because it cost less money for the music company to produce the album covers. If a consumer wanted to buy just a single in a music store more than likely they would have to buy the whole album. This is a disadvantage because the consumer is paying money for tracks that they don’t want. With the digital system it allows to consumer to demo the track and buy either the album or single. 
Variety of genre, music and bands: With the assistance of an online database it allows for more variety of elements and songs on the database. In traditional music store it may be hard for consumers to find unknown and non main stream songs/artist/ bands with having the electronic database it allows consumers to easily access their desired choice of media.
What ethical / legal issues need to be considered when implementing this database? Explain.

s      The issue with my database in the case of legal issues had been the COPYRIGHT. This not only included    the track cover but also the demo of each single. The database had been created with a 30 second demo of each track and the copy right laws insist on the artist with legal rights to their own work including the cover album and music. It is illegal for digital databases to distribute music without the permission of the owner of the copyrighted sound recording. Although the online stores need a licence given by the record labels which would later give them permission to distribute their media. The data base would need to ask permission about the album cover in addition to if it can be distributed.  The pricing of a song track has to be ethical for both consumers by making sure it is affordable but that the pricing is also fair that the music producer makes a profit. If the prices of music were overprices consumers may resort to illegal online downloading which in turn looses profit to both the company, producer of the music and the database company .  The issue of fair pricing needs to be considered when implementing the database because it may prevent legal issues involving the illegal downloads and the distribution of the music.

Outline 3 features that you think should be added to the system to make it more useful and safe for the customer. 
Top charts: allows the consumer to see the top downloaded songs and the top charting songs. It allows suggest music that the consumer may be interested in and also allows the consumer to discover new artist.
Music video: This allows the consumer to see how the artist is able to voice his music through video.
Account access for the public: Allows easier access, premium accounts, faster downloads and chat room.  Also increase security because the consumer will have a username and password and their account information will be private and not accessible by the public
Recent downloads: Allows the consumer to see what other people have downloaded. Can lead to new artist that the consumer may not have heard of.
Billing system through their account: Safer for the consumer. By having an account it will be on private meaning that they would be able to buy the music using credit cards or PayPal over to internet. Less chance of hacker and your account information is safe.

DATA DICTIONARY

Song Title (text)- name of the song

Artist (text) - name of the artist

Album Cover (attachment) - displays an image of the album which the song came from

Genre (text) - which music style it is

Duration (number) - the entire song's length in seconds

Cost (currency) - price of the song in dollars

Song Sample (attachment) - provides a short preview of the song.