A Database is a collection of raw data which have relation between them and which can be managed, updated and manipulated easily.
DBMS : Database Management System is the software or system which allow us to creat, manipulate and update a record stored in database. By this we can also provide security to Database. Softwares used in this languages are : MySql, Oracle, DB2.0 etc.. We are going to do more with Relational Database System
A table stored in database is known as Relational DBS. It is collection of data which can be easily access, manipulate and update. A table is also a convinient representation of data.
In tables Rows are known as Tuples.
Colums are known as Attributes.
USER ID | NAME | ROLL | SECTION |
1130**** | Priyanka Jha | 20 | K2207 |
1120**** | Tanmay B. | 22 | B1202 |
1110**** | Prince Kumar | 19 | C2207 |
1100**** | Fayaz Ahmad | 35 | E2108 |
By above table we can see that how can we store a record of students in table
ENTITY : A single record in a record is known as entity. For example, A related record is –
1140**** | Vivek Kumar | 19 | C2207 |
This data will be known as an entity.
FIELD : A table consist of several records which can be broken into more parts, known as fields.
eg.- Above table student contains 4 fields : user id, name, roll, section.
Attribute : A column consist of particular data is known as attribute.
USER ID |
1130** |
1120** |
1110** |
1100** |
This is the data stored in particular attribute.
We Will be going through only DBMS commands,
1- DATA MANIPULATION LANGUAGE
A- INSERT
B- UPDATE
C- DELETE
D- SELECT2- DATA DEFINITION LANGUAGE
A- CREATE
B- ALTER
C- DROP
3- DATA CONTROL LANGUAGE
A- GRANT
B- REVOKE
For More Go To Next Post in DBMS