Question 1
Differentiate a field and a record.
A field is one attribute or column, such as Author. A record is one complete row of related field values for a single book.
What to learn
Distinguish data from information and understand databases, DBMS, data models and relational terminology. Tables contain records and fields; keys help identify and connect records.
- Data are raw facts; information is data organised to answer a question.
- A DBMS stores, organises and retrieves data.
- A relational database uses tables with rows and columns.
- A primary key uniquely identifies a record; a foreign key links related tables.
Practical activity
Design a Library table with BookID, Title, Author and Available fields. Identify the primary key and explain why Title alone may not uniquely identify a book.
Use your school’s prescribed software version and teacher instructions. Keep personal information out of public practice files.
Solved CBSE-style questions
These questions and answers are original practice written for this guide; they are not copied from past papers.
Question 2
Why is BookID a better primary key than Title?
Different books can share a title, but a unique BookID can identify each record without ambiguity.
Question 3
What is a DBMS?
A Database Management System is software used to define, store, manage and retrieve data in databases.
Revision checklist
- Can I explain the key terms without memorising a definition alone?
- Can I complete the listed practical task and describe each step?
- Can I apply the idea to a new example and explain why my answer works?
Aligned to the CBSE 2026–27 syllabus outline. Check the official subject curriculum and your school’s textbook/material for the prescribed scope.