DBMS Basics: Introduction to Database Management System

-

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 to 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:
  • Processed data is called information.
  • It is meaningful and useful.
  • Information can be reused multiple times.
  • Example: 10061995- If we know it's someone's date of birth, it becomes meaningful information.
What is Database?
A database is an organized collection of data that 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.)
Popular Database Software: 
1. Microsoft Access: Microsoft Access is a user-friendly database software used to store and manage data in small businesses and schools. 
2. MySQL: MySQL is an open-source database system used to manage data for websites and online applications(Online Shopping -Amazon)
3. Oracle Database: Oracle Database is a powerful database used by large companies to handle a large amount of data.
4. MongoDB: MongoDB is a NoSQL database used to handle large and unstructured data like social media content. 


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: 
  • Maintains 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:
  • Allows 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
  • It 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.
What is RDBMS?
  • RDBMS stands for Relational Database Management System. 
  • It is a type of database system that stores data in the form of tables (rows and columns). In a RDBMS, data is stored in a structured format, and relationships between different tables are established using keys. This makes data retrieval more efficient and avoids duplication. 
  • Example: A school database that has separate tables for students, Subjects, and Marks, which are linked together using a unique student ID.
Difference between DBMS vs RDBMS:
Features               DBMS                                                                   RDBMS
Structure        Stores data as files or simple tables     Stores data in tables with defined relationships
Relationships       No relationship between data         Tables are connected using relationships
Data Redundancy    More duplication of data              Less duplication (better control)
Security                     Less Secure                                  More Secure
Users                        Support single user mostly           Supports Multiple users
Examples            File-based system, XML MS-Access      MySQL, PostgreSQL, Oracle, SQL Server
 
Basic Components of Database:
In a RDBMS, the following four components help in managing and organizing data efficiently. 
1. Table: A Table is the basic structure of a database where data is stored in the form of rows and columns.    
 Parts of a Table:
1. Columns: The columns of a table are called
 

Comments

Post a Comment

Popular posts from this blog

ICT-SKILLS Notes for Class 9

-
Ch-3 (ICT-SKILLS)    What is Computer System? A Computer is an electronic machine that takes input from user, process the data and gives the desired result (output). It performs both mathematical and non-mathematical operations. Computer can be classified into two categories. 1. Hardware: Any physically components that we can touch, feel,& view are called hardware. Ex- Monitor, Printer, Motherboard, RAM, SSD, Pen drive, Mouse,etc. 2. Software : A Software is a set of programs or instructions that tells the computer what to do. Ex: MS-Word, Excel, PowerPoint, Scratch, etc. Software are two types: System Software: It is a type of program that is designed and managed to all hardware devices'- Operating System(Windows, 7,10,11) Application Software: It is a type of software designed to help users perform specific task. Ex: MS-Word, MS-Excel, Photoshop, CorelDRAW. Hardware categories four types   1. Input Device: Input devices are the devices that are used to enter dat...
Read more

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

Entrepreneur Skills Notes for Class 9 Students

-
  Business: Business is an organized effort to provide goods and services to consumers in exchange for profit, while managing risks and contributing to economic growth.  Business ownership : It is the legal right and responsibility of an individual or group to operate a business, make decisions, and bear its profit or losses.  Types of Business Ownership  Sole Proprietorship: A Sole Proprietorship is a business owned and managed by a single person, who bears all profits, losses, and risks.   Ex: A local grocery shop, Freelance tutor or private teacher Partnership: A partnership is a type of business owned and managed by two or more person, who share the profits, losses , and responsibilities according to a mutual agreement.  Ex- Law Firms, Accounting firms, Small restaurants or retail shops run by multiple people Corporation: A Corporation is a type of business that is a separate legal entity from its owners(shareholder), with limited liability, and ...
Read more