class 7 introduction to databases

review of our AIS structure

files vs. databases

the file approach

the database approach

database advantages

elements of a database system

1. physical database

logical vs. physical view

2. database management system (DBMS)

3. application programs

data hierarchy

data dictionary

value of a database

good data is necessary

relational data models

relational database concepts (entity, table, attributes, etc)

disadvantages of storing data in one table

disadvantages of

SOLUTION: relational database

under the normalization approach

last notes on databases

relational database queries

database systems & the future of accounting