lecture

non-relational database
problems:
1) gets huge, repetitive data
2) inconsistent data

relational database
primary key
foreign key is a field which is a primary key of a different table

why should i use an index?
instead of (n^2)/2 guesses (is it 1? is it 2? is it 3? etc. not very productive)
log(n) is much more productive

if n is 100, instead of an average of 50 guesses, it would be an an average of 6 or 7.

DataSheet View -- see the actual data
Design View -- see the metadata


saving is weird in MSACCESS
also, no undos.

Solver, in Excel
goal seek has limitations:
1) seek for a specific value
2) can only fiddle with one value
3) no way of imposing constraints

Solver is an Add-In
lets us do all these things
lets us optimize