Karteikarten
Relational Database Concepts - Chapter 5
Karten in diesem Stapel (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
Informationen
- Beschreibung
- A2 ICT (5. Relational Database Concepts) Karteikarten am Relational Database Concepts - Chapter 5, erstellt von eleanorbradbury am 12/04/2013.
- Erstellt von
- eleanorbradbury
- Aufrufe
- 202
- Tags
- Bewertung