44327
Beschreibung
Karteikarten von eleanorbradbury, aktualisiert more than 1 year ago
|
Erstellt von eleanorbradbury
vor mehr als 12 Jahre
|
|
| Frage | Antworten |
| 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 |
Möchten Sie mit GoConqr kostenlos Ihre eigenen Karteikarten erstellen? Mehr erfahren.