Yesterday, the main description of the site requirements and functional structure, today took a bit of time, summed up the site of the specific database design has also been used in the development environment and tools.
If you are interested in the previous summary of friends can view my previous blog Ajax Online music website (1) Requirements and functional structure
5. Website Database design (e-r map)
The data relation of online music website is analyzed by E-r graph. The following is a detailed description of the online music website of the main entity and E-r map.
The Song information table entity is shown in Figure 5.1: There are basic attributes such as song ID, song name, artist, album name, song type, number of downloads, visits, total traffic, etc.
Figure 5.1 Song information entity graph
The album information table entity is shown in Figure 5.2: It mainly includes the album number, album name, singer, album description, Traffic and other basic properties.
Figure 5.2 Album information entity graph
The Singer Information table entity is shown in Figure 5.3: mainly including the singer number, name, gender, birthdays, hobbies, visits and other basic attributes.
Figure 5.3 Singer Information entity graph
The User Information table entity is shown in Figure 5.4: mainly includes the user's account number, password, gender, name, mailbox, user type and other basic attributes.
Figure 5.4 User Information Entity graph Entity Relationship E-r diagram
5.5: A user can collect more than one song, a singer can sing many songs, a music can also be included in a number of albums, a singer can have their own multiple albums.
Figure 5.5 Entity-er diagram
6. Web development platform and tools
A. Server-side: Web server: ASP. Development Server database server: SQL Server 2008
B. Client: Browser: Internet Explorer 9.0
C. Main development tools: Visual Studio +sql Server 2008+ ASP. Development Server
D. Main development technology: Asp.net+c#+html+javascript+css+ajax
Ajax online music website (2) database and development environment