The objective of this project is to design a Music store web application with user interface which will enable them to browse, search, get song recommendations and buy the song-items of their choice. The motivation of this project comes from my desire to learn the increasingly growing field of SQL server database designing, website designing and their growing popularity by taking up this case study. The word “design” in the context of a Web Application can mean many things. Its most popular usage probably refers to the visual and user interface (UI) design of a web site. This aspect is crucial because, the visitor is often more impressed with how a website looks and how easy it is to use than about which technologies and techniques are used behind the scenes, or what operating system the web server is running. If the site is hard to use and easy to forget, it just doesn’t matter what technologies was used to create it. Unfortunately, this truth makes many in experienced programmers underestimate the importance of the way the invisible part of the site is implemented—the code, the database, and so on. The visual part of a site gets visitors interested to begin with, but its functionality makes them come back. A web site can sometimes be implemented very quickly based on certain initial requirements, but if not properly architected, it can become difficult, if not impossible, to change. Thus, performance is also a major thrust area in the Web application which is one of the main reasons why users get attracted to it. Growing user needs should be taken in to concern with new features to be included. Effective performance can be achieved by making proper database design strategy. Also, easy navigation also needs to be accomplished while executing this project.