|
Creado por eleanorbradbury
hace alrededor de 12 años
|
|
Pregunta | Respuesta |
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 |
There are no comments, be the first and leave one below:
¿Quieres crear tus propias Fichas gratiscon GoConqr? Más información.