What is DBMS?

DBMS stands for ... Database Management System.

This system is assisting us to manage/store the Data accurately and very easiest way

DBMS is a collection of programs which helps to handle the data in following ways..

    * Adding Data
    * Deleting Unnecessery Data
    * Modifying the Existing Record

A DBMS support various functions like data security, data integrity, data sharing, data concurrence, data independence, data recovery etc. However, all database management systems that are now available in the market like Sybase, Oracle, and MS-Access do not provide the same set of functions, though all are meant for data management.

How to Create Database?

Database can be created using following ways:-

1. Using SQL Script
2. Using Wizard
   

SQL Script:-

Create Database statement is used to create a database in SQL Server.

Syntax: 

Following SQL Syntax helps to create a database
 
CREATE DATABASE <database_Name>
 

Sample:

Execute the following Query at SQL Server management studio, it will create a Database named as “TestDB”
 

CREATE DATABASE TestDB

Wizard:-
 

Database can be created using SQL Server management studio, follow the steps given below to create a DB
 

1.    Open SQL Server management studio from Program menu (start Menu)
 
 

2.    Login/connect to the SQL Server by providing proper credentials
 
 

3. After connected to the server, Select the Database Node in the Object Explorer --> Right Click on the Database node, Select “New Database” (refer the Exhibit given below for further reference)
 
 

4.    New Database Wizard will appear as shown below,
5.    Enter the name of the database in “Database name” text field.
 

6.    Click Ok to create the database 

7.    Once it is created, it will be display under database node as shown below

 To Know More about Database, Refer the Article posted at,

http://blog-sqllearning.blogspot.in/2012/08/what-is-database.html
 

What is Database?

Database is a system in which we can store and manage the data in the organized way. It is abbreviated as DB.

It is a Repository in which we can store the collections of data. data are stored in database in the form of tables and other database objects as mentioned below:-

• Table - Combination of rows and columns
• Tables - Collections of Table
• Views - Virtual Table
• Stored procedure & function - collection of logical scripts
• etc.,

Relational Database Management System (RDBMS) helps to access the data information from the database.

Following are the examples of the RDBMS:-

• MsAccess
• SQL Server
• Oracle
• etc.,

Refer the article given below to know about "How to Create a Database"
http://blog-sqllearning.blogspot.in/2012/08/how-to-create-database.html

What is DCL?

DCL stands for.. Data Control Language

DCL Provides the access permission over the data which is stored in the database.

DCL Commands Includes,

• Grant - Command will permission to the user to do specific operations.
• Revoke - command will remove the given permission from the user.

As mentioned above, DCL commands will allow or deny the following operations..
CONNECT
SELECT
INSERT
UPDATE
DELETE
EXECUTE