Introduction to DBMSClass 11 Information Technology Chapter 2 Notes – Maharashtra Board

Textbook: Information Technology – Class 11 (Balbharati, official free PDF) · pages 20–29

Every train ticket, bank transfer, exam result and social media post lives in a database. This chapter explains what a database and a DBMS are, why they beat paper registers and loose files, the main data types, the relational model with tables, keys and relationships, ACID transactions and the three groups of SQL commands — with working SQL for every exercise.

🎧 Listen to the summary

Summary: Introduction to DBMS

Data are raw facts (one student's score); information is processed data that helps in decisions (the class average). A database is a collection of related data organised so that it can be searched, added to and deleted from efficiently. A DBMS (Database Management System) is the software used to create and manage databases — MySQL, PostgreSQL, Oracle, SQL Server, MS Access, IBM DB2 and Sybase are examples.

DBMSs run railway reservations, libraries, banks, universities, credit cards and social networks. Their advantages over separate files are less duplication (redundancy), shared access with permission levels, privacy, backup and recovery, faster application development, data integrity (accurate, consistent data) and security through usernames and passwords.

Each column (field) has a data type: CHAR(n) for fixed-length text, VARCHAR(n) for variable-length text, INT for whole numbers, DECIMAL for numbers with or without a fraction, DATE for day-month-year and TIME for HH:MM:SS. A data model is the logical design of a database; the relational model, which stores data in tables, is the most widely used.

In an RDBMS a table is made of columns (fields) and rows (records or tuples). A primary key uniquely identifies each row; a foreign key in one table points to the primary key of another and creates a relationship — one-to-one, one-to-many (many-to-one) or many-to-many. A transaction is one unit of work and must follow ACID: atomicity, consistency, isolation and durability.

SQL (Structured Query Language) is the standard language of relational databases (ANSI 1986, ISO 1987). Its commands fall into DDL — CREATE, ALTER, DROP (structure); DML — SELECT, INSERT INTO, UPDATE, DELETE (data); and DCL — GRANT, REVOKE (permissions).

Key points to remember

  • Database = organised collection of related data; DBMS = software to create and manage it
  • Data → processing → information; information helps decision making, raw data does not
  • Advantages: less redundancy, data sharing, privacy, backup and recovery, integrity, security, faster development
  • CHAR is fixed length, VARCHAR is variable length; both take the size in brackets
  • INT for whole numbers, DECIMAL for numbers like 75.56, DATE for dates, TIME for HH:MM:SS
  • Table = rows × columns; column = field; row = record = tuple
  • Primary key: unique and never empty; foreign key: refers to another table's primary key
  • Relationships: one-to-one, one-to-many (many-to-one), many-to-many
  • ACID = Atomicity, Consistency, Isolation, Durability
  • DDL = CREATE / ALTER / DROP; DML = SELECT / INSERT / UPDATE / DELETE; DCL = GRANT / REVOKE
Want a teacher to explain Introduction to DBMS?

Get a ✓ Verified tutor for “Introduction to DBMS” — live online or at home. We aim to suggest up to 3 tutors within 24 hours.

Get a tutor for this chapter →

👩‍🏫 Class 11 Information Technology classes — live online, request a call back

Prefer a real teacher? TalentJR teachers take live online classes anywhere in India. Tell us what you need and our team will call you with timings and fees.

Live online classesSmall groups or 1:1 with a teacher, from home, any city.
We call you backOur team asks what your child needs, then shares timings and fees.
Home tutor?We are still building our list of home tutors — ask on the call if there is one near you.

Keep learning