Flashcards
Database Flahscards
Cards in this deck (8)
- 1TableA Table stores lots of related information of a particular category
- 2RecordA Record is all of the data for a particular object/person
- 3FieldsA Field is one piece of data/information for one person/object
- 4Data TypesThere are many types of data that can be inputted into a database e.g. text, numeric, currency, date/time, Boolean (Yes/No), etc.
- 5Field LengthEach field can have its own specified length; the default is 50 characters. This can be changed as some fields will only need a specific number of characters, like a postcode
- 6Primary KeyEvery record should have a primary key, something that can easily identify a particular record e.g. Student ID
- 7Foreign KeyA foreign key is used to link tables together to form a relationship, it's a field that is linked to a primary key in a separate table
- 8Referential IntegrityA Foreign key has a corresponding Primary key; a referential integrity makes sure you don't delete any records that have corresponding data. It can alert you if you try to delete data that has related data elsewhere.
Information
- Description
- Flashcards on Database Flahscards, created by 11rtennyson on 11/11/2014.
- Created by
- 11rtennyson
- Views
- 5
- Rating