Flashcards
Relational Database Concepts - Chapter 5
Cards in this deck (8)
- 1what is a static query?where the parameter is hard coded into the query and cannot be changed
- 2what is a data dictionaryincludes terminalogy about databases
- 3what is a disadvantage of normalisationreduces database performance
- 4how do you know a table is in 2NFtable is in 1NF, non-key attributes are dependant on the entire primary key
- 5what is referential integrityensuring that for every record in a table with a foreign key there is a record in the corresponding table with primary key
- 6when is a one to one relationship usedwhen one record needs to be linked to only one other record
- 7what is an entitysingle object or process that contains information about things (table)
- 8what is a composite key?a primary key made of two or more fields in a table
Information
- Description
- A2 ICT (5. Relational Database Concepts) Flashcards on Relational Database Concepts - Chapter 5, created by eleanorbradbury on 12/04/2013.
- Created by
- eleanorbradbury
- Views
- 202
- Tags
- Rating