Fichas
Relational Database Concepts - Chapter 5
Fichas del 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
Información
- Descripción
- A2 (5. Relational Database Concepts) ICT Fichas sobre Relational Database Concepts - Chapter 5, creado por eleanorbradbury el 12/04/2013.
- Creado por
- eleanorbradbury
- Visitas
- 202
- Etiquetas
- Valoración