DBMS Tutorial
In this new tutorial we see about database management system(DBMS), In this tutorial, we update all concepts in DBMS from basic to advance level.
Why We Study This?
The person is looking to get a job from multinational companies or IT companies the most preferred skills are noted but DBMS.
The average salary for a Database administrator is ₹505968.
In our tutorial, we explain all required topics of DBMS such as introduction, ER diagrams, ER model, keys, join operation, relational model, SQL queries, data storage, transition management and etc...
What Is Database?
The database is a collection of related data in the form of tables, it is also called as organizing the data in the form of tables.
For example: The ABC college organizes the details of all teachers and students in separate tables and it is easy to get the information for the database.
Database Management System
1) Database management system is a type of PC software that is used to manage the data are in the database and also insert new data to the database or delete exiting data from the database. For example: Mysql, Oracle, and MS Access are the major software that is used for DBM.
2) DBMS provides many operations like database creation, table creation, inserting data, delete data from the database.
3) It provides strong protection to our data which are stored in a database.
Main Uses of DBMS
- Data Definition
- Data Updation
- Data Retrieval
- User Administration
- Security To Our Data
Advantages of DBMS
- Controls Database Redundancy
- Data Sharing
- Easily Maintenance
- Reduce Time
- Backup
- Multiple User Interface
- Great Security
Disadvantages of DBMS
- Cost Of Hardware And Software Is So High
- Requires Large Space
- Complexity
- Higher Impact Of False Handle
0 Comments