Skip to main content
Chapter 7 of 8
NCERT Solutions

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.

67 questions72 flashcards5 concepts

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.

33 Questions Solved · 1 Section

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) 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

  • 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:

  1. Difficulty in access
  2. Data redundancy
  3. Data inconsistency
  4. Data isolation
  5. Data dependence
  6. 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_noPreference
9Cricket
13Football
17Badminton
17Football
21Hockey
24NULL
NULLKabaddi
Show solution

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_noSports
9Cricket
13Football
17Badminton
21Hockey
24Cricket

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

SportsRoll_no
Badminton17
Cricket9
Cricket24
Football13
Hockey21
Show solution

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

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:

  1. 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.
  2. 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

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

10School uniform is available at M/s Sheetal Private Limited. They have maintained SCHOOL_UNIFORM Database with two relations viz. UNIFORM and COST. The following figure shows database schema and its state.

School Uniform Database

Attributes and Constraints

Table: UNIFORM

AttributeUCodeUNameUColor
ConstraintsPrimary KeyNot Null-

Table: COST

AttributeUCodeSizePrice
ConstraintsComposite Primary Key>0

Table: UNIFORM

UCodeUNameUColor
1ShirtWhite
2PantGrey
3SkirtGrey
4TieBlue
5SocksBlue
6BeltBlue

Table:

UCodeSizeCOST Price
1M500
1L580
1XL620
2M810
2L890
2XL940
3M770
3L830
3XL910
4S150
4L170
5S180
5L210
6M110
6L140
6XL160

Free with a Super Tutor account

10aCan they insert the following tuples to the UNIFORM Relation? Give reasons in support of your answer.

i) 7, Handkerchief, NULL
ii) 4, Ribbon, Red
iii) 8, NULL, White

Free with a Super Tutor account

10bCan they insert the following tuples to the COST Relation? Give reasons in support of your answer.

i) 7, S, 0
ii) 9, XL, 100

Free with a Super Tutor account

11In a multiplex, movies are screened in different auditoriums. One movie can be shown in more than one auditorium. In order to maintain the record of movies, the multiplex maintains a relational database consisting of two relations viz. MOVIE and AUDI respectively as shown below:

Movie(Movie_ID, MovieName, ReleaseDate)

Audi(AudiNo, Movie_ID, Seats, ScreenType, TicketPrice)

Free with a Super Tutor account

11aIs it correct to assign Movie_ID as the primary key in the MOVIE relation? If no, then suggest an appropriate primary key.

Free with a Super Tutor account

11bIs it correct to assign AudiNo as the primary key in the AUDI relation? If no, then suggest appropriate primary key.

Free with a Super Tutor account

11cIs there any foreign key in any of these relations?

Free with a Super Tutor account

12aName primary key of each table.

Free with a Super Tutor account

12bFind foreign key(s) in table PROJECT-ASSIGNED.

Free with a Super Tutor account

12cIs there any alternate key in table STUDENT? Give justification for your answer.

Free with a Super Tutor account

12dCan a user assign duplicate value to the field RollNo of STUDENT table? Jusify.

Free with a Super Tutor account

13For the above given database STUDENT-PROJECT, can we perform the following operations?

Free with a Super Tutor account

13aInsert a student record with missing roll number value.

Free with a Super Tutor account

13bInsert a student record with missing registration number value.

Free with a Super Tutor account

13cInsert a project detail without submission-date.

Free with a Super Tutor account

13dInsert a record with registration ID IP-101-19 and ProjectNo 206 in table PROJECT-ASSIGNED.

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?
Key topics in Database Concepts include From File System to Database, DBMS, Database Schema, Instance, and Meta-data, Relational Data Model and Relation Properties, Keys in a Relational Database. Study these first, then practise questions on each for Class 11 exams.
Are these NCERT Solutions for Database Concepts free?
The first 17 of the 33 solutions on this page are open to read. The other 16 are free with a Super Tutor account — signing up is free and needs no card.
How should I revise Database Concepts for Class 11 exams?
Learn the core ideas first, then work through the 67 practice questions on Database Concepts. Revise definitions regularly and use flashcards for quick recall before the exam.

Sources & Official References

Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.

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.