Created
April 3, 2016 01:51
-
-
Save adam-dziedzic/82bfb952e15b0a7364f6caa74c05ea7a to your computer and use it in GitHub Desktop.
This is the dataset which should be used for homework 1, problems: 6-11 and 6-13 (Database course, University of Chicago)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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