TalentJR apps
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.
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).
Get a ✓ Verified tutor for “Introduction to DBMS” — live online or at home. We aim to suggest up to 3 tutors within 24 hours.
You scored 75.56% in the exam. Which data type should store it?
Answer: DECIMAL — e.g. DECIMAL(5,2), which holds up to 999.99. INT would drop the .56, and text would stop you calculating averages.
A bank moves ₹500 from account A to account B. The money is taken from A, then the power fails before B is credited. Which ACID property protects you?
Answer: Atomicity. The two steps form one transaction; since it did not finish, the DBMS rolls back the debit from A, so no money disappears. Durability then ensures that once a transfer does complete, it is not lost.
Write SQL for a one-to-many link: one city, many customers.
Answer: CREATE TABLE city (city_id INT PRIMARY KEY, city_name VARCHAR(40)); CREATE TABLE customer (cust_id INT PRIMARY KEY, cust_name VARCHAR(40), city_id INT REFERENCES city(city_id)); Many customer rows may hold the same city_id, but each customer row has only one.
Table marks(roll INT, name VARCHAR(30), it DECIMAL(5,2)). Show names of students who scored 60 or more in IT.
Answer: SELECT name FROM marks WHERE it >= 60; — SELECT is a DML command; WHERE filters the rows.
| Command (group) | What it does | Example |
|---|---|---|
| CREATE TABLE (DDL) | Makes a new table with columns and types | CREATE TABLE book (id INT PRIMARY KEY, title VARCHAR(50)); |
| ALTER TABLE (DDL) | Changes a table's structure | ALTER TABLE book ADD price DECIMAL(6,2); |
| DROP TABLE (DDL) | Deletes the whole table | DROP TABLE book; |
| INSERT INTO (DML) | Adds a new row | INSERT INTO book VALUES (1, 'Wings of Fire', 299.00); |
| SELECT (DML) | Reads rows from a table | SELECT title FROM book WHERE price > 200; |
| UPDATE (DML) | Changes values in existing rows | UPDATE book SET price = 250 WHERE id = 1; |
| DELETE (DML) | Removes rows (table stays) | DELETE FROM book WHERE id = 1; |
| GRANT (DCL) | Gives a user permission | GRANT SELECT ON book TO riya; |
| REVOKE (DCL) | Takes a permission back | REVOKE SELECT ON book FROM riya; |
Solve each one in your notebook first. Then open the solution and compare every step.
1. Q.1 (1) Which of these is NOT a valid data type: graphic, date, number, text? (2) A student wants a pincode field — which data type? (3) Primary key — 'is also called foreign key' or 'uniquely identifies a record'? (4) A database has — only one record / only a single table / one or many tables / none of these?
Answer: (1) Graphic is not valid (date, number and text are). (2) A text type — CHAR(6), since a PIN code always has 6 digits and is never used in calculations (INT would also store it, but text is the better choice). (3) Uniquely identifies a record. (4) One or many tables.
2. Q.2 Bus reservation: give data types for Passenger Name, Age, Gender, Mobile Number. Q.3 State what INSERT and UPDATE do.
Answer: Q.2 Passenger Name — VARCHAR(40); Age — INT; Gender — CHAR(1) (e.g. 'M', 'F', 'O'); Mobile Number — CHAR(10) (digits, but not used for maths). Q.3 INSERT (INSERT INTO) adds new rows of data to a table. UPDATE changes values in rows that already exist, usually chosen with WHERE.
3. Q.4 Create tables with suitable data types and primary keys: (1) Movie (registration_no, movie_name, release_date) (2) Actor (actor_id, actor_name, birth_date). (The book prints 'Registeration' and 'Realease'.)
Answer: CREATE TABLE movie (registration_no INT PRIMARY KEY, movie_name VARCHAR(60), release_date DATE); CREATE TABLE actor (actor_id INT PRIMARY KEY, actor_name VARCHAR(50), birth_date DATE); registration_no and actor_id are unique for each row, so they are the primary keys.
4. Q.5 Table Stationary (the book's spelling of stationery): S_ID, S_Name, C_Name, Price, Quantity with rows 001 NoteBook ABC 20 50; 002 Pencil box XYZ 10 80; 003 A4Pages rim PQR 600 2. (1) Write SQL to create it. (2) Insert the records. (3) Delete the table.
Answer: (1) CREATE TABLE stationary (s_id CHAR(3) PRIMARY KEY, s_name VARCHAR(30), c_name VARCHAR(30), price DECIMAL(8,2), quantity INT); (2) INSERT INTO stationary VALUES ('001', 'NoteBook', 'ABC', 20, 50), ('002', 'Pencil box', 'XYZ', 10, 80), ('003', 'A4Pages rim', 'PQR', 600, 2); (3) DROP TABLE stationary; Note: DELETE FROM stationary; would only empty the rows; DROP TABLE removes the table itself.
5. Q.6 Answer: (1) Define a database. (2) Advantages of a DBMS. (3) What is a data model? (4) What is a primary key? (5) What is DDL?
Answer: (1) An organised collection of interrelated data that allows quick retrieval, insertion, updating and deletion — e.g. a school's student records. (2) Reduces redundancy, allows sharing with authorisation, privacy, backup and recovery, data integrity, security through login, and faster development of applications. (3) The logical structure of a database: how data items are linked, stored and processed — hierarchical, network or relational; relational is most used. (4) One or more columns whose value is unique for every row and not empty, e.g. roll_no in a student table. (5) Data Definition Language — SQL commands that define or change the structure of a database: CREATE, ALTER, DROP; they take effect immediately.
6. Q.7 A company table has Employee number (the diagram shows Employee Name), Last name, Date of birth, Address. Give data types. Q.8 Select three valid relationships: one to one, one to two, one to many, many to two, many to many, one to three. Q.9 Command to remove access rights; command that extracts data from a table.
Answer: Q.7 Employee number — INT (or Employee Name — VARCHAR(40)); Last name — VARCHAR(30); Date of birth — DATE; Address — VARCHAR(100). Q.8 One to one, one to many, many to many. Q.9 REVOKE removes access rights; SELECT extracts data.
Read the question, answer it in your head, then tap the card to check. 20 cards.
15 questions. Tap an option — you will see at once if it is right and why.
1. The average marks of a class is an example of…
Answer: C. It is worked out (processed) from individual scores.
2. Which is NOT a DBMS?
Answer: B. Inkscape is a vector graphics program.
3. Storing the same data in many files leads to…
Answer: C. A DBMS keeps one copy.
4. Which data type suits a student's name?
Answer: C. Names vary in length.
5. Which data type suits a percentage like 82.5?
Answer: A. It has a fractional part.
6. A row of a table is also called a…
Answer: B. Row = record = tuple.
7. Which key uniquely identifies each row?
Answer: B. Unique and not null.
8. A field that refers to another table's primary key is a…
Answer: D. It links two tables.
9. One city with many customers is a…
Answer: B. City is the 'one' side.
10. Which ACID property means 'all or nothing'?
Answer: B. Half-done work is rolled back.
11. Which ACID property keeps committed data safe after a crash?
Answer: A. Committed results persist.
12. CREATE TABLE belongs to…
Answer: D. It defines structure.
13. Which command extracts data from a table?
Answer: C. SELECT is DML.
14. Which command removes a user's privileges?
Answer: B. REVOKE is DCL.
15. SQL became an ISO standard in…
Answer: A. ANSI came first, in 1986.
Get a ✓ Verified tutor for “Introduction to DBMS” — live online or at home. We aim to suggest up to 3 tutors within 24 hours.
Done with the notes? Revise Introduction to DBMS the fun way: match key terms, beat the 60-second lightning round and spot true or false facts. Every game uses only this lesson, so each round is real exam revision.
⭐ 0 XP⏱ About 40 minutes
Get a ✓ Verified tutor for “Introduction to DBMS” — live online or at home. We aim to suggest up to 3 tutors within 24 hours.
Sign in free to see the answers to the textbook exercise of Introduction to DBMS.
Sign in to see solutionsStuck on a question? Type it, 🎤 speak it or 📷 snap a photo of it and get simple, step-by-step help with “Introduction to DBMS” — important questions, a quick quiz, revision notes — in English, मराठी or हिंदी.
Sign in with Google to ask the AI tutor. It's free — 20 questions a day, one TalentJR account.
Sign in to askPrefer 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.