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 ?
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
|