13 Jul 2017

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

Important Computer Awareness for IBPS Exams 2017 (Day-4) – DBMS Part-4:
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 4

Difference between DBMS & RDBMS:
                    DBMS         
                            RDBMS  
1. DBMS store data as file

1.RDBMS stores data in tabular form
2. Data generally stored in hierarchical form Or navigational form.
2. In RDBMS, tables have an primary key and the data values are stored inform of tables.
3. Normalization is not present in DBMS

3. Normalization is present in RDBMS
4. DBMS doesn’t apply any security with regards to data manipulation.
4. RDBMS defines integrity constraints for
    purpose of ACID properties.
5.  XML, file systems

5. My SQL , Sql server, ORACLE.

Few Basic Definitions:
1. XML:
XML stands for eXtensible Markup Language.
XML was designed to store and transport data.
XML was designed to be both human- and machine-readable.

2. File systems:
A file system is the methods and data structures that an operating system uses to keep track of files on a disk or partition; that is, the way the files are organized on the disk. The word is also used to refer to a partition or disk that is used to store the files or the type of the file system.
File system allows accessing various data.

3. My SQL:
MySQL is an open source relational database management system (RDBMS) based on Structured Query Language (SQL). MySQL as the relational database management system and  PHP as the object-oriented scripting language.

4. SQL server:
SQL server is Microsoft's relational database management system (RDBMS). It is a full-featured database primarily designed to compete against competitors Oracle Database (DB) and MySQL.

5. Database schema:
A database schema is the skeleton structure that represents the logical view of entire database.In simple terms we say that logical view of database is called schema.

Types:

1. Physical database schema:
This schema pertains to the actual storage of data and its form of storage like files, indices, etc. It defines how the data will be stored in a secondary storage.
2. Logical database schema:
This schema defines all the logical constraints that need to be applied on the data stored. It defines tables, views, and integrity constraints.
Instance:
At particular moment, if a data is been stored then it is said to be instance.

ONE LINER:
1. In RDBMS data stored in – Tabular form
2. Normalization is absent in – DBMS
3. My SQL, SQL server, Oracle are the examples of-   RDBMS
4. File system- allows to access various data
5. Logical view of entire data base is-   Schema
6. Which database schema stores as files, records- Physical database schema
7. Logical database schema stores in form of-   Tables, views, integrity, constraints.