When creating a database that will be released on to the net, one should be careful as to what they are published. They should follow certain precautions as to avoid problems that will involve violation against the copyright laws. The copyright laws generally refer to a legal protection for people who express ideas and information on certain forms. The common forms are writing, music, visual images. The copyright protects the form or way an idea or information is expressed, but it does not protect the information itself. If copyrights are ignored serious penalties can apply which could lead to high fines or worse problems.
So if you are setting up, for example a music database, on the internet you should first get permission to post the database on the internet without getting into trouble with the copyright laws. Some of the options that could occur to you when trying to deal with posting a database on the internet would be to speak to the record dealers and get permission to post the songs on the net under your database. You could then write to the owner of the website that you plan to upload your database onto and explain to him that you have gotten permission to upload the music on to the website.
Sometimes you might have to approach the song writer or the artist depending on how serious the database you want to upload is. You will have to get their permission, if they say ok you will have to agree to their terms and then approach the website owner explaining that you have already got permission there will be no need for trouble.
Overall to make sure that you haven’t illegally put music on your database, don’t download music illegally. !!!
Having a database in a music shop is advantageous because it creates fewer distractions between the customers and the shop owners and workers, because a lot of time is spared if a database is created where the customers can go and view the music they wanted. The customers could enter the name of the album or track and locate the album on the shelves. When having a database, customers could listen to a track of their choice without changing CDs at all times if they need to listen to different tracks on different albums. It is also useful if you want to check the prices of the album.
It is made easier for the shop owners because they only have to update the database each time they decide to change it. So having a database in a music store is highly advantageous. It saves a lot of time for everyone!!
Hey People!! This is in Answer to Question 3.
I figured that a word tabel will be a little confusing so i drew up a diagram which seems less confusing to understand the tables, queries and forms that I ahve added in my database.
In the table I created these were the fields I created.
The Queries I used
The Parameter query enables us to search for a particular Artist, Album, or Track which will then reveal all the data under that particular category. Thus limiting our narrowing our search so that we don’t spend hours searching for one item on a long list.
Forms
The Artist Form was created to enable us to click on the button which will lead us to the Artist Parameter Query.
The Album Forms in turn does the same, enabling us to open the Album Query
The Tracks Form does the same as the two above.
The final form is a general form which allows you to update the information on the database without going and changing the table. It enables us to find records, save new ones, add or delete any records that we wish to.
Switchborad
the Switchboard allows us to navigate through the database.
The Add music button enables us to view the Music Form in add mode.
The Music Reports buttons leads us to view the general information on each track in the form of a report.
The Query button leads us to a sub menu where we find the buttons that will lead us to the forms Albums, Artist and Tracks, which will in turn lead us to the Queries.
The Exit button allows us to exit the database.
The back button allows to go back to the main menu.
Thats it.
