Team Members:

1
Group 1
2
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 Persons Guide to Discipline
Volume II
3
Album
Genres
Label
ContactsList
1
1
1
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
id Int descr Varchar
id Int name Varchar comments
Varchar contactsListID Int
id Int contactID Int
1
1
Contact
Cover
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
id Int printLocation Varchar contributorListID
Int artwork Blob
1
1
1
1
1
1
TrackList
1
id Int trackID Int
1
Track
RecommendationList

1
Contributor
id Int trackNum Int contributorID Int title
Varchar version Varchar comments
Varchar discNum Int cd Int duration Int
id Int recommendationID Int
1

1
id Int lastName Varchar firstName
Varchar typeID Int organization Varchar
1
Recommendation
1

id Int title Varchar subtitle Varchar type
Int reviewQuote Blob reviewAuthor Varchar
1
1
ContributorType
1
id Int description Varchar
AlbumType
1
RecommendationType
id Int type Varchar requirement Blob
1
ContributorList
id Int type Varchar
1
1
id Int contributorID Int
1
4
Group 2
5
Group 4 Chris Gray, Evan Rosson, Alexander
Sideropoulos
TRACK TRACK TRACK TRACK TRACK TRACK TRACK TRACK
track_num disc_id (fk)? title track_dataBLOB lyricsCLOB composer artist track_length
DISCS DISCS DISCS
disc_id album_id (fk)? num_of_tracks
ALBUM ALBUM ALBUM ALBUM ALBUM ALBUM
album_id album_title year record_label album_artBLOB genre
6
Album This Is Jazz Year 1996 Record Label
Columbia Records Genre Jazz
DISC TRACK TITLE ARTIST COMPOSER LYRICS LENGTH (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
1 9 Mahogany Bird Wayne Shorter Wayne Shorter (null) 370
1 10 Diana Wayne Shorter Wayne Shorter (null) 181
7
Album Word of Mouth Year 1981 Record Label
Warner Bros. Records Genre Jazz
DISC TRACK TITLE ARTIST COMPOSER LYRICS LENGTH (s)?
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 Johann Sebastian Bach (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
8
Album In the Flesh - Year 2000 - Record Label
Columbia Records - Genre Classic Rock
DISC TRACK TITLE ARTIST COMPOSER LYRICS LENGTH?
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 Waters Roger Waters (null) 295
1 11 Shine on You Crazy Diamond (Parts 1-8) Roger Waters Roger Waters (null) 883
1 12 Set the Controls for the Heart of the Sun Roger Waters Roger Waters (null) 435
9
Album In the Flesh - Year 2000 - Record Label
Columbia Records - Genre Classic Rock
DISC TRACK TITLE ARTIST COMPOSER LYRICS LENGTH?
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 506AM Every Strangers 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 Its 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
2 10 Eclipse Roger Waters Roger Waters (null) 139
2 11 Comfortably Numb Roger Waters Roger Waters (null) 490
2 12 Each Small Candle Roger Waters Roger Waters (null) 549
10
Group 3
11
CD Artist name VARCHAR Album name VARCHAR ISBN
CHAR(10)? Publisher
VARCHAR Year CHAR(4)?
Artists Artist name VARCHAR Genre
VARCHAR
Artist name
Songs Album name VARCHAR Artist name
VARCHAR Track number INTEGER Song name
VARCHAR Duration INTEGER(4,2)?

ISBN
Artist name Album name
Liner Notes ISBN VARCHAR Page No.
INTEGER Text VARCHAR Artwork LOB
Artist name Album name Track Number
Individual Contributor Album Name
VARCHAR Artist Name VARCHAR Track
Number VARCHAR Contributor Name
VARCHAR Instrument(s) Played VARCHAR
Team Members Ahren Grace Dustin Adam
12
CD Artist name Album name ISBN Publisher Year
Mark Knopfler Shangri-La 0-9362-48858-25 Warne
r Bros. 2004
Songs Album name Artist name Track number Song
name Duration Shangri-La Mark
Knopfler 1 515 A.M. 555 Shangri-La Mark
Knopfler 2 Boom, Like That 549 Shangri-La
Mark Knopfler 14 Dont Crash the
Ambulance 507
Artists Artist name Genre Mark Knopfler Rock
Liner Notes ISBN Text Artwork 0-9362-488
58-25 515 A.M.\nSnow Laying All
Around sunburst.gif 0-9362-48858-25 Boom, Like
That\nIm going to San deepblue.gif 0-9362-488
58-25 Dont Crash The Ambulance\nDont papyrus.
gif
Individual Contributor Album Name Artist Name
Track Number Contributor Name Instrument(s)
Played Shangri-La Mark Knopfler 1 Mark
Knopfler Vocals, guitars Shangri-La Mark
Knopfler 1 Richard Bennett Guitars Shangri-La
Mark Knopfler 1 Jim Cox Pianos and
Organ Shangri-La Mark Knopfler 1 Guy
Fletcher Pianos and Organ Shangri-La Mark
Knopfler 1 Glenn Worf Bass Shangri-La Mark
Knopfler 1 Chad Conwell Drums Shangri-La Mark
Knopfler 2 Mark Knopfler Vocals, guitars
13
Group 4
14
Vinay AnantharamanLara NicholsChetan
DesaiAndrew LeBeau

• CDs
• Berlin A Concert for the People
• Singles Original Motion Picture Soundtrack
• Pavarotti friends 2
• Timbre Harvest Forrest Larson

15
CD Relation
Album
Track
UPC UPC
UPC (PK1) Title Artist Release
Year Label Genre Producer
UPC (PK1, FK1)Disc Number (PK1) Track Number
(PK1) Artist Title Writer Composer Producer Label
Length