INTRODUCTION TO BASIC CONCEPTS OF D.B.M.S.

1.1} DATA è 
Data is the basic building blocks of every DBMS. Data is nothing but facts, figures, statistic, etc. Having NO particular meaning.

   DATA consist of two types.

1.     Qualitative and

2.     Quantitative.

1)    Qualitative è 
It is descriptive information. For ex. “good morning”.

2)    Quantitative è 
It again divided into two types.

2.1) Descript è
It only takes integer value or whole no. For ex.1, 2, 3, 4, 5,

2.2) Continuesè
It only takes continue value. Floating point. ex.1.2, 2.3.

1.2} INFORMATION è
Collection of related data items have NO meaning but if we process on that we will get meaningful information.

For ex. 1 yogesh 2yr  

            
The above ex. Has NO meaning but if we organized them in proper manner. Then they represent meaningful information.

                        For ex. Rno name class

                                       1    yogesh 2yr

Column/field/attribute/Domain. Rows/tuple/record.

1.3} TABLE/RELATION è
Collection of related records or information called as table or relation. For ex. Stud (table/relation)

Rno	Name	Age
1	Yogesh	18
2	Sagar	19

1.4} DATA BASE è
Collection of related table/relation. Is nothing but a database? For ex. Mydata. 
1) Stud (Rno, Name, Age)

                               
2) College (name, phone)

Mydata is database having two tables.

1.5} MANAGEMENT SYSTEM è 
A management system is set of rules and procedure which helps user to create, organized, and manipulate the database.

            
It also help user to add, modify, rename, drop, delete, etc. data items in database.

            
The management system is important because without rules and regulation it is not possible to maintain the database