A451 - Databases Word Scramble
|
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
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. |
Created by:
bmalcolmson
Popular Computers sets