Relational Database Concepts - Chapter 5

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

Resource summary

	Created by eleanorbradbury about 11 years ago