44327
Descrição
FlashCards por eleanorbradbury, atualizado more than 1 year ago
|
Criado por eleanorbradbury
mais de 12 anos atrás
|
|
| Questão | Responda |
| what is a static query? | where the parameter is hard coded into the query and cannot be changed |
| what is a data dictionary | includes terminalogy about databases |
| what is a disadvantage of normalisation | reduces database performance |
| how do you know a table is in 2NF | table is in 1NF, non-key attributes are dependant on the entire primary key |
| what is referential integrity | ensuring that for every record in a table with a foreign key there is a record in the corresponding table with primary key |
| when is a one to one relationship used | when one record needs to be linked to only one other record |
| what is an entity | single object or process that contains information about things (table) |
| what is a composite key? | a primary key made of two or more fields in a table |
Quer criar seus próprios Flashcards gratuitos com GoConqr? Saiba mais.