click below
click below
Normal Size Small Size show me how
A451 - Databases
Revision for OCR GCSE Computing A451 Databases
Keyword | Definition |
---|---|
Database | Persistent and structured store of data which allows data to be stored and interrogated. |
Entity | A real world object about which data is stored in a database corresponding to tables in a database. |
Relational Database | Each entity modelled as a table with individual entities using a row of a table which are linked together using primary and foreign keys. |
Primary Key | Unique identifier in a database table. |
Foreign Key | Used to link two tables together and allow you to retrieve data from a linked table. |
Redundancy | Where data has been repeated unnecessarily in a database. |
Validation | Checks put in place to make sure data is free from error. |
Data Types | String, Boolean, Real, Integer |
DBMS | Allows database to be queried and provides facilities for creating tables, inserting data, viewing data and reporting. |
Form | An input screen allowing chosen data to be displayed and edited using text boxes, drop down lists, checkboxes etc. |
Report | An output of the data from a database showing a snapshot of the data at any given time laid out in a specified format. |
Query | Method of interrogating a database using a set criteria. |