Database Concepts — NCERT Solutions
CBSE · Class 11 · Informatics Practices
NCERT question answers for Database Concepts, CBSE Class 11 Informatics Practices: 33 textbook questions solved step by step. Covers Exercise.
Interactive on Super Tutor
Studying Database Concepts? Get the full interactive chapter.
Quizzes, flashcards, AI doubt-solver and a step-by-step study plan — built for NCERT solutions and more.
Free trial, no card needed.
The first 17 solutions are open to read. The other 16 are free with a Super Tutor account. Unlock all 33 free in Super Tutor
Exercise
1Give the terms for each of the following:a) Collection of logically related records.
b) DBMS creates a file that contains description about the data stored in the database.
c) Attribute that can uniquely identify the tuples in a relation.
d) Special value that is stored when actual data value is unknown for an attribute.
e) An attribute which can uniquely identify tuples of the table but is not defined as primary key of the table.
f) Software that is used to create, manipulate and maintain a relational database.
Show solution
a) Collection of logically related records.
b) DBMS creates a file that contains description about the data stored in the database.
c) Attribute that can uniquely identify the tuples in a relation.
d) Special value that is stored when actual data value is unknown for an attribute.
e) An attribute which can uniquely identify tuples of the table but is not defined as primary key of the table.
f) Software that is used to create, manipulate and maintain a relational database.
a) Database
b) Meta-data or Data dictionary
c) Primary key
d) NULL
e) Alternate key
f) DBMS (Database Management System)
Not sure why a step works? check your working in Super Tutor
2Why foreign keys are allowed to have NULL values? Explain with an example.Show solution
A foreign key may be NULL when the referencing record has no related record in the master table, or when the relationship is not applicable.
For example, in the GUARDIAN table, if a guardian does not share a phone number, then GPhone can be NULL. Similarly, a foreign key in another table can be NULL if that row does not yet refer to any record in the related table.
Not sure why a step works? check your working in Super Tutor
3Differentiate between:a) Database state and database schema
b) Primary key and foreign key
c) Degree and cardinality of a relation
Show solution
a) Database state and database schema
b) Primary key and foreign key
c) Degree and cardinality of a relation
a) Database state and database schema
- Database schema is the design/structure of the database. It describes table names, columns, data types, constraints and relationships.
- Database state is the current snapshot of data stored in the database at a particular time.
b) Primary key and foreign key
- Primary key uniquely identifies each tuple within its own relation.
- Foreign key is an attribute whose value refers to the primary key of another relation and is used to link two tables.
c) Degree and cardinality of a relation
- Degree = number of attributes (columns) in a relation.
- Cardinality = number of tuples (rows) in a relation.
Not sure why a step works? check your working in Super Tutor
4Compared to a file system, how does a database management system avoid redundancy in data through a database?Show solution
Compared to a file system, a DBMS reduces redundancy by storing related data only once and linking tables through common fields.
For example, in the school database:
- SName is not stored in the ATTENDANCE table because it already exists in STUDENT.
- Guardian details are separated into a GUARDIAN table so the same guardian data is not repeated for siblings.
Thus, a DBMS avoids repeated storage of the same data and reduces data redundancy.
Not sure why a step works? check your working in Super Tutor
5What are the limitations of file system that can be overcome by a relational DBMS?Show solution
The limitations of a file system that can be overcome by a relational DBMS are:
- Difficulty in access
- Data redundancy
- Data inconsistency
- Data isolation
- Data dependence
- Controlled data sharing
A DBMS also makes it easier to store, update, delete, and retrieve data efficiently.
Not sure why a step works? check your working in Super Tutor
6A school has a rule that each student must participate in a sports activity. So each one should give only one preference for sports activity. Suppose there are five students in a class, each having a unique roll number. The class representative has prepared a list of sports preferences as shown below. Answer the following:Table: Sports Preferences
Roll_no Preference 9 Cricket 13 Football 17 Badminton 17 Football 21 Hockey 24 NULL NULL Kabaddi
Show solution
Table: Sports Preferences
| Roll_no | Preference |
|---|---|
| 9 | Cricket |
| 13 | Football |
| 17 | Badminton |
| 17 | Football |
| 21 | Hockey |
| 24 | NULL |
| NULL | Kabaddi |
a) For Roll no 24, the preference field can be NULL if the student is not interested or the preference is unknown. The chapter states that NULL is used for unknown or non-applicable values.
b) For Roll no 17, two preferences are given, so the property of a relation that each tuple must be distinct is violated, and also the rule that each student should give only one preference is broken. We can use a constraint such as a primary key/unique key on the roll number to prevent more than one record for the same student.
c) Yes, the tuple with Kabaddi can exist if it is a valid preference recorded in the table, but the roll number cannot be NULL because each student must be uniquely identified. So the row is invalid as written because the roll number is missing.
Not sure why a step works? check your working in Super Tutor
6aRoll no 24 may not be interested in sports. Can a NULL value be assigned to that student's preference field?Show solution
Yes. If the student is not interested in sports, the preference field can be NULL because it represents an unknown or non-applicable value.
Not sure why a step works? check your working in Super Tutor
6bRoll no 17 has given two preferences sports. Which property of relational DBMC is violated here? Can we use any constraint or key in the relational DBMS to check against such violation, if any?Show solution
The property violated is Property 2 of relations: each tuple in a relation must be distinct.
Since roll no 17 has two different preferences, it means the student has more than one value for the same field, which is not allowed if the rule is only one preference per student.
To prevent this, the Roll_no field can be made UNIQUE and NOT NULL. If one row per student is required, then Roll_no should act as the key. However, the text mainly suggests using constraints like UNIQUE and NOT NULL to ensure each roll number appears only once.
Not sure why a step works? check your working in Super Tutor
6cKabaddi was not chosen by any student. Is it possible to have this tuple in the Sports Preferences relation?Show solution
Yes. A tuple like (NULL, Kabaddi) can exist if the roll number is unknown or not given, because NULL is allowed for a value that is unknown or non-applicable. But if Roll_no is meant to be the primary key, then it cannot be NULL.
Not sure why a step works? check your working in Super Tutor
7In another class having 2 sections, the two respective class representatives have prepared 2 separate Sports Preferences tables, as shown below:Sports preference of section 1 (arranged on roll number column)
Table: Sports Preferences
Roll_no Sports 9 Cricket 13 Football 17 Badminton 21 Hockey 24 Cricket
Sports preference of section 2 (arranged on Sports name column, and column order is also different)
NOTES
Reprint 2026-27
140
INFORMATICS PRACTICES – CLASS XI
NOTES
Table: Sports Preferences
Sports Roll_no Badminton 17 Cricket 9 Cricket 24 Football 13 Hockey 21
Show solution
Sports preference of section 1 (arranged on roll number column)
Table: Sports Preferences
| Roll_no | Sports |
|---|---|
| 9 | Cricket |
| 13 | Football |
| 17 | Badminton |
| 21 | Hockey |
| 24 | Cricket |
Sports preference of section 2 (arranged on Sports name column, and column order is also different)
NOTES
Reprint 2026-27
140
INFORMATICS PRACTICES – CLASS XI
NOTES
Table: Sports Preferences
| Sports | Roll_no |
|---|---|
| Badminton | 17 |
| Cricket | 9 |
| Cricket | 24 |
| Football | 13 |
| Hockey | 21 |
The two tables have the same set of tuples; only the order of rows and order of columns are different. In relational model, the sequence of attributes is immaterial and the sequence of tuples is immaterial. Therefore, the states of both relations are equivalent.
Not sure why a step works? check your working in Super Tutor
8aTo store each item name along with its price, what relation should be used? Decide appropriate attribute names along with their data type. Each item and its price should be stored only once. What restriction should be used while defining the relation?Show solution
Use an ITEM relation.
A suitable structure can be:
- ItemID: integer
- ItemName: string
- Price: decimal/integer
Example: ITEM(ItemID, ItemName, Price)
To store each item only once, use UNIQUE on ItemName or make ItemID the primary key. Since each item should be stored once, the important restriction is UNIQUE for item identity, along with a PRIMARY KEY.
Not sure why a step works? check your working in Super Tutor
8bIn order to generate bill, we should know the quantity of an item purchased. Should this information be in a new relation or a part of the previous relation? If a new relation is required, decide appropriate name and data type for attributes. Also, identify appropriate primary key and foreign key so that the following two restrictions are satisfied:i) The same bill cannot be generated for different orders.
ii) Bill can be generated only for available items in the canteen.
Show solution
i) The same bill cannot be generated for different orders.
ii) Bill can be generated only for available items in the canteen.
The quantity should be kept in a new relation, not in the item relation, because quantity changes for each purchase/order.
A suitable design can be:
- ITEM(ItemName, Price, Calories) for item details
- BILL(BillNo, ItemName, Quantity) or PURCHASE(BillNo, ItemName, Quantity) for purchased items
To satisfy the conditions:
- The same bill cannot be generated for different orders → use BillNo as the primary key of the bill relation, or if multiple items are in one bill, use a composite key such as (BillNo, ItemName) with BillNo identifying the bill.
- Bill can be generated only for available items → keep ItemName in the bill relation as a foreign key referencing the item relation.
So, quantity belongs in the purchase/bill relation, along with a foreign key to item details.
Not sure why a step works? check your working in Super Tutor
8cThe school wants to find out how many calories students intake when they order an item. In which relation should the attribute 'calories' be stored?Show solution
The attribute calories should be stored in the ITEM relation, because calories are a property of the item itself, not of the purchase transaction.
Not sure why a step works? check your working in Super Tutor
9An organisation wants to create a database EMP-DEPENDENT to maintain following details about its employees and their dependent.EMPLOYEE(AadharNumber, Name, Address, Department, EmployeeID)
DEPENDENT(EmployeeID, DependentName, Relationship)
Show solution
EMPLOYEE(AadharNumber, Name, Address, Department, EmployeeID)
DEPENDENT(EmployeeID, DependentName, Relationship)
a) The candidate keys of EMPLOYEE can be AadharNumber and EmployeeID, because both can uniquely identify an employee.
b) To retrieve dependent details of a particular employee, we need the tables EMPLOYEE and DEPENDENT. The key required is the foreign key EmployeeID in the DEPENDENT table, which refers to the primary key of EMPLOYEE.
c) Degree is the number of attributes:
- EMPLOYEE(AadharNumber, Name, Address, Department, EmployeeID) has 5 attributes, so degree = 5.
- DEPENDENT(EmployeeID, DependentName, Relationship) has 3 attributes, so degree = 3.
Not sure why a step works? check your working in Super Tutor
9aName the attributes of EMPLOYEE, which can be used as candidate keys.Show solution
The attributes of EMPLOYEE that can be used as candidate keys are AadharNumber and EmployeeID, because both are unique identifiers.
Not sure why a step works? check your working in Super Tutor
9bThe company wants to retrieve details of dependent of a particular employee. Name the tables and the key which are required to retrieve this detail.Show solution
To retrieve dependent details of a particular employee, use the tables EMPLOYEE and DEPENDENT.
The required key is EmployeeID, which acts as a primary key in EMPLOYEE and a foreign key in DEPENDENT.
Not sure why a step works? check your working in Super Tutor
9cWhat is the degree of EMPLOYEE and DEPENDENT relation?Show solution
- EMPLOYEE(AadharNumber, Name, Address, Department, EmployeeID) has 5 attributes, so its degree = 5.
- DEPENDENT(EmployeeID, DependentName, Relationship) has 3 attributes, so its degree = 3.
Not sure why a step works? check your working in Super Tutor
School Uniform Database
Attributes and Constraints
Table: UNIFORM
| Attribute | UCode | UName | UColor |
|---|---|---|---|
| Constraints | Primary Key | Not Null | - |
Table: COST
| Attribute | UCode | Size | Price |
|---|---|---|---|
| Constraints | Composite Primary Key | >0 |
Table: UNIFORM
| UCode | UName | UColor |
|---|---|---|
| 1 | Shirt | White |
| 2 | Pant | Grey |
| 3 | Skirt | Grey |
| 4 | Tie | Blue |
| 5 | Socks | Blue |
| 6 | Belt | Blue |
Table:
| UCode | Size | COST Price |
|---|---|---|
| 1 | M | 500 |
| 1 | L | 580 |
| 1 | XL | 620 |
| 2 | M | 810 |
| 2 | L | 890 |
| 2 | XL | 940 |
| 3 | M | 770 |
| 3 | L | 830 |
| 3 | XL | 910 |
| 4 | S | 150 |
| 4 | L | 170 |
| 5 | S | 180 |
| 5 | L | 210 |
| 6 | M | 110 |
| 6 | L | 140 |
| 6 | XL | 160 |
Free with a Super Tutor account
i) 7, Handkerchief, NULL
ii) 4, Ribbon, Red
iii) 8, NULL, White
Free with a Super Tutor account
i) 7, S, 0
ii) 9, XL, 100
Free with a Super Tutor account
Movie(Movie_ID, MovieName, ReleaseDate)
Audi(AudiNo, Movie_ID, Seats, ScreenType, TicketPrice)
Free with a Super Tutor account
Free with a Super Tutor account
Free with a Super Tutor account
Free with a Super Tutor account
Free with a Super Tutor account
Free with a Super Tutor account
Free with a Super Tutor account
Free with a Super Tutor account
Free with a Super Tutor account
Free with a Super Tutor account
Free with a Super Tutor account
Free with a Super Tutor account
Free with a Super Tutor account
16 more solved questions in Database Concepts
They are free with a Super Tutor account, along with practice quizzes and flashcards for this chapter. Free to start, no card needed.
Frequently Asked Questions
What are the important topics in Database Concepts for CBSE Class 11 Informatics Practices?
Are these NCERT Solutions for Database Concepts free?
How should I revise Database Concepts for Class 11 exams?
Sources & Official References
- NCERT Official — ncert.nic.in
- CBSE Academic — cbseacademic.nic.in
- CBSE Official — cbse.gov.in
- National Education Policy 2020 — education.gov.in
Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.
More resources for Database Concepts
Practice Quiz
Test yourself with a quick quiz
Important Questions
Exam-style questions with answers
Revision Notes
Key points for last-minute revision
Chapter Summary
Understand the chapter at a glance
Concept Maps
See how topics connect
Study Plan
Step-by-step plan for this chapter
Flashcards
Quick-fire cards for active recall
Syllabus
What topics to cover
For serious students
Get the full Database Concepts chapter — start free.
Quizzes, flashcards, an AI doubt solver and a study plan for CBSE Class 11 Informatics Practices. Free to start, no card needed.