ICT Databases

ICT Databases

1. Primary Key

   • a database field that uniquely identifies each record and is used to link tables together.

2. Foreign Key

   • a field in a databaes that is a primary key in another table.

3. Validation Rule

   • makes sure data entered is reasonable and sensible.

4. Boolean Data

   • data that can only have 1 of 2 values e.g. true/false, yes/no.

5. Integer

   • a whole number data type

6. Real number

   • .A number data type that contains decimals

7. between...and...

   • a database search criteriua for searching between 2 number values.

8. >

   • Greater than

9. <

   • less than.

10. not...

    • a search to find all values apart from a specified value

11. Record

    • a row in a database containing data about 1 item or person

12. field

    • a column in a database containing an individual data item

13. table

    • a collection of records and fields in a database.

14. database form

    • a user-friendly place to enter data into a database table

15. Report

    • a method of printing out a query or table from a database to make it look more attractive

16. Query

    • a place to search for dat and store the results of the search in a database

17. Relational Database

    • more than 1 table linked to each other by fields