Flashcards
Databases
Cards in this deck (23)
- 1DatabaseA persistent organise store of data.
- 2Persistent storageNon–volatile storage on a secondary storage medium such as a hard disk.
- 3Data duplication/data redundancyWhere the same data is stored more than once, unnecessarily.
- 4Data inconsistencyWhere different versions of data become different because duplicated versions have been stored and updated differently.
- 5Program – data IndependenceWhere applications that use is shared database are separated from the actual data by a database management system. Changes can be made to one application without affecting another.
- 6DBMSStands for database management system, the system that separates the applications from the data and provides features that allow database systems to be created, integrated and maintained.
- 7ViewsA feature of DBMS that provides each application or user with specific access rights and views of the database.
- 8Flat file databaseA persistent organised store of data where data is stored in a single file organised into fields and records.
- 9Relational databaseA persistent organise store of data where data is stored as a collection of related tables to minimise data redundancy.
- 10EntityA real world object, about which data is stored in a database, corresponds to a table in the relational database.
- 11TableA collection of data organised into records and fields within a relational database. A table represents a real–world entity.
- 12RecordData stored about one instance of an entity i.e: one particular person or object.
- 13FieldOne specific data item being stored such as surname shoe size.
- 14Primary keyA field in a table that uniquely identifies a record.
- 15Foreign keyA field in one table that is the primary key in another table and is used to create a relationship between those two tables.
- 16RelationshipThe logical connection created between two tables using a primary and foreign key pair.
- 17FormAn interactive window use for data entry. Usually includes validation routines.
- 18ValidationWhen the computer software checks that the data entered is sensible.
- 19VerificationWhere data is entered twice and checked that each version is the same, to avoid data being entered with typing mistakes.
- 20QueriesA feature of DBMS that allows the database to be interrogated. It selects records from the database based on specific criteria.
- 21Logical operatorNOT, AND, OR. Used in complex criteria in queries.
- 22ReportsData from a database that has been processed and presented on a page in a way that makes it information. Designed for hardcopy.
- 23ModulesSections of code within a DBMS that allow the user interface to be tailored.
Information
- Description
- GCSE Computing (Databases) Flashcards on Databases, created by Kjaer on 16/06/2013.
- Created by
- Kjaer · Jun 2013
- Updated
- Feb 19, 2016
- Views
- 108
- Tags
- Rating