| 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) | |