Karteikarten
Topic 8 Databases
Karten in diesem Stapel (15)
- 1Database definitionAn organised collection of related data. It is possible to add, edit, manage and retrieve data from a database. The structure of a database allows data to be found and used quickly.
- 2Data Type: Number (integer)Example: 43
A whole number (positive or negative) but no fractions. - 3Data type: Number (real)Example: 435.256
Any number, including whole numbers and fractions . - 4Data type: Text or stringExample: John Smith
Letters, numbers or other punctuation marks. - 5Data Type: Date/timeExample: 04/10/12
12:15:45
Any time or date ; the way the time or date is displayed depends on how it is formatted. - 6Data type: CurrencyExample: £13.55
Money £ (including foreign currency dollars or euros) - 7Data Type: BooleanExample: yes
two opposing states e.g. true or false, male or female, yes or no. - 8Data type: ListsExample: Red, Green, Blue
A list of values, sometimes called a "drop down list"; only data from the list can be selected - 9Data Type: PictureImage data, from a digital camera, mobile phone, the internet, a clip-art library or scanned in image.
- 10Data Type: SoundExample: A sound or music clip
A beep from a barcode reader or popular song - 11Data type: VideoExample: A moving picture
A video introduction to computer games or a downloaded film/tv programmes. - 12FieldA field is a single item of data within a record. E.g. surname: text
- 13RecordA record consists of a collection of related fields
- 14FileA file (known as a table in Microsoft access)is a collection of related fields
- 15Key fieldA key field uniquely identifies each record. No two records have the same data in their key field. Also known as a primary key.
The purpose of the key field is to be able to refer to an individual record using a single field. This often takes the form of an identity number, membership number or bar code.
Informationen
- Beschreibung
- Karteikarten am Topic 8 Databases, erstellt von lewef002 am 16/01/2015.
- Erstellt von
- lewef002
- Aufrufe
- 2
- Bewertung