Flashcards
Database Keywords.
Cards in this deck (24)
- 1DatabaseA persistent, organised store of data.
- 2FieldProperty stored in a database. eg. name
- 3RecordAll of the information on a single person or thing.
- 4TableA collection of records separated into fields.
- 5Flat-file databaseA single database.
- 6Data redundancyAn unnecessary duplicate of data.
- 7Data integrityThe correctness of data.
- 8DBMSDatabase Management System.
Software application that handles the data directly and provides an interface to the database. - 9Program-data independenceChanging one part of the database without changing the data.
- 10Relational databaseA series of tables linked together.
- 11Primary keyA field to uniquely identify a person or thing.
- 12Foreign keyA primary key from a different table to link the tables together.
- 13EntityAn object or thing of importance about which data is captured.
- 14FormUser interface tool that allows an easy way for the user to input or change data.
- 15Query / InterrogationDatabase management tool used to retrieve and search specific data.
- 16ParameterEach end of a range.
- 17Report.Database management tool used to present data to a user.
- 18Module.Writing code to add data.
- 19Logical operators.Combines or modifies searches.
- 20ValidationThe automatic checking of inputted data by a computer system to ensure it is acceptable.
- 21VerificationThe process of ensuring that data the entered is correct.
- 22Input maskTelling the user the format to enter data.
- 23Presence maskChecking to see if the field has been left blank.
- 24Range check
Information
- Description
- Flashcards on Database Keywords., created by dsouthin11 on 19/01/2016.
- Created by
- dsouthin11 · Jan 2016
- Updated
- May 18, 2016
- Views
- 4
- Rating