Page 56 - IPP-11

Increase of 5 Marks No change No change Order by, between, IN, LIKE clauses have been removed. The entire topic has been removed. 5 Marks reduced The entire unit has been replaced.

20 Marks (As per 2020–21 Syllabus) Database Concepts: Introduction to database concepts and its need, Database Management Relational data model: Concept of domain, tuple, relation, candidate key, primary key, Advantages of using Structured Query Language, Data Definition Language, Data Query Language and Data Manipulation Language, Introduction to MySQL, Creating a database using MySQL, Data Definition: CREATE TABLE, DROP TABLE, Data Query: SELECT, FR

System. alternate key, foreign key. Data Types ALTER TABLE. No aggregate functions GREEN – No change/Few changes BLUE – Newly-added Topics RED – Removed Topics

15 Marks (As per 2019–20 Syllabus) Relational databases: Concept of a database, relations, attributes and tuples, keys – candidate key, primary key, alternate key, foreign key; Degree and cardinality of a table. • Use SQL – DDL/DML commands to CREATE TABLE, INSERT INTO, UPDATE TABLE , DELETE FROM, ALTER TABLE, MODIFY TABLE, DROP TABLE, keys and foreign To view content of a table: SELECT-FROM WHERE-ORDER BY along with BETWEEN, IN, LIKE, (Queries o

• keys;

Database Concepts and Structured Query Language Introduction to Emerging

IV: V: Trends