Last active
February 26, 2016 07:33
-
-
Save onzfonz/32152bff1fc54ecb5161 to your computer and use it in GitHub Desktop.
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: more random data | |
description[[ the data for this dataset is for testing | |
The relation _Book_ contains basic information about Book | |
The relation _Author_ contains basic information about Author | |
The relation _Branch_ contains basic information about Branch | |
The relation _Holdings_ contains basic information about Holdings | |
The relation _Borrower_ contains basic information about Borrower | |
The relation _Loan_ contains basic information about Loan | |
]] | |
Book = { | |
ISBN, title, publisher, year | |
1, The-Sirens-of-Titan, Dell, 1970 | |
2, Horses-Neck, Houghton-Mifflin, 1985 | |
3, Body, Poseiden, 1990 | |
4, The-Fan-Man, Vintage, 1994 | |
5, Vurt, St.-Martins, 1993 | |
6, Car, Quill, 1983 | |
7, A-Confederacy-of-Dunces, Grove, 1981 | |
8, Player-Piano, Dell, 1980 | |
9, Comet, Random-House, 1985 | |
} | |
Author = { | |
ISBN, name | |
6, Crews-Harry | |
1, Vonnegut-Kurt-Jr. | |
4, Kytzwinkle-William | |
2, Townsend-Pete | |
5, Noon-Jeff | |
3, Crews-Harry | |
9, Sagen-Tom | |
9, Druyan-Ann | |
8, Vonnegut-Kurt-Jr. | |
7, Toole-John-Francis | |
} | |
Branch = { | |
name, phone | |
Cesar-Chavez, 937-8221 | |
Angelou, 937-7700 | |
Fair-Oaks, 937-7100 | |
} | |
Holdings = { | |
book, branch, copies | |
4, Fair-Oaks, 1 | |
1, Cesar-Chavez, 2 | |
5, Fair-Oaks, 1 | |
9, Cesar-Chavez, 1 | |
1, Angelou, 1 | |
6, Angelou, 2 | |
2, Angelou, 1 | |
3, Cesar-Chavez, 3 | |
6, Fair-Oaks, 1 | |
2, Cesar-Chavez, 2 | |
7, Cesar-Chavez, 1 | |
4, Cesar-Chavez, 1 | |
8, Cesar-Chavez, 1 | |
8, Angelou, 1 | |
} | |
Borrower = { | |
card_no, name, phone | |
1, Zelig-Leonard, 675-9987 | |
2, Ho-Zheng, 876-2865 | |
3, Connor-Sarah, 443-8859 | |
4, Martinez-Maria, 443-0937 | |
} | |
Loan = { | |
book, branch, borrower, date_out, date_due, date_returned | |
4, Fair-Oaks, 1, 2011-03-14, 2011-03-21, 2011-03-19 | |
1, Angelou, 3, 2011-04-10, 2011-04-17, 2011-04-20 | |
1, Angelou, 4, 2011-03-01, 2011-03-09, 2011-03-02 | |
6, Fair-Oaks, 3, 2011-09-02, 2011-09-09, 2011-09-05 | |
6, Angelou, 2, 2011-05-11, 2011-05-18, 2011-05-18 | |
4, Fair-Oaks, 2, 2011-05-11, 2011-05-18, 2011-05-18 | |
8, Cesar-Chavez, 1, 2011-01-15, 2011-01-22, 2011-01-21 | |
9, Cesar-Chavez, 2, 2011-02-14, 2011-02-21, 2011-02-20 | |
8, Cesar-Chavez, 1, 2011-10-04, 2011-10-11, null | |
3, Cesar-Chavez, 3, 2011-10-03, 2011-10-10, null | |
2, Cesar-Chavez, 1, 2011-09-01, 2011-09-08, null | |
7, Cesar-Chavez, 4, 2011-09-15, 2011-09-22, 2011-09-20 | |
7, Cesar-Chavez, 3, 2011-09-20, 2011-09-27, null | |
5, Fair-Oaks, 3, 2011-03-15, 2011-03-22, 2011-03-24 | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment