MSBA  504
Session Three
Assignment Due:
Assignment Two (COMBINED with others)
Session Materials
chapter two powerpoint
kokos db    kokos excel
kokos case         kokos solution example    susans case
how to import excel into access
https://waltonlab.uark.edu/    remote  into uark epic (or horizon vm client)
http://usd.qualtrics.com/jfe/form/SV_ezDQnY2XLWv8LPL  
Session Topics
relational model
QBE
relational algrebra
 
Learning Objectives
examining relational databases
defining relations
unnormalized
primary keys
SELECT query (in QBE)
WILDCARD query (in QBE)
COMPOUND query (in QBE)
PARAMETER query (in QBE)
CALCULATED query (in QBE)
Session Deliverables
 
Schedule
1230 Session Begins
1230-115 review of access QBE IDE, database normalization
115-220 working through assignment 3 (in access)