Relational Database Concepts - Chapter 5

Descripción

A2 (5. Relational Database Concepts) ICT Fichas sobre Relational Database Concepts - Chapter 5, creado por eleanorbradbury el 12/04/2013.
eleanorbradbury
Fichas por eleanorbradbury, actualizado hace más de 1 año
eleanorbradbury
Creado por eleanorbradbury hace alrededor de 12 años
189
0
1 2 3 4 5 (0)

Resumen del Recurso

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
Mostrar resumen completo Ocultar resumen completo

0 comentarios

There are no comments, be the first and leave one below:

Similar

Input Devices
Jess Peason
Output Devices
Jess Peason
Networks
Will8324
General ICT Quiz
leahshaw
ICT Revison Flash Cards
Arun Johal
FLAT FILE VS RELATIONAL DATABASE
rosiejones
Online World - Learning Aim A
andysedge
Business Aims and ICT Strategies
scrt
User Interfaces
Skeletor
General ICT Quiz
Jade Fantom