Database :

Databases are designed to offer an organized mechanism for storing, managing and retrieving information. They do so through the use of tables. If you’re familiar with spreadsheets like Microsoft Excel, you’re probably already accustomed to storing data in tabular form.

Definition : 

A database is a collection of information organized into interrelated tables of data and specifications of data objects.



Syntax :

CREATE DATABASE database_name

Refer : http://msdn.microsoft.com/en-us/library/ms176061.aspx

Creating new Database from Management Studio :

In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance and then Right-click on Databases, and then click New Database.In New Database, enter a database name and click OK.

Refer : http://msdn.microsoft.com/en-us/library/ms186312.aspx