Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
This is the dataset which should be used for homework 1, problem: 6-14 (Database course, University of Chicago)
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"
}
@acmaciek

This comment has been minimized.

Copy link

@acmaciek acmaciek commented Apr 3, 2016

Studuijesz na UIC ?

@adam-dziedzic

This comment has been minimized.

Copy link
Owner Author

@adam-dziedzic adam-dziedzic commented Apr 3, 2016

to jest University of Chicago :)

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.