Database Terminology

charcrawford
Mind Map by , created over 5 years ago

A level ICT Mind Map on Database Terminology, created by charcrawford on 03/13/2014.

17
2
0
charcrawford
Created by charcrawford over 5 years ago
C2 - Formulae to learn
Tech Wilkinson
PSYA1 - attachment, AQA psychology
Tess W
Biological Psychology - Stress
Gurdev Manchanda
Anatomy and Physiology - BIO 111 - Test #1 Flashcards
ajudkins
1PR101 2.test - Část 1.
Nikola Truong
OCR ICT AS Level - Spreadsheet Concepts (Chapter 4)
Lucy Hayfield
OCR gcse computer science
Jodie Awthinre
MICROSOFT WORD 2013 SKILLS FOR WORK
John O'Driscoll
Types and Components of Computer Systems
Jess Peason
Cells And Cell Techniques - Flashcards (AQA AS-Level Biology)
Henry Kitchen
Database Terminology
1 Database: is a collection of data or information which is held together in an organised or logical way. (Paper based or computerised)
1.1 Paper Based
1.1.1 i.e notebook with addresses sorted by surname or the Yellow Pages directory which is organised by businesses.
1.2 Computerised
1.2.1 i.e. search engines (Google), school electronic registers
2 Why use a database?
2.1 Vast amounts of information can be stored
2.1.1 Banks: millions of customers, who might have more than one account (current, savings, mortgage). Many transactions will take place so the bank will need to store details of every single transaction that takes place, what time, how much, who was paid etc.
2.2 Queries can be run to search for specific records or groups of records
2.2.1 Bank: A customer may complain about a withdrawal of money that they do not recognise. Bank will need to search its database very quickly and find the customers account, transaction and details - can be done in seconds.
2.3 Reports can be produced from the data stored or queries run
2.3.1 Data can be sorted into a logical order or extracted as part of a query, but the output doesn't look very professional. If you are showing the information to a customer, producing a database report may be required.
2.4 Information can be extracted from the database and exported into a word processing package for mail merging
2.4.1 Spam can be sent be running queries on a database and then finding a set of records which match a set criteria.
2.5 Validation can be used to reduce errors
2.5.1 Validation can't stop errors, but can reduce them. Databases enable you to use a variety of validation techniques to ensure that data is 'reasonable, allowable, sensible and within acceptable boundaries'.
3 Tables
3.1 Allows you to see all of the records stored in the database
3.2 Can store many records
3.3 A database can contain many tables
4 Record
4.1 Is all of the data or information about one person or one thing
4.1.1 Each table can contain anything from a few up to millions or records/rows
4.1.2 Is made up of lots of individual pieces of information
4.1.3 Each piece of info in a record is called a field
5 Flat file database
5.1 All data stored in one large table

Media attachments