261A CS143 Lec 3 Relax

gistfile1.txt

group: Movie Database

movie = {
  movie_id:string, title:string, director:string, genre:string, year:number
  tt0111161, 'The Shawshank Redemption', 'Frank Darabont', Drama, 1994
  tt0068646, 'The Godfather', 'Francis Ford Coppola', Crime, 1972
  tt0468569, 'The Dark Knight', 'Christopher Nolan', Action, 2008
  tt0108052, 'Schindlers List', 'Steven Spielberg', Drama, 1993
}

review = {
  movie_id:string, review_id:string, review_text:string, rating:number
  tt0068646, r8823, 'A masterpiece of cinema', 9.5
  tt0068646, r9174, 'The acting is incredible', 9.0
  tt0468569, r2847, 'Best superhero film ever', 9.2
  tt0468569, r3019, 'Heath Ledger was phenomenal', 9.8
}


group: Library

author = {
  auth_id:number, name:string
  1, 'Rowling J.K.'
  2, 'Tolkien J.R.R.'
  3, 'Austen J.'
  4, 'Orwell G.'
  5, 'Christie A.'
  6, 'Hemingway E.'
  7, 'Bradbury R.'
  8, 'Verne J.'
  9, 'Shelley M.'
  10, 'Fitzgerald F.S.'
}

book = {
  auth_id:number, title:string
  1, 'Harry Potter Stone'
  1, 'Harry Potter Chamber'
  2, 'The Hobbit'
  2, 'The Fellowship'
  3, 'Pride and Prejudice'
  3, 'Sense and Sensibility'
  4, '1984'
  5, 'Orient Express'
  6, 'The Old Man'
  7, 'Fahrenheit 451'
  8, 'Twenty Thousand Leagues'
  9, Frankenstein
  10, 'The Great Gatsby'
}


group: Students - Set Operations

ugrad_students = {
  uid:number, name:string, gpa:number
  123456789, 'Josie Bruin', 3.8
  246802468, 'John Smith', 4.0
  242424242, 'Sarah Smiles', 3.0
}

grad_students = {
  uid:number, name:string, gpa:number
  555121255, 'Joe Bruin', 2.8
  111111111, 'Johnny Appleseed', 3.5
  987654321, 'Tim Apple', 2.9
  135791357, 'Erica Pear', 2.6
}


group: Students - Aggregation

ugrad_students = {
  name:string, major:string, gpa:number, sleep:number
  Betty, MATH, 3.0, 8
  Jose, MATH, 3.2, 8
  Joe, CS, 2.7, 4
  Alice, CS, 2.0, 2
}