Flashcards
Database Terminology
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/thing.
- 3FieldsA field is one piece of data or information about one person or thing.
- 4Data TypesA data type can be Text, Numeric, Currency, Date/Time, Autonumber, Logical/Boolean.
- 5Field lengthA field length is how large set of data should be.
- 6Primary keyEvery single record in a database has something to uniquely identify it, this is Primary key
- 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 IntegrityReferential integrity uses foreign key to ensure that there is no orphan records, it prevents you from deleting related records
Informações
- Descrição
- FlashCards sobre Database Terminology, criado por 11tellis em 11-11-2014.
- Criado por
- 11tellis
- Visualizações
- 4
- Avaliação