Flashcards
Databases
Cards in this deck (21)
- 1Fielda property of something stored in a database
- 2Recordall data about one item in a database for example someones personal data
- 3Primary keya field in a table which uniquely identifies each record in that table
example candidate number - 4Databasea persistent(does not go away), organised store of data in electronic form
- 5Formuser interface tool which allow a user to enter or change data in a table
- 6Flat filetype of database which contains only one table
- 7Relationaltype of database in which two or more tables are linked to each other
- 8entityan object or thing of importance about which data is captured for example someones name
- 9Tablea set of data elements organised in fields and records
- 10QueryDatabase management tool used to retrieve information based oN specified criteria
- 11ReportDatabase management tool used to present information to the user
- 12EntityAn object or thing of importance about which data is captured
- 13ValidationThe automatic checking of inputted data by a computer system to ensure it is sensible
- 14VerificationThe process of ensuring that data entered into a database is correct
- 15Input maskis a type of data validation but its a format which the person wants you to enter the data, example date of birth in a form
- 16Presence checkchecks to see if there are any blanks in the forms which the pupil might have missed out.
- 17Range checkit's a way of check if the person has inputted a reasonable data for that box.
- 18List checklist check is a list that is given to you so there is a less chance of you making a mistake.
- 19DBMS(Database management system)d
- 20Data redundancyIs where data is repeated unnecessarily in a database.
- 21Data integrityIs the correctness of data in a database.
Information
- Description
- 6 Computer Science Flashcards on Databases, created by Dharmesh Virendra on 11/01/2017.
- Created by
- Dharmesh Virendra
- Views
- 2
- Rating