Syllabus (ITCA 2nd year)
❖ Python -:
1. basic intro ( developed by , pros , cons etc )
2. Conditional statements and loops
3. Functions with single and multiple return
4. Strings ( reversing and substring )
5. File Handling
❖ CN -:
1. Basic intro about computer network and distributed system
2. Difference between hubs,routers,switch and bridge
3. Switching method and connection devices(layering)
4. Differents types of topology
5.
❖ DBMS -:
1. Overview of DBMS,characteristics and advantages of DBMS approach,
Database types
2. Database System vs File System
3. Architecture of DBMS, Data Model and its types, Schema
4. SQL-DDL,DML
5. Structure of Database
6. E-R Model , Generalisation, Specialisation, ER diagram to tables
❖ Optimization Techniques -:
1. Single Variable Optimization
2. Multi Variables with and without constraints
3. Graphical Methods
4. Simplex Method
5. Two Phase Method
❖ COA -:
1. Register Transfer language
2. Bus and Memory Transfers
3. Arithmetic Microoperations
4. Shift Microoperations
5. Arithmetic Logic Shift Unit