September 23 32 UNIT 3: DATABASES AND SQL 20+12 Data base Concepts: Introduction to data base concepts and its need. Relational data model: Concept of domain, tuple, relation, key, primary key, alternate key, candidate key; Relational algebra: Selection, Projection, Union and Cartesian product; Structured Query Language: General Concepts: Advantages of using SQL, Data Definition Language and Data Manipulation Language; Data Types: NUMBER/DECIMAL, CHARACTER/VARCHAR/VARCHAR2, DATE; SQL COMMANDS:CREATE TABLE, DROP TABLE, ALTER TABLE, UPDATE INSERT, ….SET…., DELETE; SELECT, DISTINCT, FROM, WHERE, IN, BETWEEN, GROUPBY, HAVING, ORDERBY; SQL functions: SUM, AVG, COUNT, MAX AND MIN; Obtaining results (SELECT query) from 2 tables using equi-join and Union Note: Implementation of the above mentioned commands could be done on any SQL supported software onone or two tables. UNIT 4: BOOLEAN ALGEBRA Role of Logical Operations in Computing. Binary-valued Quantities, Boolean Variable, Boolean Constant and Boolean Operators: AND, OR, NOT; Truth Tables; Closure Property, Commutative Law, Associative Law, Identity law, Inverse Law, Principle of Duality, Idem potent Law, Distributive Law, Absorption Law, Involution Law, DeMorgan's Law and their applications; Obtaining Sum of Product (SOP) and Product of Sum (POS) form from the Truth Table, Reducing Boolean Expression (SOP and POS) to its minimal form, Use of Karnaugh Map for minimization of Boolean expressions (up to 4 variables); Application of Boolean Logic: Digital electronic circuit design using basic Logic Gates (NOT, AND, OR, NAND, NOR) Use of Boolean operators (AND, OR) in search engine queries. October 15 18 UNIT 5: COMMUNICATION TECHNOLOGIES 18+0 ARPANET, Internet, Interspace Evolution of Networking: Different ways of sending data across the network with reference to switching techniques (Circuit and Packet switching);
September 23 32 UNIT 3: DATABASES AND SQL Data base Concepts: Introduction to data base concepts and its need. Relational data model: Concept of domain, tuple, relation, key, primary key, alternate key, candidate key; Relational algebra: Selection, Projection, Union and Cartesian product; Structured Query Language: General Concepts: Advantages of using SQL, Data Definition Language and Data Manipulation Language; Data Types: NUMBER/DECIMAL, CHARACTER/VARCHAR/VARCHAR2, DATE; SQL COMMANDS:CREATE TABLE, DROP TABLE, ALTER TABLE, UPDATE ….SET…., INSERT, DELETE; SELECT, DISTINCT, FROM, WHERE, IN, BETWEEN, GROUPBY, HAVING, ORDERBY; SQL functions: SUM, AVG, COUNT, MAX AND MIN; Obtaining results (SELECT query) from 2 tables using equi-join and Union Note: Implementation of the above mentioned commands could be done on any SQL supported software onone or two tables. UNIT 4: BOOLEAN ALGEBRA Role of Logical Operations in Computing. Binary-valued Quantities, Boolean Variable, Boolean Constant and Boolean Operators: AND, OR, NOT; Truth Tables; Closure Property, Commutative Law, Associative Law, Identity law, Inverse Law, Principle of Duality, Idem potent Law, Distributive Law, Absorption Law, Involution Law, DeMorgan's Law and their applications; Obtaining Sum of Product (SOP) and Product of Sum (POS) form from the Truth Table, Reducing Boolean Expression (SOP and POS) to its minimal form, Use of Karnaugh Map for minimization of Boolean expressions (up to 4 variables); Application of Boolean Logic: Digital electronic circuit design using basic Logic Gates (NOT, AND, OR, NAND, NOR) Use of Boolean operators (AND, OR) in search engine queries. 20+12 October 15 18 UNIT 5: COMMUNICATION TECHNOLOGIES Evolution of Networking: ARPANET, Internet, Interspace Different ways of sending data across the network with reference to switching techniques (Circuit and Packet switching); 18+0
1870025640split_up_syllabus_-computer_science.docx