What is DBMS?
The database is a collection of inter-related data that is used to retrieve, insert and delete the data efficiently. It organizes the data in the form of a table, schema, views, reports, etc. It provides an interface to perform various tasks like creating databases, manipulating of data, updating data, storing data, etc.
Tasks that DBMS allows its user to perform
DBMS allows its user to perform various tasks on a vast variety of data. Operations that a user can perform to update, alter, delete, retrieve data in a DBMS system are discussed below:
- Data Definition: DBMS allows users to create, modify and organize data in the database.
- Data Updation: Users can insert, modify and update actual data.
- Retrieval of data: One can retrieve data using database queries.
What is RDBMS?
RDBMS stands for the relational database management system, it is called so because it uses the relational model for storing, accessing, and retrieving data. This model is based on the twelve rules introduced by E.F. Codd. If the database follows all the rules then it is termed a true relational database (RDBMS). Following are the rules:
- The foundation rule.
- Information rule
- Guaranteed access rule
- Systematic treatment of null values
- Dynamic online catalog based on the relational model
- Comprehensive data sublanguage rule
- View updating rule
- Relational level operation rule
- Physical data independence rule
- Logical data independence rule
- Integrity independence rule
- Distribution independence rule
- Non-subversionon rule
Difference between DBMS and RDBMS
Knowing about the DBMS(database management system) and RDBMS(relational database management system) now we can discuss the difference between them.
|
BYJU's Exam Prep Online Classroom Program
Thanks
#DreamStriveSucceed
Comments
write a comment