12 Jul 2017

Important Computer Awareness Materials for IBPS Exams 2017 (Day-3)

Important Computer Awareness for IBPS Exams 2017 (Day-3) – DBMS Part-3:
Dear Readers, IBPS Exams are approaching shortly, we all knew that Computer Awareness is one of the important section, which will help you to increase your score easily.
Many of our followers were asking us to provide Important Computer Awareness Notes along with the model questions, here we have planned to provide the Topic wise Important Computer Awareness Materials on Daily basis, and also we will provide MCQs based on these topics daily. Kindly follow us regularly and make use of it.


Database Management Systems (DBMS) - PART 3

Types of DBMS:-

1. Hierarchical DBMS:
In this hierarchical model
(a) it has tree like structure.
(b) A parent can have n- number of children
(c) and children should have only one parent
(d) it follows one-one relationship.

2. Network DBMS (NDBMS):
(a) This NDBMS has multiple owners.
(b) Parent can have many children
(c) children can also have more than one parent.
(d) It follows many-many relationship.

3. Relational DBMS (RDBMS):
(a) RDBMS is in the form of rows and columns.
(b) combination of rows and columns is generally called as table but in RDBMS we call it as Relation.
(c) Data organized in two dimensional tables called Relation.
(d) A row is known as tuple and a column is know as attribute.

4.Object oriented DBMS:
(a) It is similar as RDBMS but differs as shown in table.
(b) Object oriented DBMS combines database with object oriented programming(oops)
(c) Information are in form of objects.

ONE LINER:
1. Hierarchical DBMS has-   Tree like structure
2. Network DBMS follows-   Many-many relationship
3. Data organized in two dimensional tables called -    relation
4. In RDBMS (a) Row is known as- Tuple
                       (b) Column is known as – Attribute
5. MS access works along with – RDBMS
6.  Number of tuples is called – Cardinality
7.  Number of attributes is called – Degree
8.  Collection of related fields is called - Record