Question

Explain about RDBMS. Include advantages/ disadvantages. Compare DBMS vs RDBMS. Explain about Oracle as well.

Answer 1

Database Management System, Relational Database Management System, Oracle

Step-by-step explanation:

Relational Database Management Systems is a set of programs that allows Information Technology groups with the ability to create, administer. and update and relates with relational database

RDBMS store data by way of Tables, they use Structured query language to relate with the database

The advantages of relational Database are as follows

• Data structure:the table format in tables used in RDBMS is understandable which provides a structural manner and organized manner
• Flexibility: By updating data is more better since , additional changes only needs to be done in one place

The disadvantages Includes

• A special software must be used to implement RDBMS
• The Cost of execution for the software to be installed

The Difference between DBMS and RDBMS are

• RDBMS can work with multiple users, while a DBMS can only have one user at a time

• RDBMS need more software and hardware than a DBMS
• RDBMS can manage or use any amount of data, but a DBMS can only manage a small amount of data

ORACLE: The Oracle database is multi-model database that run may instances or programs at a time. an example were an oracle is used for is the Online transaction processing (OTP)

Answer 2

RDBMS stands for Relational Database Management System and DBMS stands for Database Management System.

Step-by-step explanation:

DBMS stores data in file format. it does not include the relation ships among the data. There is no data integrity and atomicity. RDBMS stores data in tabular format and each row in table is uniquely identified by the primary key. It follows ACID(Atomicity, Concurrency, Integrity, Durability) Principles and very robust.it also makes use of Normalization.

RDBMS is more useful for data maintenance that DBMS. we can easily retrieve data using RDMS as it follows some relation ships between data using foreign keys .

Oracle is one kind of RDMS.Here we store data in the form of tables. Select,Insert,Update,Delete commands are used for data operations