Tuesday 7 April 2020
DBMS and RDBMS
- Introduction
Database is collection of interrelated data which helps in efficient retrival,inserting and deleting of data.
A database is often abbrivated as DB, is a collection of information organized in such a way that computer program can quickly select desired pieces of data
DBMS is software for creating and managing databases. The DBMS provide users and programmers with a systematic way to create, retrive, update, and manage data.
Some examples of DBMS are MySQL,IBM,DB2 etc.
- Applications of DBMS
1} Railway reservation system
Database is required to keep record of ticket booking ,its departure,arrival time etc.
2} Banking
In the 21 century thounds and lakhs of people make thousands and lakhs of transactions without giving a personal visit to bank.
3} Social media sites
We all are active on social media websites to communicte with friends who are far away from us social media has connected millions of people all over world.
Storing users data is an example of DBMS.
Advantages of DBMS are,
1) Data integrity
2) Data Security
3) sharing of data
4) Backup
5) Recovery etc.
Data type in DBMS are,
a} Char
b} Varchar
c} Decimal
d} Int
e} Date
f} Time
- Relational database management system
Unlike DBMS, RDBMS is also a collection of interrelate data its components are
a} Table
b} Field
c} Record
d} Key
Structured query Language is computer language for storing, manuplating and retreiving data stored in RDBMS
using SQL we can
1.Create new databases
2.Create new tables in database
3.Insert records in database
4.Retrieve data from database
5.Update records in database
6.Create views in database
7.Execute queries against database and many others
Given below are DDL statements or commands which are used for carrying their respective processes.
DDL commands and their use
Q.CREATE DATABASE
A.{Creating database}
A.{Creating database}
Q.CREATE TABLE
A.{Creating new table}
A.{Creating new table}
Q.ALTER TABLE
A.{Modifying table}
A.{Modifying table}
Q.DROP TABLE
A.{Deleting table / database}
A.{Deleting table / database}
Given below are DML statements or commands which are used for managing data within table
DML Commands and their uses
Q.SELECT
A.{Extracting data from table}
A.{Extracting data from table}
Q.UPDATE
A.{Updating data in table}
A.{Updating data in table}
Q.DELETE
A.{Deleting data from table}
A.{Deleting data from table}
Q.INSERT INTO
A.{ Inseriting data into table}
A.{ Inseriting data into table}
Given below are DCL commands which are used for controlling user access in database its is typically related to database security issues dealing with rights and permissions of accessing database
DCL Commands and their uses
Q.GRANT
A.{Granting access}
Q.REVOKE
A.{Controlling rights of user access}
A.{Granting access}
Q.REVOKE
A.{Controlling rights of user access}
{ DDL = Data definition language
DML = Data manipulating language
DCL = Data Control language}.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment
Please don't be a jerk
Post comments related to articles only
Spamming is strictly prohibited!