Question

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

Answer 1

Answer:

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

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

Answer 2

Answer:

Database Management System,  Relational Database Management System, Oracle

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)