Curriculum
Grade XI Informatics Practices
Lessons
0/8
-
Ch1-Introduction-to-Computer-System
Preview -
Ch2-Python-Fundamentals
Preview
-
Ch3-Control-Flow-in-Python
Preview
-
Ch4-Lists-and-Dictionaries-in-Python
Preview
-
Ch5-Database-Concepts-and-RDBMS
Preview
-
Ch6-SQL-Creating-and-Managing-Tables
Preview
-
Ch7-SQL-Querying-Data
Preview
-
Ch8-Emerging-Trends-in-IT
Preview
Notes
0/8
Work sheets
0/8
All Notes and All Worksheets
0/2
Ch5-Database-Concepts-and-RDBMS
School Revise · Class 11 Informatics Practices · Chapter 5
Database Concepts and RDBMS
Code 065, Class 11. A database stores data in tables so it is easy to keep and find. Here we meet the relational model and its keys.
|
|
What this chapter is about
A database is an organised store of data, managed by a DBMS. In the relational model, data is kept in tables.
1. Tables, rows and columns
A relation is a table, a tuple is a row and an attribute is a column. Degree is the number of columns and cardinality the number of rows.
2. Keys
A primary key uniquely identifies each row. A candidate key can be a primary key, an alternate key is one not chosen, and a foreign key links to another table.
3. Why a database
A DBMS reduces repeated data and keeps data consistent, secure and shareable, which a simple file cannot do well.
Practise with the interactive
Explore the idea by tapping. The interactive opens right here in the lesson.
Practice set A, multiple choice
1. A row of a table is a …
tuple.
2. A column of a table is an …
attribute.
3. Which key identifies each row?
The primary key.
4. The number of rows is the …
cardinality.
Practice set B, short answer
1. What is a DBMS?
Software that stores and manages a database.
2. Define degree and cardinality.
Degree is the number of columns; cardinality is the number of rows.
3. What is a foreign key?
A column that links to the primary key of another table.
Quick summary
|
A database is an organised store of data, managed by a DBMS. In the relational model, a relation is a table, a tuple a row and an attribute a column; degree is columns and cardinality is rows. A primary key identifies each row and a foreign key links tables. A DBMS keeps data consistent, secure and shareable. |
| Open the Virtual Lab |
These free Class 11 Informatics Practices notes explain database concepts and RDBMS, the relational model, tuples and attributes, degree and cardinality, and keys with worked examples and practice, for CBSE students across India and the Gulf including the UAE, Saudi Arabia, Qatar, Oman, Kuwait and Bahrain.
© 2026 School Revise. All rights reserved. Original content aligned to the CBSE and NCERT Class 11 Informatics Practices syllabus. Unauthorised copying is not permitted.
Google