CBSE Class XI Informatics Practices Syllabus

Informatics Practices

CLASS XI

TERM- 2

Unit 3:

Database concepts and the Structured Query Language

Database Concepts: Introduction to database concepts and its need, Database Management System.

Relational data model: concept of attribute, domain, tuple, relation, candidate key, primary key, alternate key, foreign key.

Structured Query Language: Data Definition Language, Data Query Language and Data Manipulation Language, Introduction to MySQL: Creating a database, using database, showing tables using MySQL,

Data Types : char, varchar, int, float, date.

Data Definition Commands: CREATE, DROP, ALTER (Add and Remove primary key, attribute).

Data Query Commands: SELECT-FROM- WHERE, LIKE, BETWEEN, IN, ORDER BY, using arithmetic, logical, relational operators and NULL values in queries, Distinct clause

Data Manipulation Commands: INSERT, UPDATE, DELETE.

Unit 4:

Introduction to the Emerging Trends

● Artificial Intelligence, Machine Learning, Natural Language Processing,

● Immersive experience (AR, VR), Robotics

● Big data and its characteristics, Internet of Things (IoT), Sensors, Smart cities,

● Cloud Computing and Cloud Services (SaaS, IaaS, PaaS);

● Grid Computing, Block chain technology.

<