Flashcards

Database Keywords

arnies swarzer allen bagger thefatestfastmanalivethatskiny Computing GCSE English 14 cards

Cards in this deck (14)

1RECORDAll Data About One Item In a DataBase
2FIELDA Single Category Of Information That Is Recorded In a DataBase. For Example Someones Name
3PRIMARY KEYA Field In a Table Which Uniquely Identifies Each Record In That table
4DATABASEA Persistent, Organised Store Of Data In Electronic Form
5FORMUser Interface Tool Which Allows A User To Enter Or Change Data In A Table
6VERIFICATIONChecking to see if the information that is entered is correct, e.g passwords are usually entered twice to ensure they are correct.
7VALIDATIONChecks wether the imformation entered is vlaid.
8INPUT MASKA way of telling you how to format the information. e.g when they ask for a date of birth and they use DD,MM,YYY.
9PRESENCE CHECKA presence check is to check if a box has information in it. e.g when it says required field.
10RANGE CHECKA way of checking that data is within a certain reasonable range. e.g if the birth date id in the future e.g.e.g if current year is was 1999 then the birth date on the form cant be 2006.
11LIST CHECKI gives you a list to choose from to prvent you from getting it wrong.
12DATA REDUNDANCYPrevents the same field from being repeated if already filled out on another.
13DATA INTEGRITYIs the correctness of data stored in database
14DBMSDatabase management system