Introduction 4 Aim 5 Main objectives 6 Investigate existing products 6 Popular audio formats 6 Relevant theory 7 Audio metadata 9 How to find the ID3 data: 10 ID3V1 Genres 11 Lyrics 3 11 OGGVorbis comments 12 AAC Metadata 13 WMA Metadata 14 Playlists 14 Backend: 14 Analysis of requirement 15 Functional aims: 15 Out of the box 16 Design 16 Obtain lyrics automatically for a track 17 Search the database 17 Browse the database 17 Rating files 17 File support 17 Streaming files 17 Download file 18 Displaying album art 18 Create playlists 18 Security 18 Speed 19 OS independent: 19 User security 19 Users 20 Development 20 Key technologies: 21 Research 22 Current products 22 Database design: 29 Table details: 30 TblUser: 30 TblSong 30 Browsing artist/title A-Z 41 Testing 55 Browser testing 55 Firefox 2.0.0.3 55 Opera 9.21 56 Netscape 8.1 57 Function testing 58 More audio formats supported: 81 Top rated songs 81 User uploaded album art 81 Plugin: 82