DBMS Overview

Full form of ORACLE:-  Oak Ridge Automatic Computer &   Logical Engine.

O What is data?

            Data is raw material for creating database or table.

O What is database?

            A database is a organized collection of data.

Difference between DBMS and RDBMS:-

DBMS	RDBMS
In DBMS relationship between two tables or files are maintained programmatically .	In RDBMS relationship between two tables or files can be specified at the time of table creation.
DBMS does not support client / server architecture.	Most of RDBMS support client/ server architecture.
DBMS does not support distributed databases.	Most of RDBMS support distributed database.
In DBMS there is no security of data.	In RDBMS there are multiple levels of security 1.     Logging in at o/s level 2.     Command level 3.     Object level
Each table is given an extension in DBMS.	Many tables are grouped in one database in RDBMS.
DBMS may satisfy less than 7 to 8 rules of Dr.E.F.Codd.	RDBMS usually satisfy more than 7 to 8 rules of Dr.E.F.codd.