Flashcards
Relational Database Concepts - Chapter 5
Flashcards do conjunto (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
Informações
- Descrição
- A2 ICT (5. Relational Database Concepts) FlashCards sobre Relational Database Concepts - Chapter 5, criado por eleanorbradbury em 12-04-2013.
- Criado por
- eleanorbradbury
- Visualizações
- 202
- Tags
- Avaliação