Flashcards
Database Termonology
Cards in this deck (12)
- 1TablesStores all of the records for a particular category
- 2RecordsAll of the information and data about one person/thing
- 3FieldsOne piece of data about one person/thing
- 4Data TypesThese are types of data: Number, Currency, Date/Time, Auto Number, Logical/Boolean
- 5Field LengthThe amount of characters allowed in a box
- 6Primary KeySomething which can identify a person/thing easily and quickly
- 7Foreign KeyIt is used to link tables together. It is a field in one table which is linked to the Primary Key in another.
- 8Referential IntegrityIt makes sure that you don't delete anything by accident.
- 9Entity relationship diagramA diagram that shows the relationships between tables
- 10EntityA real world thing which keeps information stored safely
- 11Relational databaseUses a series of tables to store information
- 12ProductivityA measure of the efficiency of an organisation or an individual
Information
- Description
- Flashcards on Database Termonology, created by 11bmortonkemp on 11/11/2014.
- Created by
- 11bmortonkemp
- Views
- 9
- Rating