Flashcards
Database Termonology
Flashcards do conjunto (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
Informações
- Descrição
- FlashCards sobre Database Termonology, criado por 11bmortonkemp em 11-11-2014.
- Criado por
- 11bmortonkemp
- Visualizações
- 9
- Avaliação