Semester Overview

---

Database Management Systems

Definition: Database Management Systems covers the design, modeling, querying, normalization, transaction management, and security aspects of relational databases.

Module 1: Database Architecture

• Data abstraction, independence.
• DDL, DML.
• Data models: ER, relational, object-oriented.

Module 2: Relational Model & Query Languages

• Relational algebra, tuple/domain calculus.
• SQL: DDL, DML.
• Normal forms, dependency preservation.

Module 3: Query Processing

• Query optimization.
• Join strategies.

Module 4: Storage & Indexing

• Indices, B-trees.
• Hashing.

Module 5: Transaction Management

• ACID properties.
• Concurrency control, recovery.

Module 6: Advanced Topics

• Database security.
• Distributed databases basics.

---

Theory of Computation

Definition: Theory of Computation explores abstract models of computation, languages, automata, and decidability issues.

Module 1: Finite Automata

• DFA, NFA.
• Regular expressions, languages.

Module 2: Context-Free Languages

• Context-free grammars.
• Pushdown automata.

Module 3: Turing Machines

• TM design, variants.
• Church-Turing thesis.

Module 4: Decidability

• Decidable/undecidable problems.
• Halting problem.

Module 5: Complexity

• Time/space complexity.
• P, NP, NP-complete.

Module 6: Advanced Models

• Recursive languages.
• Post correspondence problem.

---

Signals and Systems

Definition: Signals and Systems analyzes continuous/discrete signals, LTI systems, and transform techniques for system representation.

Module 1: Signals & Systems Basics

• Signal classification, properties.
• System properties: linearity, causality.

Module 2: LTI Systems

• Convolution, impulse response.
• Differential/difference equations.

Module 3: Fourier Analysis

• Fourier series, transform.
• DTFT, DFT.

Module 4: Laplace & Z-Transforms

• Poles/zeros, stability.
• System analysis.

Module 5: Sampling

• Sampling theorem.
• Aliasing, reconstruction.

Module 6: Applications

• Modulation, filtering basics.

---

Object Oriented Programming

Definition: Object Oriented Programming emphasizes classes, objects, inheritance, polymorphism using languages like Java/C++.

Module 1: OOP Fundamentals

• Classes, objects.
• Encapsulation, abstraction.

Module 2: Inheritance & Polymorphism

• Types of inheritance.
• Method overloading/overriding.

Module 3: Interfaces & Packages

• Abstract classes, interfaces.
• Packages.

Module 4: Exception Handling

• Try-catch, custom exceptions.

Module 5: Multithreading

• Thread creation, synchronization.

Module 6: Advanced Features

• Collections, generics.
• GUI basics.

---

Computer Networks

Definition: Computer Networks studies layered architecture, protocols, and technologies for data communication.

Module 1: Introduction

• Network types, topologies.
• OSI and TCP/IP models.

Module 2: Physical Layer

• Transmission media.
• Multiplexing.

Module 3: Data Link Layer

• Error detection/correction.
• MAC protocols.

Module 4: Network Layer

• IP addressing, routing.
• ICMP, ARP.

Module 5: Transport Layer

• TCP, UDP.
• Congestion control.

Module 6: Application Layer

• DNS, HTTP.
• Email, FTP.

---

Constitution

Definition: Constitution introduces the Indian Constitution, rights, duties, and governance framework.

Module 1: Historical Overview

• Making of Constitution.
• Preamble.

Module 2: Fundamental Rights

• Equality, freedom.
• Religion, education.

Module 3: Directive Principles & Duties

• State policy.
• Fundamental duties.

Module 4: Government Structure

• Executive, legislature.
• Federalism.

Module 5: Judiciary

• Supreme Court.
• Judicial review.

Module 6: Amendments & Emergency

• Amendment process.
• Emergency provisions.

---

Universal Human Values

Definition: Universal Human Values promotes ethical living, harmony in self, family, society, and nature.

Module 1: Need for Values

• Self-exploration.
• Natural acceptance.

Module 2: Harmony in Self

• Understanding human being.
• Feelings, desires.

Module 3: Family & Society

• Relationships, justice.
• Trust, respect.

Module 4: Harmony with Nature

• Co-existence.
• Ecological balance.

Module 5: Professional Ethics

• Competence, commitment.
• Role of engineer.

Module 6: Holistic Vision

• Humane society.
• Universal order.

---

Effective Technical Communication

Definition: Effective Technical Communication develops skills in technical writing, presentation, and professional communication.

Module 1: Information Design and Development

• Types of technical documents.
• Information development life cycle.
• Organization structures, strategies for print and online media.

Module 2: Technical Writing, Grammar and Editing

• Technical writing process, revising.
• Collaborative writing, indexes.
• Advanced grammar, editing for technical style.
• Usability, human factors, project management.

Module 3: Self Development and Assessment

• Self-assessment, awareness, perception.
• Goal setting, career planning, self-esteem.
• Time management, rapid reading, note-taking, problem-solving, creativity.

Module 4: Communication and Technical Writing

• Public speaking, group discussion.
• Oral presentations, interviews.
• Writing reports, proposals, brochures, manuals, letters, memos.

Module 5: Ethics

• Business ethics, social/office etiquettes.
• Email and telephone etiquettes.
• Engineering ethics, work culture.
• Role and responsibility of engineer.

---