Latest Update

Well we are presenting our presentation next week therefore we have 2 lessons to do this. due to michaela being in melbourne me and michelle have split her question so i am also doing question 1 (the definition) while michelle is doing questions 2, 3 and 6.

here are some answers to my questions because i don't know where else to put them.
1) the ability to view and manage accounts using the internet.
4) well you can misuse online banking data by stealing money from other people's accounts or even pretending to be somebody else. you can gather their financial details and post it on the internet to embaress them or ruin their reputation.
5) it is unethical to sell somebody's details or to blackmail someone using their details or to stalk somebody because you have access to their details. it is ethical to protect it against people who are wanting to do the above things.

here is an example of a scam that is similar to what we are typing about. TROJAN HORSE. they are harmful programmes disguised to look like innocent software which infect a computer. it waits until the user visits a legitimate bank website then infects HTML into certain fields there. the programme then hijacks PINs and transaction numbers as the person enters them into the infected fields and the details are stored.

time is running out of this lesson and michelle and myself have finished answering the questions so we will make the powerpoint next lesson.

Mini Project

well, i'm in a group with michelle and michaela and we are doing online banking. i'm going to question 4 (describe some ways this information can be misused) and question 5 ( what are the ethical responsibilities of those who maintain the database).
sir decided to discuss each of the topics to give us ideas so here is what i remembered from what he said.
some people steal the eftpos swipers and change it, then pretend to be service men and put it in shops and whoever uses it will have their withdrawl put it in the scamers account and their details will be saved. some people put cameras around it or a device under the keypad so they know your pin.
we will probably do a slide show to present it.

Database of Datatypes

well i created a new database in access about data types you use in a database. the picture is probably too small to read so the fields are: name, description, example and size. the records are: text, memo, number, date/time, currency, autonumber, yes/no, object, hyperlink and lookup wizard. here is the screenshot.

Querying a Database

I have finished putting in the query and it came up with the correct name i put in which is text. when i put in the second name in the 'or' row it came up with both the first and second names i queried.

when you put a query in you can put an * in which represents a wildcard which means that anything can go in it's place. for example, it you are looking up mary and you type m* it means look up any names starting with m. if you put an * before a letter it means that it has to end in that letter and also if you put a letter between two * then it has to that letter somewhere in the name.

when you are querying you can put it in the 'and' row which means it will look up both of what you type in. for example, if you type in tom and frank then it will find both tom and frank. if you type it in the 'or' row it will find both tom and frank or only one.

Creating A Database

the fields i have include: first name, last name, mobile number, home number, street, suburb, postcode, date of birth and id.
we use the id field so that each record is totally unique, so that no two records are the same.

Database Definitions

Field: a space for a particular item of information like your name

Record: a set of fields like name, phone no. and address

File: is made of records

Query: a search for information from a database

Database: collection of related data organised for easy access

Report: a printed report of the information in the database

DBMS (database managment system): the software which manages the database

Data Dictionary: it contains a list of all files in the database, the number of records in each file and the names and types of each field

Data Type: what the data is, like date/time, text or numeric. you use numeric for calculations.

Here is an example

Each column is a field, a row is a record and this whole table is a file.