Group 1 Team Members: Jimmy Hua Jong Lee Ryan Matteson Michael Huffman CDs: Warsaw Village Band - Uprooting The Best of Smokie Deadwing - Porcupine Tree Sometimes God Smiles.
Download ReportTranscript Group 1 Team Members: Jimmy Hua Jong Lee Ryan Matteson Michael Huffman CDs: Warsaw Village Band - Uprooting The Best of Smokie Deadwing - Porcupine Tree Sometimes God Smiles.
Group 1 Team Members: Jimmy Hua Jong Lee Ryan Matteson Michael Huffman CDs: Warsaw Village Band - Uprooting The Best of Smokie Deadwing - Porcupine Tree Sometimes God Smiles - The Young Person’s Guide to Discipline Volume II Album 0 … 1 1 id : Int title : Varchar subtitle : Varchar volume : Varchar date : Date genreID : Int labelID : Int labelNum : Varchar coverID : Int upc : Int contributorListID : Int trackListID : Int albumTypeID : Int recommListID : Int license : Varchar licenseDate : Date licenseOrg : Varchar Genres 1 ContactsList id : Int name : Varchar comments : Varchar contactsListID : Int 1 id : Int contactID : Int 1 1 1 1 Contact Cover 1 id : Int printLocation : Varchar contributorListID : Int artwork : Blob 1 1 1 1 1 TrackList 1 id : Int trackID : Int 1 Track 1 id : Int recommendationID : Int id : Int trackNum : Int contributorID : Int title : Varchar version : Varchar comments : Varchar discNum : Int cd : Int duration : Int 1 Recommendation * 1 * 1 1 1 id : Int description : Varchar addressee : Varchar poBox : Int city : Varchar state : Varchar(2) country : Varchar fax : Int email : Varchar phone : Varchar url : Varchar Contributor 1 id : Int lastName : Varchar firstName : Varchar typeID : Int organization : Varchar * 1 1 ContributorType id : Int description : Varchar AlbumType RecommendationType id : Int type : Varchar 1 id : Int descr : Varchar RecommendationList id : Int title : Varchar subtitle : Varchar type : Int reviewQuote : Blob reviewAuthor : Varchar Label id : Int type : Varchar requirement : Blob ContributorList 1 1 id : Int 1 contributorID : Int 1 * Group 2 Group 4 Chris Gray, Evan Rosson, Alexander Sideropoulos TRACK track_nu m disc_id (fk) title track_dat a [BLOB] lyrics [CLO B] compose r artist track_lengt h DISCS disc_i d album_id (fk) num_of_track s ALBUM album_i d album_title year record_labe album_art genr l [BLOB] e Album: This Is Jazz Year: 1996 Record Label: Columbia Records Genre: Jazz DIS C TRAC K TITLE ARTIST COMPOSER LYRIC LENGTH S (s) 1 1 Endangered Species Wayne Shorter Wayne Shorter, J. Vitarelli (null) 286 1 2 Lusitanos Wayne Shorter Wayne Shorter (null) 439 1 3 Ponte De Areia Wayne Shorter Milton Nascimento (null) 314 1 4 Port Of Entry Wayne Shorter Wayne Shorter (null) 306 1 5 The Three Marias Wayne Shorter Wayne Shorter (null) 348 1 6 Eurydice Wayne Shorter Wayne Shorter (null) 343 1 7 When It Was Now Wayne Shorter Wayne Shorter (null) 285 1 8 Beauty and the Beast Wayne Shorter Wayne Shorter (null) 304 Album: Word of Mouth Year: 1981 Record Label: Warner Bros. Records Genre: Jazz DIS C TRAC K TITLE ARTIST COMPOSER 1 1 Crisis Jaco Pastorius (null) 317 1 2 3 Views Of A Secret Jaco Pastorius (null) 365 1 3 Liberty City Jaco Pastorius (null) 717 1 4 Chromatic Fantasy Jaco Pastorius (null) 181 1 5 Blackbird Lennon, McCartney (null) 168 1 6 Word Of Mouth Jaco Pastorius (null) 261 1 7 John And Mary Jaco Pastorius (null) 652 Johann Sebastian Bach LYRIC LENGTH S (s) Album: In the Flesh - Year: 2000 - Record Label: Columbia Records - Genre: Classic Rock DIS C TRAC K TITLE ARTIST COMPOSE R LYRIC LENGT S H 1 1 In the Flesh Roger Waters Roger Waters (null) 281 1 2 The Happiest Days of Our Lives Roger Waters Roger Waters (null) 94 1 3 Another Brick in the Wall, Part 2 Roger Waters Roger Waters (null) 354 1 4 Mother Roger Waters Roger Waters (null) 337 1 5 Get Your Filthy Hands off My Desert Roger Waters Roger Waters (null) 57 1 6 Southampton Dock Roger Waters Roger Waters (null) 136 1 7 Pigs on the Wing, Part 1 Roger Waters Roger Waters (null) 78 1 8 Dogs Roger Waters Roger Waters (null) 987 1 9 Welcome to the Machine Roger Waters Roger Waters (null) 418 1 10 Wish You Were Here Roger Roger (null) 295 Album: In the Flesh - Year: 2000 - Record Label: Columbia Records - Genre: Classic Rock DIS C TRAC K TITLE ARTIST COMPOSE R LYRIC LENGT S H 2 1 Breathe (in the Air) Roger Waters Roger Waters (null) 202 2 2 Time Roger Waters Roger Waters (null) 384 2 3 Money Roger Waters Roger Waters (null) 372 2 4 The Pros and Cons of Hitch Hiking Part 11 (AKA 5:06AM – Every Stranger’s Eyes) Roger Waters Roger Waters (null) 320 2 5 Perfect Sense (Parts I and II) Roger Waters Roger Waters (null) 446 2 6 The Bravery of Being Out of Range Roger Waters Roger Waters (null) 305 2 7 It’s a Miracle Roger Waters Roger Waters (null) 492 2 8 Amused to Death Roger Waters Roger Waters (null) 564 2 9 Brain Damage Roger Waters Roger Waters (null) 247 Group 3 CD Artist name VARCHAR Album name VARCHAR ISBN CHAR(10) Publisher VARCHAR Year CHAR(4) ISBN Artist name Album name Liner Notes ISBN VARCHAR Page No. INTEGER Text VARCHAR Artwork LOB Team Members: Ahren Grace Dustin Adam Artists Artist name Genre VARCHAR VARCHAR Artist name Songs Album name Artist name Track number Song name Duration VARCHAR VARCHAR INTEGER VARCHAR INTEGER(4,2) Artist name Album name Track Number Individual Contributor Album Name VARCHAR Artist Name VARCHAR Track Number VARCHAR Contributor Name VARCHAR Instrument(s) Played VARCHAR CD Artist name Mark Knopfler Songs Album name Shangri-La Shangri-La … Shangri-La Album name ISBN Shangri-La 0-9362-48858-25 Publisher Warner Bros. Year 2004 Artist name Mark Knopfler Mark Knopfler Track number 1 2 Song name 5:15 A.M. Boom, Like That Mark Knopfler 14 Don’t Crash the Ambulance5:07 Artists Artist name Mark Knopfler Genre Rock Duration 5:55 5:49 Liner Notes ISBN Text 0-9362-48858-25 “5:15 A.M.\nSnow Laying All Around…” 0-9362-48858-25 “Boom, Like That\nI’m going to San…” … 0-9362-48858-25 “Don’t Crash The Ambulance\nDon’t…” Individual Contributor Album Name Artist Name Track Number Shangri-La Mark Knopfler 1 Shangri-La Mark Knopfler 1 Shangri-La Mark Knopfler 1 Shangri-La Mark Knopfler 1 Shangri-La Mark Knopfler 1 Shangri-La Mark Knopfler 1 Shangri-La Mark Knopfler 2 … Contributor Name Mark Knopfler Richard Bennett Jim Cox Guy Fletcher Glenn Worf Chad Conwell Mark Knopfler Artwork sunburst.gif deepblue.gif papyrus.gif Instrument(s) Played Vocals, guitars Guitars Pianos and Organ Pianos and Organ Bass Drums Vocals, guitars Group 4 Vinay Anantharaman Lara Nichols Chetan Desai Andrew LeBeau CDs: Berlin A Concert for the People Singles Original Motion Picture Soundtrack Pavarotti & friends 2 Timbre Harvest – Forrest Larson CD Relation Album UPC (PK1) Title Artist Release Year Label Genre Producer Track UPC = UPC UPC (PK1, FK1) Disc Number (PK1) Track Number (PK1) Artist Title Writer Composer Producer Label Length