Flashcards
Data base cards
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 record is all of the data or information about one person or one thing.
- 4Data typesAre used in each field
- 5Field lengthIf the field length is set for 40 then it means the field length is able to store up to 40 letters numbers or symbols
- 6Primary keyAllows you to be recognised for example;when you start school your given a ID which means you can be recognised
- 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 uses this to ensure there is no orphan records, It can also alert you if you try to delete a record
Informações
- Descrição
- FlashCards sobre Data base cards, criado por 11aattewell em 11-11-2014.
- Criado por
- 11aattewell
- Visualizações
- 12
- Avaliação