Implementing database concepts to develop an application in agile approach : Part 1.2 (Database Server)
Hello everyone. In my last post, i have showed how to create a table schema from real time problem domain, which is now we called as user story. But to work on a database, we need to create tables in a database server. Since i am working on .NET Platform, i am using Microsoft's SQL Server 2005. Installing Microsoft SQL Server 2005: This server is automatically installed when we install Visual Studio 2008. Or you can download the server file from http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx . Installing Microsoft SQL Server 2005 Management Studio Express: To working on the SQL Server, you need to install a management tool. You can download this from http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en this location. OK. Now we are ready to work on the SQL Server. When you lunch the management studio express, the following window will appear. Figure 1: SQL Server Management Studio Express I a