Bank Exams Exam  >  Bank Exams Notes  >  IBPS Clerk Prelims 2024 Preparation  >  DBMS - Basics, Terms & Points to Remember

DBMS - Basics, Terms & Points to Remember | IBPS Clerk Prelims 2024 Preparation - Bank Exams PDF Download

1 Crore+ students have signed up on EduRev. Have you? Download the App

What is DBMS?

  • Data: is any input which has been processed. It can be in numeric, alphabetic or alphanumeric form. Try to imagine data as physical files…the kind of dusty files found in government offices.
    This processed data (or dusty files) needs to be stored and kept somewhere, so that when we need them we can easily retrieve it.
  • Database: is simply a ‘place’ where all the data are collected and stored in an organized manner.
    Think of it as a collection of many steel racks, like the ones found in old government offices! All the files/data are kept according to their serial numbers/file/folder names (or any other identification style), and stored in the racks/database.
  • Management system: In government officers, there are peons who are responsible for keeping the files in the right place, bringing required files to the senior officers, putting it back again after updating the files etc., this is nothing but the system of file management in the office.

Some Vapour-ish Ideas are forming about DBMS
Thus, putting down all our ideas in definition form – DBMS is a software,

  • Which helps a user in creating a collection of records and information and storing them on the computer in a systematic way (database),
  • It also helps in organizing, sorting and retrieval of the records/information from the database, when required by the user, to help the user in decision making (management system).

Benefits of DBMS

  • Faster storage and retrieval time
  • Accessing data is easy and fast
  • Data integrity(credibility of the data) and security. In govt. offices, anyone can pick up any file! But DBMS requires password authorization to access important files.
  • Backups and recovery are possible only in digital world, hence today physical files are becoming extinct.

Points to remember in DBMS

  • In DBMS data are stored in relational model, using tables with rows and columns (remember the steel racks!).
  • There are two types of Data Manipulation Languages (DML), Structured Query Language (SQL) and Data Definition Language (DDL).
  • DML are computer languages also known as query language, it is used for accessing and working on the data.
  • In other words, DML (SQL and DDL), are like the languages people use, Hindi or English, in an office to give orders to the peon!
  • Data redundancy: which means there are no duplications of data. No multiple files of the same kind.
  • Data dictionary: is like a normal dictionary, but containing metadata.
  • Metadata: contains information about all the data in the DBMS.
  • The Keys: Primary key is used to identify a particular or specific record (file). It is unique to a particular file.
  • Foreign Key makes a connection between a component (field) in one table with a component identified by a primary key.
  • Relational database: is the kind of database model, where there are logical connections between the various files, which are kept in tables.

For example:
In the given diagram, the information is stored in tables (with rows and columns), in this particular case in two relational tables.

  • Every column has a Field name (employee ID, first name, last name, e-mail ID, Department ID and Department name).
  • The relation between the two tables is created by the field ‘Department ID’, which connects the Employees name/ID/e-mail to a particular Department like HR or software or accounts.DBMS - Basics, Terms & Points to Remember | IBPS Clerk Prelims 2024 Preparation - Bank Exams
The document DBMS - Basics, Terms & Points to Remember | IBPS Clerk Prelims 2024 Preparation - Bank Exams is a part of the Bank Exams Course IBPS Clerk Prelims 2024 Preparation.
All you need of Bank Exams at this link: Bank Exams
Are you preparing for Exam? Then you should check out the best video lectures, notes, free mock test series, crash course and much more provided by EduRev. You also get your detailed analysis and report cards along with 24x7 doubt solving for you to excel in exam. So join EduRev now and revolutionise the way you learn!
Sign up for Free Download App for Free
296 videos|297 docs|179 tests

Up next

296 videos|297 docs|179 tests
Download as PDF

Up next

Explore Courses for Bank Exams exam
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev
Related Searches

Important questions

,

pdf

,

Previous Year Questions with Solutions

,

practice quizzes

,

DBMS - Basics

,

Sample Paper

,

Free

,

shortcuts and tricks

,

Terms & Points to Remember | IBPS Clerk Prelims 2024 Preparation - Bank Exams

,

ppt

,

Objective type Questions

,

Terms & Points to Remember | IBPS Clerk Prelims 2024 Preparation - Bank Exams

,

Extra Questions

,

DBMS - Basics

,

Exam

,

MCQs

,

study material

,

Semester Notes

,

Summary

,

Viva Questions

,

video lectures

,

past year papers

,

Terms & Points to Remember | IBPS Clerk Prelims 2024 Preparation - Bank Exams

,

mock tests for examination

,

DBMS - Basics

;