Flashcards
database termonology
Flashcards do conjunto (8)
- 1TablesA 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
- 3FieldsA field is one piece of data or information about a person or thing
- 4Data typesA data type can be either: Text, currency, number, date/time, auto number, or Boolean.
- 5Field lengthA field length is how large a set of data should be , for example post code
- 6Primary keyevery single record in a database has something to uniquely identify it, this is called primary key, e.g student ID
- 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 integrityIt prevents you from deleting a record that is related to another one.
Informações
- Descrição
- FlashCards sobre database termonology , criado por 11zadal em 11-11-2014.
- Criado por
- 11zadal
- Visualizações
- 12
- Avaliação