Flashcards
Database
Cards in this deck (18)
- 1FieldA Property of something stored in a database.(Someones name)
- 2RecordAll data about one item in a database for eg:
- 3Primary keyA field in a table which uniquely identifies each record in that table.
- 4DatabaseA persistent(does not go away), organised store of data in electronic form.
- 5Flat filesType of database in which two or more tables are linked to each other
- 6RelationalType database in which two or more tables are linked to each other
- 7EntityA object or thing of importance about which data is captured
- 8FormUser interface tool which allows a user to enter or change data in table
- 9QueryDatabase management tool used to retrieve information based on specified criteria
- 10ReportDatabase management tool used to present information to the user
- 11ValidationThe automatic checking of inputted data by a computer system to ensure it is sensible.
- 12VerificationThe process of ensuring that data entered into a database is correct.
- 13Input maskA type of data validation but it's a format which the person wants you to enter the data for example when you enter a date of birth it shows"DD/MM/YYYY"
- 14Presence checkcheck to see if there's any blank in the forms which the pupil might have missed out for example if you press submit and you left a blank field then it will tell you to fill the field first.
- 15Range checkIt's a type of validation that ensures date whether if it's in particular range or not, by using greater than or less than.
- 16List checkIt gives you the option that you need to enter in the field for example if you're selecting a country where you were born, so it will provide you with the country name so the user will not make any mistakes.
- 17Data redundancyis where the data is repeated unnecessarily in a database for example they will ask you the name at the start and at the end.
- 18Data IntegrityIs the correctness of data in database.
Information
- Description
- Flashcards on Database, created by Aman Paresh on 25/01/2017.
- Created by
- Aman Paresh
- Views
- 0
- History
-
- Created by Shrey Patel · Jan 11, 2017
- Copied by Aman Paresh · Jan 25, 2017
- Rating