Database Revision

Flashcards by jordanleecurnow, updated more than 1 year ago
Created by jordanleecurnow over 5 years ago


Flashcards on Database Revision, created by jordanleecurnow on 06/19/2015.

Resource summary

Question Answer
Database An organized collection of data.
Table Stores all of the records for a particular category.
Record All of the data or information about one person or one thing.
Field One piece of data or information about a person or a thing.
Report Is a collection of data with specific details to analyse.
Primary Key It is important that every single record in a database has something to uniquely identify it and this is called the 'Primary Key' or sometimes called the 'Key Field'.
Alphanumeric or Text This allows you to type in text, numbers and symbols.
Currency This automatically formats the data to have a £ or $ or Euro symbol in front of the data and also ensures there are two deciaml places.
Auto Number This data type will automatically increase by 1 as records as added to the database.
Number This allows a whole number or decimal number. Only numbers can be entered, no letters or symbols.
Date/ Time This restricts data entry due to a true date. It checks that a data can actually exist, for example it would not allow 31/02/06 to be entered. It formats the data into long, medium or short date/time.
Logical, Boolean, Yes/No This data type is often reffered to as different things, you may hear it called, "Logical", or "Boolean" or "Yes/No". All it means is that the data is restricted to one of only two choices.
VALIDATION Type check, range check, presence check and format check.
It is very important to remember that Validation cannot stop the wrong data being entered, you can still enter "Smith" instead of "Smith" or "Brown" instead of "Green" or "78" instead of "87". What validation can do, is to check that the data is sensible, reasonable and allowable.
PAPER DATABASE EXAMPLES Telephone book Yellow pages Old library
ELECTRONIC DATABASE EXAMPLES Modern School Registers Google Facebook
FLAT FILE DATABASE A database that contains only one table: This table might seem pretty logical at first. But think about it …. Every single time the pet has an appointment, the customer's title, surname, street, town, county, and phone number have to be entered. Also, the pet's name, type and D.O.B. also have to be entered. That would get fairly tedious having to enter so much data each time and there would be a great risk of making a mistake. It also means you have a lot of duplicate data (redundant data) taking up space on your hard drive.
RELATIONAL DATABASE In this database the data is split up into sensible groups i.e. customer data, pets data and appointments data. Then a separate table is made for each group. The main benefit of a relational database is that data doesn't have to be duplicated. When a customer books an appointment for their pet, a new record is created on the 'appointment's table' and the relevant Customer and Pet IDs are chosen.
DATA DUPLICATION Data deduplication is a technique for reducing the amount of storage space an organization needs to save its data. In most organizations, the storage systems contain duplicate copies of many pieces of data.
DATA REDUNDANCY Data redundancy leads to data anomalies and corruption and generally should be avoided by design; applying database normalization prevents redundancy and makes the best possible usage of storage. At the same time, proper use of foreign keys can minimize data redundancy and chance of destructive anomalies.
Show full summary Hide full summary


Database Flashcards
christina Littlewood
Holly Miles
Biology- Genes, Chromosomes and DNA
Laura Perry
Practice For First Certificate Grammar I
Alice ExamTime
GCSE AQA Biology 1 Quiz
Lilac Potato
Get your grammar right!
Sarah Holmes
10 good study habits every student should have
Paras Garg
Ariana Chavez
Readings para Preparar el First Certificate (I)
Bilge Nur
Mapa Conceptual
natalia forteza
Creación del archivo
Lina Baldovino