Differentiate between DBMS and RDBMS.Types of DBMS.

DBMS stand for Database Management System, which consist n number of tables there is no relationship between another table. RDMBS stand for Relational Database Management System, which having the relationship with other tables. The Relationship between tables in DBMS is Physical and the relationship in RDBMS is Logical.

DBMS does not support Data Integrity and RDBMS support Data integrity. RDBMS support Structural Independence and Advanced Query Capabilities while DBMS does not support this. DBMS does not support Security while RDBMS supports Security on Databases. 

 Types of DBMS:

 A Database management system is a hardware/software system that consists of a database and necessary programs to carry out database management activities rolled in one. Users do not have to interact with the data files directly but through a language interface. Using a database management system for data storage and manipulation relieves the users from the bookkeeping responsibilities.

 For simple data manipulation users do not have to write programs, instead the programs are already written in the database which can be invoked by user by issuing one or more command in a database language. For more complex manipulations programming interface is also included in a DBMS.

 Most of the currently popular DBMS have more complex architecture. Moreover not only human users but other programs also can interact with the DBMS. In this arrangement the database is commonly known as back-end while the user program is called front-end. Front-end applications can be designed to suite any individuals or organisations specified data-interaction needs.

With Different types of DBMS can take different approaches manage the data? Each approach constitutes a database.

Oracle 11g step-by-step Installation Guide with Screenshots

1. Select installation method

Following two installation methods are available:

• Basic Installation – Choose this to perform the full Oracle Database 11g installation with standard configuration options. You can use only filesystem for storage in this option.
• Advanced Installation – This gives your full control over the installation, including the ability to choose Automatic Storage Management. Select this option as shown below.

Fig - Select Installation Method (Click on the image to enlarge it)

2. Specify Inventory directory and credentials

Enter the following information:

• Enter the inventory directory: /u01/app/oraInventory
• Specify operating system group name: oinstall

Fig - Specify Inventory directory and credentials (Click on the image to enlarge it)

3. Select Installation Type

Following three installation types are available:

• Enterprise Edition – Select this option.
• Standard Edition
• Custom

Fig - Select Installation Type (Click on the image to enlarge it)

4. Specify Install Location

Enter the following information:

• Oracle Base: /u01/app/oracle
• Name: Oracle_Home
• Path: /u01/app/oarcle/product/11.1.0

Fig - Select Install Location (Click on the image to enlarge it)

5. Product-Specific Prerequisite Checks

In this screen, the Installer verifies that your environment meets all of the minimum requirements for installing and configuring the products that you have chosen to install. You must manually verify and confirm the items that are flagged with warnings and items that require manual checks.

6. Select Configuration Option

Following three configuration options are available:

• Create a Database – Select this option.
• Configure Automatic Storage Management (ASM)
• Install Software Only

Fig - Select Configuration Option (Click on the image to enlarge it)