Assignment summary

I uploaded my database onto studentnet. It isnt completely finished because access would not work on my computer and wouldnt llet me fix it up. The questions were uploaded on blogger and were quick easy to do but making the database was extremely hard to do with all the forms and queries.

ASSIGNMENT

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

Ethical issues that need to be considered when implementing a music database is that the information in the database is correct and up to date such as the song title, the artist of the song, the album the song is from, the producers etc and that there are no errors. You need to make sure the database is easy to use by everyone such as people who does not have plenty of computer skills that it is easy to access as well as easy to navigate through as for those who have plenty of experience on computers. Instructions on how to use the database needs to be included for the customers so that if they get confused so that they can have a guide on how to navigate through the site. The database must not demonstrate any bias information on music or artist or the song given.

Legal issues that needs to be considered when implementing a music database includes that the information follows the copyright laws concerning the musical CD’s and do not plagiarise the music. That the company that is creating the database have possession of a music licence stating that they can legally sell and promote music. The CD’s is being sold from the company are selling legally and also that they are sold by the date specialised by the music industries that have given the CD’s to the store.  You also have to recognize the artist of the song, the producer and the song title of a sing if it is not an original song by that artist but a cover from another.

Discuss what advantages such a system has over conventional methods of organizing and previewing music?A system which has conventional methods of organising and previewing music has the advantage of being organised as the information is put into fields, setting apart each piece of information.  It allows the customer to create queries which can be both specific and general.  It is easier to update the information in the system as well as it is neatly presented. It can be searched by multiple fields. The database also includes a sample of the music and an image of the album as well as song name, artist name, genre, duration, cover art, cost etc.

Create a “data dictionary” for your database

Field	Data type	Reason
Song title	Text	Name of Song
Artist name	Text	Name Of Artist
genre	Text	Genre Of Song
Duration	Numbers	How long the song is
Album Cover	Image	What the album looks like
Cost	Numbers	How much it costs
Sound sample	Sound	A sample of the song

Storyboard

- First you press the search button on the main menu

- Three different buttons will then come up, search for genre, search for artist, search for song

- If you click on the search for genre button, then you have to type in the specific name of the genre and the songs from that genre will come up

- if you click on the search for artist button, you have to type in the name of the artist and the songs by that artist will come up

- If you click on the search for song button, you have to type the specific song name and the song and a sample will come up

- When you want to return to the main menu then you have to press the back button on the search page 

Bits and Bytes

1.A digit is a single place that can hold numerical values between 0 and 9. Digits are normally combined together in groups to create larger numbers. For example, 6,357 has four digits.
2. Base-10 is a number system based on grouping in tens.
3. Bit originated from Arabic countries
4.

(4 * 1000) + (3 * 100) + (2 * 10) + (1 * 1) = 4000 + 300 + 20 + 1

Online banking

1. Online banking is a system that allows individuals to perform day – to – day banking activities from the comfort of their own home. One will find 2 kinds of online banks, traditional banks that offer the facility of online banking and the other being an online bank with no physical presence. These banks allow users to execute routine transactions, such as account transfers, balance inquiries, bill payments, and stop-payment requests. The benefits of online banking also include, acquiring and accessing account information at any hour of the day – all one needs is a internet connection.

2. Databases are used in online banking as it must store the information of the bankers in the database to be accessed from the bank and from computers at home.  Databases make it easier to access someone’s details such as their name, address, telephone number, card number and amount of money available in their accounts in a short amount of time for the bank and also, it is easier to find information about their banks online for the consumer in order to do transactions online in a shorter amount of time and pay bills without leaving your own home.

3.The types of data stored about individuals in online banking include the individual’s full name, their email and address, their occupation, date of birth, their phone numbers both home and mobile and fax number, their account number, password, the balance of money in their accounts and credit card details.

4. Some ways where online banking can be misused would be the following:

·         Hacking into people’s bank accounts and stealing their money

·         Taking personal details of the bank account owner

·         Privacy, to embarrass you. Letting everyone know your bank account money

5. Responsibilities of those maintaining the database are very simple and straightforward. Maintainers should keep personal and account information extremely secure, and private. They should make sure they have high security regulations in order for them to prevent the misuse of disclosed information.

6. The responsibilities of people maintaining databases would be to keep personal and bank details discreet and private, and not reveal them to a third party. Examples of information that should be kept confidential are DOB, address, bank number and bank password. Design their systems so that it is hard to get into it.

Creating a new database

Tables store data, so they're essential building blocks of any database.
A database should have a separate table for every major subject, such as employee records, customer orders, shipping methods, or suppliers. Data should not be duplicated in multiple tables. Duplicating data is a common error, but it's easy to avoid if you structure your tables well.


Each table contains rows called records and columns called fields.
A record is a collection of facts about a particular person, event, CD, or other item of interest.
A field is a single kind of fact that may apply to each person, event, or other record


The fields in your database have settings that determine the type of data they can store, how the data is displayed, and what you can do with the data.
One important setting for fields is the data type, including number, text, currency (money), and date/time (shown together as one type in Access). The 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. Fields also have properties that control the details of information inside them, including a character length, a default value, and a validation rule that makes sure the data meets certain criteria. The properties make it easier to enter and manage data.


To distinguish one record from another, tables can contain a primary key field.
The primary key is an identifier—such as a part number, a product code, or an employee ID—that's unique to each record.A primary key separates similar information and makes each record unique. It also brings information together. You relate one table to another using a primary key. This is how tables share data, and how you can avoid repeating information in both the tables.

Definitions of Database

Field- Any number of columns regularly used for recording the same information.

Record- A group of related fields, or a single field, treated as a unit and comprising part of a file or data set, for purposes of input, processing, output, or storage by a computer.

File- A collection of related data or program records stored on some input/output or auxiliary storage medium.

Query- A user's request for information, generally as a formal request to a database or search engine.

Database- A comprehensive collection of related data organized for convenient access, generally in a computer

Report- output, especially printed, containing organized information.

DBMS- Data Base Management System: software that mediates access to, additions and deletions of, and changes in data contained in a database, so as to store and access data efficiently and control which data particular programs or individuals are allowed to use.

Data Dictionary- A data structure that stores meta-data, i.e. data about data. The term "data dictionary" has several uses. Most generally it is a set of data descriptions that can be shared by several applications. Usually it means a table in a database that stores the names, field types, length, and other characteristics of the fields in the database tables.

Data Type- A data type (or datatype) In programming, a classification identifying one of various types of data, as floating-point, integer, or Boolean, stating the possible values for that type, the operations that can be done on that type, and the way the values of that type are stored.

My database

Databases commonly used are:

Google

Yahoo

Wolfram Alpha

Oracle

Dictionary.com

Database

What is a database?
A collection of data; information stored, typically in electronic format. It may contain bibliographic, numerical or other data, generally structured so that it can be sought and retrieved automatically.


Examples of databases
relational database-  The data in a relational database is stored in various data tables. Each table has a key field which is used to connect it to other tables. Hence all the tables are related to each other through several key fields. These databases are extensively used in various industries and will be the one you are most likely to come across when working in IT.
Examples of relational databases are Oracle, Sybase and Microsoft SQL Server


Operational database- An operational database is usually hugely important to Organisations as they include the customer database, personal database and inventory database ie the details of how much of a product the company has as well as information on the customers who buy them. The data stored in operational databases can be changed and manipulated depending on what the company requires.