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.

Working On A Database.

After analysing the Microsoft office tutorials and its explanation of how to create and maintain databases using Microsoft office access, an explanation of each tutorial is needed.
The tutorials include:

• Table that Data
• Tables, the building blocks of databases.
• Fields of Data
• Each record is unique
• It's all relative
• Practice
• Test Yourself
• Analyzing, viewing, and reporting data.
• Queries
• Forms
• Printed Reports
• Practice
• Test Yourself

Table that Data introduces how to create databases using tables and with which types of software, in this case Microsoft Office Access as well as gives us an insight of the different parts of the program which assists us, in creating a database.


Tables, the building blocks of databases explores the location of information situated in the table, for example records and fields as well as a reasonable definition of databases and once again records and fields. Tables store data, so they're essential building blocks of any database. The definitions given by this website are the following;
RECORD - a collection of facts about a particular person, event, CD or other item of interest.
FIELD - is a single kind of fact that may apply to each person, event or other record.


Fields of data explains how the information of databases can be changed, by manipulating the settings as well as the properties. This tutorial also assists us in understanding how to use the properties to manage the database with no difficulties or complex issues. This tutorial also gives an insight of an important settings in the case of fields which is the data type. The definition given from the website for this term is as follows;
DATA TYPE - limits and describes the kind of information in the field. The data type also determines the actions you can perform on a field and how much memory the data uses.

Each record is unique analyses the different fields and what information belongs in it. They introduce a field called the primary key field. This is an identifier such as a part of a number or employee ID, which is unique to each record.


It's all relative goes into more detail of the keys used in Microsoft office access such as primary key and a foreign key. Primary key allows you to enter into the power of a relational database, instead of working with a heavy amount of repetitive lists that are difficult to consist of and cannot cooperate.


Practice gives a link in which you can practice how to use Microsoft Office Access. Using the information, given by the website, I have attempted to create a database. Snapshots are featured below;

Identity Fraud.

Identity Fraud is the topic that we were given in our group of three, consisting of Srishti, Aishwarya and me. I have been assigned the following questions; 5 and 6

5) What are the ethical responsibilities of those maintaining the database ?
Before stating the ethical responsibilities of those who maintain the database, we need to have the knowledge of WHO is retaining the database as well as having the satisfaction that the information is safe and secure. In the case of Identity Fraud; police, financial institutions, and government agencies can be a very reliable place to land, if the situation of theft/fraud occurs, although the main basis of protecting and preserving the database is the IT specialists as well as the software provided by them. An ethical responsibility presented to IT specialists is system reliability. System reliability involves installing, updating, keeping hardware working as well as maintaining databases. Each IT specialist must insure the reliability of the software. Another ethical responsibility of the IT professionals, consist of using the correct tools and procedures to test and evaluate the programs before distribution.
IT professionals must also consider the impact they give upon the computer users. Since they have been involved in such a project, they have the ethical responsibility to possibly millions of individuals for ensuring to the best of they're ability, that they know how to accurately retrieve data. Computers will only do what they have been programmed to do, even if its to perform a dangerous act.

6) What are the legal responsibilities of those maintaining the database ?
The database administrators define the schema which consists of the structure of the data in the application. They determine what data needs to be present in the system and how this data has to be represented and organized. They have a duty to interact continuously with the users to understand the data in the system and its use. Database administrators finds about the access restrictions to be defined and defines security checks accordingly. The DBA (database administrators) also defines procedures for backup and recovery. In order to define backup procedures includes specifying what data is to be backed up. Database Administrators have to continously monitor the performance of the queries and take measures to optimize all the queries in the application. The basic legal responsibilities of database administrators, include assuring that every software or application is safe and reliable as well as knowing that the source of the database is trusted and legitimate.

BIBLIOGRAPHY

http://wiki.answers.com/Q/What_are_the_responsibilities_of_database_administrator#ixzz1ndcv1ltz

http://www.lvp.com/supplements/Social%20and%20Ethical%20Implications%20of%20Computer%20Use.pdf
https://www.moneysmart.gov.au/scams/other-scams/identity-fraud

DATABASE DEFINITIONS.

Field: A field is an item of information which is stored for all records in a database.
An example is featured below.

RECORD: These are complete sets of information. They are composed of fields, each of which contain one item of information.

FILE: A file that contains any type of definition except record instances.

QUERY: A request for information from a database. This can be done by choosing parameters from a menu, query by example and query language.

DATABASE: A database is a structured collection of data stored on a computer and/or server allowing you to organize data records which can be sorted, searched and reconfigured in your preferences.

REPORT: A database report presents information retrieved from a table or query in a preformatted, attractive manner.

DBMS: Stands for Database Management System. A software system that uses a standard method of cataloging, retrieving, and running queries on data. The DBMS manages incoming data, organizes it, and provides ways for the data to be modified or extracted by users or other programs. Examples included MySQL and many more.

DATA DICTIONARY: A data dictionary defines the structure of the database itself and is used in control and maintenance of large databases.\

DATA TYPE: A particular kind of data item, as defined by the values it can take, the programming language used, or the operations that can be performed on it.

2) EXAMPLES OF FILE, RECORD, AND FIELD IN A TABLE.

3) COMMONLY USED DATABASES.
Five examples include; Google, Phonebooks,

Database Activities: The Yellow Pages

What is a database ?
A database is a structured collection of data stored on a computer and/or server allowing you to organize data records which can be sorted, searched and reconfigured in your preferences.

Examples of databases.There are several well known databases, surrounding us such as; google. phonebooks, dictionaries, thesaurus' and many more. In simple words, a database helps you store important information, and helps you organize it to your preferences. Any type of product and or computing technology used in order for this to happen can be seen as a database.

THE YELLOW PAGES

1) Bennet Office Supplies
     ph: (02) 4782 2228
2) Beautiful Bouquets and Flowers for Any Occasion
     91a Fowler Rd, Merrylands NSW 2160, Australia.

3) Hotel Laguna    ph: (07) 5447 3077

   

    Noosa Heads Motel

    ph: (07) 5440 4550

   

    Noosa Village Motel

    ph: (07) 5447 5800

    Seahaven Beachfront Resort

     ph (07) 5447 3422

4) I had found the map to my house, after writing the initial of my father. R, Gopal on the Yellow Pages Website. The location map is shown below.

5) The yellow/white pages are databases as, it is a structured collection of data in which can assist us in making our daily lives easier by the information within it, as well as the fact, it consists of important information in an electronic based system.
6) The main advantage of having an electronic based yellow/white pages is the fact that, the database is accessible at anytime or place, as it is on the internet, used throughout Australia.
7) Even though having an electronic based yellow/white pages has various advantages, it is very dangerous when it comes to a privacy concern. Anyone at any place can access these locations, as yellow/white pages is featured on the internet, which can be accessed worldwide as well as within the whole of Australia.