Flashcards
Database Theory
Flashcards do conjunto (8)
- 1TableA table stores all of the records for a particular category.
- 2RecordsA record is all of the data or information about one person or one thing.
- 3Fielda 'field' is one piece of data or information about a person or thing.
- 4Data Typesthe type of data you enter in a database, e.g text, currency Boolean (two choices) etc.
- 5Field Lengththe amount of characters permitted for a particular field with in the data base (e.g 7 characters in a postcode field.)
- 6Primary KeyA unique number or code to distinguish different people or objects to keep professionalism and to reduce errors.
- 7Foreign KeyA foreign key is used to link tables together and create a relationship. It is a field in one table that is linked to the primary key in another table.
- 8Referential IntegrityPrevents you from trying to delete records where the foreign key and primary key are related.
Informações
- Descrição
- FlashCards sobre Database Theory, criado por 11cknight em 11-11-2014.
- Criado por
- 11cknight
- Visualizações
- 10
- Avaliação