Created
April 3, 2016 02:19
-
-
Save adam-dziedzic/c31aedf00e0f222591751cebe4b55a5d to your computer and use it in GitHub Desktop.
This is the dataset which should be used for homework 1, problem: 6-14 (Database course, University of Chicago)
This file contains 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: library schema | |
| description[[ the data for problem: 6.14 ]] | |
| member = {memb_no name dob | |
| 1 adam 123 | |
| 2 mike 456 | |
| 3 jack 789 | |
| 4 luke 100 | |
| 5 tom 111 | |
| 6 veronique 101 | |
| 7 bartek 222 | |
| } | |
| books = {isbn title authors publisher | |
| 1 "7_habits" napoleon "McGraw-Hill" | |
| 2 "what_you_think" feynman "mit_press" | |
| 3 "pragmatic_programmer" "andre_hunt" "pragmatic" | |
| 4 "java_8" bob "McGraw-Hill" | |
| 5 "ruby" jack "McGraw-Hill" | |
| 6 "c++" samuel "McGraw-Hill" | |
| 7 "python" adam "McGraw-Hill" | |
| 8 databases mike "mit_press" | |
| 9 "operating_systems" andrew "mit_press" | |
| 10 "c_programming" denis "McGraw-Hill" | |
| 11 "c#" bill "McGraw-Hill" | |
| } | |
| borrowed = {memb_no isbn date | |
| 1 11 "2016.01.01" | |
| 1 10 "2016.01.02" | |
| 1 1 "2016.01.03" | |
| 1 4 "2016.01.03" | |
| 1 5 "2016.01.03" | |
| 1 6 "2016.01.03" | |
| 1 7 "2016.01.03" | |
| 1 8 "2016.01.03" | |
| 2 8 "2016.01.04" | |
| 5 11 "2016.01.03" | |
| 4 11 "2016.01.01" | |
| 4 10 "2016.01.02" | |
| 4 1 "2016.01.03" | |
| 4 4 "2016.01.03" | |
| 4 5 "2016.01.03" | |
| 4 6 "2016.01.03" | |
| 4 7 "2016.01.03" | |
| 4 8 "2016.01.03" | |
| 7 1 "2016.01.03" | |
| 7 4 "2016.01.03" | |
| 7 5 "2016.01.03" | |
| 7 6 "2016.01.03" | |
| 7 7 "2016.01.03" | |
| 7 10 "2016.01.03" | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
to jest University of Chicago :)