Tuesday 24 March 2015


What is RDMS ?

                        Relational Database Management System are data management system that manage or Maintain data using sql query and indices in tables. Relationships may be created and maintain across and among the data and tables and maintain the relational records.

In a relational database, relationships between data to data items and data to tables and tables to views are expressed by means of tables. 
 
 

What is Sql Server ?

         Sql server is a very powerful tools.sql is stand of Structured Query Language.
This tool is provided by Microsoft Corporation. Microsoft Company is a very good and world largest no.1 software company in IT industry.

Using this tool we can manage all data in database (in Tabular format).providing this tools and using sql query manage data in proper way.


Tables : - In Simple word table is a combination and collection of rows and columns.



SR.NO.
ITEM NAME
QUANTITY
RATE
AMOUNT
1.
Abc
10 Pcs.
20.00
200.00
2.
Xyz
100 Pcs.
30.00
3000.00
3.
Axd
200 Pcs.
50.00
1000.00