Flashcards
Data base cards
Cards in this deck (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
Information
- Description
- Flashcards on Data base cards, created by 11aattewell on 11/11/2014.
- Created by
- 11aattewell
- Views
- 12
- Rating