Flashcards
Databases Flashcards
Cards in this deck (35)
- 1A persistent and organised store of data. Persistent means that once the data has been stored in the database, it can be accessed again.Database
- 2A collection of fields to make up information about someone or something.Record
- 3A single piece of data in a record.Field
- 4The format in which the data will be stored.Data type
- 5The different settings for a field.Properties
- 6Greater than > , Less than < and equal to =Relational operators
- 7AND, OR and NOT operators.Boolean operators
- 8Is a computer check that ensures that the data entered is sensible and reasonable. It does not check the accuracy of the data.Validation
- 9The field cannot be left empty. This is used for data which is absolutely essential.Presence check
- 10Only allows a specific number of characters to be entered. Used with string data types.Length check
- 11Only allows a certain type of data to be entered, for example string, integer, real and Boolean.Type check
- 12Only specific data can be entered. For example "Male" or "Female".List check
- 13Number entered must be within a certain range. Only used with integers and real data types.Range check
- 14Data must be entered in a specific way, For example a date in DD/MM/YYYY.Format check
- 15Used for a combination of any characters that appear on a keyboard, such as letters, numbers and symbols.String
- 16Used for whole numbers.Integer
- 17Used for numbers which contain a decimal place.Real
- 18Used when data is restricted to True/False or Yes/No options.Boolean
- 19Used in a query when all of the criteria needs to be met.AND Operator
- 20Used in query searches when just 1 part of the criteria needs to be met.OR Operator
- 21What you are searching for in your query.Criteria
- 22Used to search for specific data using set criteria.Query
- 23To "question" the database. It is another word for retrieving data from a database through the use of queries.Interrogate
- 24An object which organises data in a database using records and fields. Data can be added, deleted or edited.Table
- 25Organising a set of records by a chosen field in either ascending or descending order.Sort
- 26When data is sorted into alphabetical order (A-Z) and numbers are sorted from low to high.Ascending
- 27When data is sorted in reverse order (Z-A) and numbers are sorted from high to low.Descending
- 28Used in query searches when you are looking for all data which doesn't meet your criteria.NOT operator
- 29Devices that are connected over a large geographical location.WAN
- 30Devices that are connected over a small geographical location.LAN
- 31A type of network which allows you to connect devices together over a short range.WPAN
- 32Is software which controls which programs on your computer can send and receive data.Firewall
- 33Software which scans your computer system and files for harmful (malicious) software.Antivirus
- 34Used to protect your data from unauthorised users.Password
- 35Scrambles your data to make it unreadable to others.Encryption
Information
- Description
- Ks3 Computing Flashcards on Databases Flashcards, created by Niamh Walters on 26/04/2017.
- Created by
- Niamh Walters
- Views
- 0
- Rating