Karteikarten
Database Theory
Karten in diesem Stapel (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.
Informationen
- Beschreibung
- Karteikarten am Database Theory, erstellt von 11cknight am 11/11/2014.
- Erstellt von
- 11cknight
- Aufrufe
- 10
- Bewertung