Labels: assignment, database

It's finally done!

everything is done except for uploading my database..

but it doesn't work ..I don't know why..

probably because it's not a proper zip file.

So sorry guys my database doesn't want to be seen aparently.

Be happy with the theory neh?

Labels: assignment, database

Click on the pictures to be able to read them ^^

Tables

Tables are used to store and organise information; the organisation includes allowing to organise the list into alphabetical order whether it's from A-Z or Z-A. Tables also place information into their categories as shown in the image above. The information in the image is organised into 'Song title', 'Artist', 'Genre' and it also has two colums that contain the images shown in forms - this will be explained later on in the post.
However, information in tables have different 'data types' to which they can be entered in. Data types are the different kinds of information that can be stored (words, images etc). The data types I used in my tables are 'Text' - words, 'OLE Object' - used for images, 'Date/Time' - used for dates shown in the format: dd/mm/yy.

Queries

Queries are used to find certain information within the table it was set up to find information from. The queries used in my assignment are used to find 'Song Titles' 'Genres' and 'Artists'.


This image shows the entering of information into a query section. In the query of song titles I entered 'Your Guardian Angel', which is one of the songs featured in the music database.


In this image in the query section of song genres I enter 'J-pop' and these are the results that came up.

Forms

Forms are used to show the information stored within a table. The form featured in the image above is formed from the main table which I used to show; Song title, Artist, Genre, Song sample and Album cover.

Labels: assignment, database

EHHHHHHHH?!

Oh no!!

My internet died for a few days so I couldn't post up the final question on my blog

!!!

Okay today is the day I'll post up the third question.

Sorry for the delay -__-"

it's days like this that I curse the internet.

Labels: assignment, fail

• It is extremely easy to use; as the database has it's own instruction manual on the opening page under the button of 'Help' in the bottom left hand corner. The customer should not have many problems with the use of 'Beautiful Melodies's database.
• The database is visually stimulating, lots of colours and pictures that appeal to the eye; helps catch the attention of those passing by.
• It's easy to go through, and all you need is common sense to be able to use it.
• Different sections of the database are labelled so makes it clear what the different sections are used for.
• Customers are able to preview the song they are interested in - and may end up buying the single/album.
• There is on hand information about different artists featured in the database; which in turn gives the customers basic information about the artist they're interested in.
• Potenial buyers do not have to be subjected to buying the album/single first to discover whether or not they like one featured song - where as this type of database allows them to not have to do this sort of thing.
• The database allows to have a wide variety of music genres/artists/songs to be seen and searched for.
• Free service.

-----
Question two completed!

Labels: assignment, database

• Copyright licences - made clear in some part of the database, to clearly show the ownership over the songs featured to the artist or label. If copyright is not shown legal action may be taken against the owner of the database (omigosh that's me!!) and they may be sued for not showing the proper copyright laws.
• Privacy issues - whether or not the artist/label has given permission for the song to be placed on any database, and if found not to have persmission the song is to be taken down immediately; or if found by someone else and complained about then song can also come down.
• Copyright licences - ethical issue in attempting to take the credit for the creation of the song from the artist and their label; this is in the area of fair treatment for the work of other's, and while they may be appreciated they are not to be claimed as your own.
• Song samples - Instead of placing the whole song onto the sample areas, short outakes (50seconds-1:04mins) are implmented to promote customers to buy the single/album the song is on.

----
Question one complete~

Labels: assignment, database

You know..looking over that sentence, I didn't really make any sense .

Anyways on the artist information page I included the debut date, artist name, a picture and a short biography .

• Red Jumpsuit Apparatus
• The Last Goodnight
• NewS
• Michelle Branch

and that's all I can really remember.

But hazzah! Assignment is completed! And I plan on posting up my answer to question one of the assignment soon after this post ^^.

Last minute things are NOT the way to go

AHahaha...anyways off to answer questions!!

Labels: assignment, database, IT