Objective: This class will be a walk-trough of the homework for this week, and a presentation of next weeks homework. A small hands-on session will be held.
- Associative entities from many-to-many relationships
- Boolean attribute instead of a table
We’re going to play around with an example-database originally created for Oracle, the HR schema.
Clone or download the HR-schema from github,
https://github.com/nomemory/hr-schema-mysql
(Credit to nomemory)
We're going to look at examples of selects, inner, left and right joins appropriately. There might be the need for a subselect as well...