SQL Server

SQL stands for Structured Query Language,
It is one of the Microsoft product .it mainly deals with database in the we have three versions ,sql server 2000, sql server 2005 , then sql server 2008 it is the latest version .
The information that we are going to write and stored in the computer system is called as data.
The sql server mainly deals with the data i.e.: informatation, that information was being stored in the system through the sql server.

The sql server mainly deals with 8 concepts:

1. Data
2. Database
3. RDBMS
4. Difference Between DBMS and RDBMS
5. Flat File
6. Data Model
7. Object Based Data Model
8. Record Based Data Model                    

1. DATA:

   The information that has been stored and used in the computer system is called as data.

1. DATABASE ;

     It is the set of software, which takes care of data modification operation like, insert, delete, and update on the database.

1. Insert: in this option we can insert some data into the computer system by giving simple query.
2. Delete: in this option we can delete some data into the computer system which was already exists in the computer database, by giving simple query.
3. Update: in this option we can update the data which was already stored in the database which was going to update, by giving a simple query of update.

DATABASE:

The sql server mainly deals with database,
                     Database means it is a collection of meaningful information stored in an organized manner .with the collection we can do some operation by giving a simple query.

DBMS:
In sql server we have one of the most important feature DBMS
           DBMS means Data Base Management System
 It is a set of software, which takes of database modifications, and operations like (insert ,update, delete ) these are the most important operation which we have mainly done in the sql server.

RDBMS:
 In sql server we have another feature like RDBMS
            RDBMS means relational database management system
It is also same like database management system, but the thing is that the relation will be stored into the database.

Difference between DBMS AND RDBMS in sql server

DBMS
1. In DBMS data is stored in the form of a file and is shown to the user in the form of a two dimensional table
2. In DBMS the relation ship established among the table will not be stored into the database.

RDBMS

1. in the case of RDBMS the relation data is strictly to be stored in the dorm of table and also shown in the form of table
2. In RDBMS the relation ship established will be stored in the database as one of the database object.

FLATFILE in sql server:

        Flat file in one of the concept in the sql server
A flat file is an operation system file and the data stored in the sequential manner, if in the case data in the 100th record needs to be retrieved system has to pass on form the 1st to 99th record, then only to 100th record can be retrieved .random accessibility is not possible which is in the case of database of sql sever. The created file has to attached to the program in which it is created and cannot to be used to some other program, but in the case of a database, ones it is created can be utilized for different programs and different languages.

DATA MODELS in sql server:

                        It is nothing but the structure in which the data stored in the database, there are two important data models existing
1. Object based data model
2. Record based data model

Object based data model:
It is most populated feature in the sql server ie: object based data model .It is the collection of conceptual tool for describing the data, data relationship and data constraints.
 
Record based data model:
It also one of the most populated features in the sql server ie: record based data model
        It is describes the data structures and access techniques of DBMS, object based data model is the concept and record-based data model is the actual representation of the data in the database.
Of all the different object-based models available the most popular model is E/R diagrams and from the various record-based data model the popular and effective model is the relational model.

The scientist called PETER CHEN in 1976 design E/R diagram.
Entity is an OBJECT/PLACE/PERSON/CONCEPT/ACTIVITY about which the enterprise the data, in diagrammatic it is named and represented in the form of the box.

Entity type is s set 0 things, which common properties, and entity instance is a specific individual thing or object.
Dependent entity is the entity, which depends on the existence of anther entity, independent entity, which is not dependent on the existence another entity, dependent entities are called as week entities and independent entities are called regular entities.
An entity can be divided into parts these parts are called sub-entities and entity, which is divided into sub entities or the features of entity.