Flashcards
ICT topic 8 revision
Cards in this deck (25)
- 1Database (Definition)An 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 types: Number (integer)E.g. 43
A whole number (positive/negative) but no fractions! - 3Data type: Number (real)E.g. 452.543
any number, including whole numbers and fractions. - 4Data type: Text or stringE.g. John Smith
Letters, numbers or other characters such as punctuation marks. - 5Data type: Date/TimeE.g. 04/10/12 OR 12:15:45
Any time or Date; the way the time or date is displayed depends on how it is formatted. - 6Data type: CurrencyE.g. £15.99
Money £ (including foreign currency $ and €) - 7Data type: BooleanE.g. Yes
two opposing states e.g. true or false, male and female, yes and no. - 8Data type: listsE.g. Red, Green, Blue.
a list of values, sometimes called a "drop-down" list; only data from this 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: SoundA beep from a barcode reader or popular song.
- 11Data type: VideoE.g. a moving picture.
A video introduction to computer game or a downloaded film/ TV programme. - 12What is a Field?A single item of data within a record.
- 13What is a recordConsists of a collection of related fields.
- 14What is a file?Is a collection of related fields.
- 15Example of a field:• surname: text
• date of birth: date/time
• selling pricing: currency - 16Example of a record:• Pupil’s record in a school database only has the fields related to that pupil (surname, forename, date of birth, from, etc.) and not another pupils data.
- 17Example of a file/table:• The table of records of all pupils in the school.
- 18What is a Key Field?A Key fields uniquely identities each record. No two records have the same data in their key field. Also known as Primary Key.
- 19What is the purpose of a Key Field?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.
- 20Example of a key field:E.g. Pupil ID
- 21What is a Report?A report is a printed document that contains data from the database, organised and analysed in a certain way. A report from a student database might list the students in each class in alphabetical order.
- 22What are forms used for?Forms are used to make data entry more attractive and secure rather than entering data into raw tables.
It is more secure for looking through and displaying the data. - 23What are the uses of a database?• Add, change or delete records
• Search for a particular record
• Sort the records into a given order
• Print reports about some aspect of the database - 24Why is it important to update records?This is important because nothing stays the same forever.
E.g. when people change their surname (get married), move houses, or prices of goods may change. - 25Advantages of using a database:• Fast to access.
• Easy to edit.
• Validation (can check on the data being entered).
• Reports.
• Sharing.
• Security (passwords, protection).
Information
- Description
- Flashcards on ICT topic 8 revision, created by MeganMondesir on 26/01/2015.
- Created by
- MeganMondesir
- Views
- 2
- Rating