How to Install SQL Server 2008 or Later Step by Step Tutorial

Installation of SQL Server 2008 or later is very simple follow the following step and install on your laptop or computers.

If you are still unable to install, make sure all pre-requirements are fulfilled such as the installation of service pack 2.





If you are going to install SQL server express edition you must have visual studio if you are willing to install standalone SQL server then you need full version SQL Server ultimate or higher to install

Download SQL Server 2008 Double click on the installer a window  will open as follow:

From this window click on the Installation menu (See Left). Then select New SQL Server stand-alone installation or add features to an existing installation.

After that following window will appear Click on RUN PROGRAM

After that software will take some time to perform some task. Check that all status are passed

This is express edition so its not necessary to enter Product Key. Just click Next

Check Accept and click next

Now Click Install button

Now again It needs some operation to be completed. Click Next.

Now Check All and click Next

Here we need the name and instance ID. I am selecting Default Instance but keep the name “SQLExpress” in your mind for future (when we are going to connect SQL Server at start up every time). Click Next.

Now a window will appear. Click Next.

Click Next.

Now its not necessary to enter another user if you are trying to install on your personal PC. Click Next.

Click Next

If the status contains no Error. Click Next. Otherwise click on hyperlink text "Error" under status.

Now finally it is going to start the installation. Click Install

Now wait till installation is complete. Than click Next

Close this window

Exit the setup

Now SQL Server 2008 Express Edition has been installed on your computer an ICON will be on your desktop or simply search "SQL Express 2008" on start menu.

Read More →

Software Requirements and Its types (from Stakeholder)

A thing that is needed or wanted to develop a software. Basically requirements are given by stockholders or person who is involved to develop software.









Two main types from user side:

1. User Requirements
2. System Requirements

• User Requirements

                  User requirement are statements in a natural language plus UML diagrams, of what system is expected to provide to system user, and the constraints under which it must operate.

In short, user requirements are totally written for user.

• System Requirements

                  System requirements are more detailed description of software systems functions, services and operational constraints. The system requirements document should define exactly what is to be implemented. It may be part of contract between system buyer or user and software developers.

In short, system requirement is basically a contract document in which software developer wrote detailed description of services given to user. 

Read More →

Software Requirements and Its types (from Developer)

A thing that is needed or wanted to develop a software is called software requirement. Basically requirements are given by stakeholders or person who is involved to develop software.

Two main types from developer side are:

1. Functional Requirements
2. Non-Functional Requirements

• Functional Requirements:

They are statement of services the system should provide, how the system reacts on a particular set of inputs and how the system should behave in particular situations. In some cases, the functional requirements may also explicitly state what the system should not do. In short, the boundaries in which we have to develop our software.

• Non-Functional Requirements:

These are constraints on the services or functions offered by the system. They include timing constraints, constraints on the development process and constraints imposed by standards.

In short, It elaborate the performance characteristics of functional requirements. 

Read More →

Unified Model Language (UML)

The Unified Modeling Language (UML) is a general-purpose modeling language in the field of software engineering, which is designed to provide a standard way to visualize the design of a system.
We use this language in System Modeling which is the phase of Requirement Engineering.




Basically five ways to write model language.

1. Activity Diagram
2. Use Case Diagram
3. Sequence Diagram
4. State Diagram
5. Class Diagram

Read More →

Requirement Engineering - Its Activities

Requirements engineering refers to the process of formulating, documenting and maintaining software requirements it is the sub-field of Software Engineering.

Requirement Engineering in used when we / department develop any software. But its not necessary in every software project.

  Around 7 activities are involved in requirements engineering:

1. Requirements inception or Requirements elicitation
2. Requirements identification - identifying new requirements
3. Requirements analysis - checking requirements and resolving stakeholder conflicts
4. Requirements specification - documenting the requirements in a requirements document
5. System modeling - writing requirements in Unified Model Language (UML)
6. Requirements validation - checking that the documented requirements and models are consistent and meet stakeholder needs
7. Requirements management - managing changes to the requirements as the system is developed and put into use

Read More →