44327
Description
Flashcards by eleanorbradbury, updated more than 1 year ago
|
Created by eleanorbradbury
over 12 years ago
|
|
| Question | Answer |
| 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 |
0 comments
Want to create your own Flashcards for free with GoConqr? Learn more.