PART A DATABASE

1.    What ethical / legal issues need to be considered when implementing this database? Explain

Some issues are taking copyright into consideration, and download of music illegally. Another is to make sure information is not misused, and information theft. An example of this is using the whole duration for the song preview resulting in the download of the song illegally. To prevent both of these issues the person responsible for creating the database should consider only taking and using only a part of the song.

2.    Discuss what advantages such a system has over conventional methods of organizing and previewing music?

Using Access to create a database based on music makes it easier for customers and the audience to navigate around the database. A database like this uses buttons and a menu. Another advantage for a database like this is that it is an easy way to to get onto at home instead of moving around and going out. The preview of the song provides an easier help for the consumer to know how and what the music sounds like. Putting a database like this on the internet will make it easier for those disabled who arent able to walk around freely to have easy access to preview of music.

3.    Create a “data dictionary” for your database.

• Song title- name of the song (text)
• Album Cover- image of the album where the song is from (attachment)
• Song Artist- Name of the song artist (text)
• Song Sample- a 30second preview of song (attachment)
• Duration- The whole song's duration in seconds. (numbers)
• Cost- price of the song (AUD)
• Genre- the style of music (text)

4.    “Storyboard” how the user will navigate through your database, ie. the path the user follows to get from one form to the next.