· Terms:
o Embedded sql (sql commands inside another programming language)
o Primary key
o Foreign key
o Database integrity
o Normalization
o Data Dictionary
o SQL
o Database - lots of data organized into entities and schemes with a manager
o

Other Things to Know:
· Know what DELETE and UPDATE do, but not syntax
· Views remain and they don't hold data, but can be referenced as though they were tables.
· Data dictionary can be queried
· Know how and why to put multiple queries together into a transaction with a commit statement

· Know authority exists and is set with GRANT/REVOKE - but not syntax
o Know roles exist to group users - but not syntax
o Know sequence exists - but not syntax
o Trigger purpose (to automatically update the database when a table changes in a certain way)

· Be able to fix normalization problems in tables:

o repeated values
o empty values
o identifying a unique key
o multi-valued attribute

o Why use databases? - know just some (about 4) of the advantages over flat file systems: