0% found this document useful (0 votes)
6 views1 page

ITCA 2nd Year Syllabus Overview

The syllabus for the 2nd year ITCA includes topics in Python programming, computer networks, database management systems (DBMS), optimization techniques, and computer organization and architecture (COA). Key areas covered in Python are conditional statements, functions, and file handling, while CN focuses on network devices and topologies. DBMS includes database architecture and SQL, optimization techniques cover single and multi-variable methods, and COA addresses register transfer language and microoperations.

Uploaded by

fifan91796
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
6 views1 page

ITCA 2nd Year Syllabus Overview

The syllabus for the 2nd year ITCA includes topics in Python programming, computer networks, database management systems (DBMS), optimization techniques, and computer organization and architecture (COA). Key areas covered in Python are conditional statements, functions, and file handling, while CN focuses on network devices and topologies. DBMS includes database architecture and SQL, optimization techniques cover single and multi-variable methods, and COA addresses register transfer language and microoperations.

Uploaded by

fifan91796
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

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

You might also like