Flashcards
Database Terminology
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 thing.
- 3FieldsA 'field' is one piece of data or information about a person or thing.
- 4Data TypesData comes in many forms: Numerical, Alphanumeric, Currency, Date/Time, Autonumber and Logical/Boolean.
- 5Field LengthFields usually have default lengths, E.g. passwords usually have to be 6 characters.
- 6Primary KeyIt is important that every single record in a database has something to uniquely identify it and this is called the 'Primary Key' or sometimes the 'Key Field'.
- 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 prevents you from deleting related records.
Informações
- Descrição
- FlashCards sobre Database Terminology, criado por 11ccollins em 11-11-2014.
- Criado por
- 11ccollins
- Visualizações
- 6
- Avaliação