Define first normal form
No attribute contains more than a single value
Primary key for each record
Define second normal form
First normal form AND
No partial dependencies ( so no attributes depend on a composite key)
Define third normal form
Second normal form AND
No non key dependencies
Define indexing
Method to store the position of each record ordered by a certain attribute
(Normal done to secondary keys to make searching faster)
Define SQL
Declarative language
Used to manipulate databases
How to order an attribute in descending order
ORDER BY attribute Desc
Define referential integrity
Process of ensuring consistency
Ensures information is not removed if it is required elsewhere in a linked database
Define a transaction
Single operation executed on data
Define atomicity
Transaction must be processed in its entirety or not at all
Define consistency
Transaction must retain referential integrity rules between linked tables
Define isolation
Simultaneous executions of transactions must produce the same result as as if they were executed one after each other
Define durability
Once a transaction has been executed it will remain so
