Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
This is the dataset which should be used for homework 1, problems: 6-11 and 6-13 (Database course, University of Chicago)
group: employee schema
description[[ the data for problems: 6.11, 6.13 ]]
employee = {person_name street city
adam kenwood chicago
bob kimbark chicago
joe michigan chicago
kate woodlawn boston
noelle woodlawn boston
veronique kimbark warsaw
luke dorchester warsaw
bartek marszalkowska warsaw
works = {person_name company_name salary
adam FirstBankCorporation 2500
bob FirstBankCorporation 11000
joe FirstBankCorporation 1000
kate hospital 20000
noelle hospital 19000
veronique office 4000
luke it 10000
bartek it 15000
company = { company_name city
FirstBankCorporation chicago
FirstBankCorporation warsaw
FirstBankCorporation new_york
hospital warsaw
hospital chicago
hospital chorzow
office baltimore
it warsaw
SmallBankCorporation warsaw
SmallBankCorporation chicago
manages = {person_name, manager_name
adam bob
luke bartek
noelle kate
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.