NewLib

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
}