Introduction to Database Management System(DBMS)

Data in DBMS: 
  • Data is raw facts or unprocessed values.
  • it can be in the form of numbers, characters, symbols, images, graphics, etc.
  • Data is input given by the computer by the users.
  • It is meaningless on its own.
  • example : 10061995 - Just a number (we don't know what it means).
Information in DBMS:
  • Process data us called information.
  • It is meaningful and useful.
  • information can be reproduced again and again.
  • example: 10061995- If we know it's someone's date of birth, it becomes meaningful information.
What is Database?
A database is a file that is used to store a collection of organized data which can be easily accessed, managed, and updated.
Key points:
  • Database stores data in a structured form (like tables).
  • It helps in quick retrieval and processing of data.
  • Data in a database can be added, deleted, modified, and searched easily.
  • Example: A school database may store: (Student names, Roll numbers, Marks and Addresses). 
  • A library database stores(Book names, Author names, and Borrower's details).

Real life Examples
Area What is stored
Hospital Patient records
Bank Account details, transactions
Railway Train schedules, passengers bookings

What is DBMS?
  • A Database Management System(DBMS) is a software that helps to store, manage, retrieve, and manipulate data in a database. 
  • It provides an easy and efficient way to create, update, and access the data.
  • example of DBMS: (MySQL, MS-Access, Libre office base, Oracle, etc.)
Advantages of using DBMS: 
1. Organization Powerhouse: 
  • DBMS helps organize data properly, replacing messy spreadsheets and repeated information.
  • Ensures every piece of data is in its correct place.
  • example: Jaise ki ek proper register bana lena jisme sab kuch clearly likha ho.
2. Efficiency Champion :
  • DBMS works like a fast search engine.
  • It helps find specific data quickly(e.g., student marks, customer records).
  • Saves time and effort in searching data.
  • Jaise Google search engine- ekdum fast result deta hai.
3. Security Guardian: 
  • DBMS ensures strong data security.
  • Only authorized users can view, edit, or delete data.
  • Protects sensitive information.
  • Jaise password protect system.
4. Integrity Enforcer: 
  • Maintain data accuracy by enforcing, rules and constraints.
  • Prevent data errors and inconsistencies.
  • example : Jaise form fill karte waqt kuch fields compulsory hote hain.
5. Sharing Made Simple:
  • Allow multiple users to access and update data at the same time with the most current information.
  • example : Jaise Google docs ko ek saath kai log edit karte hain.
6. Scalability Superhero
  • Can handle growing data needs easily. 
  • Allows adding more users and data without affecting performance.
  • Jaise mobile app jisme aage chalke aur log judte hain, fir bhi smoothly chalta hai.
7. Backup and Recovery Saviour: 
  • Provides backup and recovery options.
  • Protect valuable data from accidental loss or unforeseen events.
8. Advanced Analysis Allay: 
  • Supports complex data analysis and reporting.
  • Helps extract useful insights from data for decision-making.
  • example: Jaise sales report banana month wise.
9. Cost-Effectiveness Champion:
  • Though initial setup might be costly, it saves money in the long term.
  • Improves efficiency, reduces errors, and manages data better.


Comments

Post a Comment

Popular posts from this blog

Class IX th :IT(INFORMATION TECHNOLOGY)-402

 Class IX PART A: Employability Skills Unit 1: Communication Skills SESSION 1: Communication Cycle Exercise 1 1. List the main components of communication process. The main components or elements of communication process are sender, message, encoding, communication channel, receiver, decoding and feedback. 2. Who is responsible for the encoding of the message? Encoding of the message is done by the sender before sending it to the receivers. 3. Who is responsible for decoding the message? Decoding of the message is done by the receiver after receiving the message. 4. List 3 scenarios of technology based communication? Three scenarios of technology communication are conversation over telephone, online chat and video conferencing. 5. What do you mean by the channel of communication? Give some examples. The medium of communication is called communication channel such as oral, written, technology based. Exercise 2 1. Describe a scenario where all the major factors of effective commun...
Read more

Class-X Computer/IT- (402)

   PART-A: Employability SKILLS Ch-1(Communication Skills)       What is Communication?         Communication is the process of sharing ideas, thoughts, feelings, or information between two or more people so that they can understand each other clearly. It can happen through speaking, writing, body language, or using technology.                                                     In other words Communication means exchanging information so that both sender and receiver understand each other properly. What is Communication skills? Communication skills means the ability to express your thoughts, feelings, and information clearly and effectively to others- by speaking, writing, or using body language. Examples: 1. When you speak clearly and the other person understand you - that is good communication.  ...
Read more

Self-Management Skills-II

Image
       PART-A: Employability SKILLS       UNIT-2 (Self- Management Skills-II) Session-1 (Stress and its Effects) Introduction to Self Management: Self management means managing yourself to achieve your goals and targets. or Self- management means handling thoughts, and actions in a positive and effective way. It includes self-control, self- motivation, and goal setting. People with strong self-management skills are often more successful, both in their personal and professional lives. Employers highly value individuals with this skill. Meaning of Managing Oneself Every task begins with thinking and a plan to do it. Example: While preparing for exams, we:   Plan our study time and materials.   Decide which topics are more important.     Follow a schedule (time table).   This process is an example of self-management. Importance of Self-Management Self-management helps us achieve our goals effectively. Many peop...
Read more