MCA Syllabus - 1st Sem PDF
MCA Syllabus - 1st Sem PDF
MCA Syllabus - 1st Sem PDF
Program Core
Semester I
Course Objectives
This course enables the students to:
1. To provide knowledge of Computer Architecture
2. Employ knowledge of various Digital Logic Circuits, Data Representation,
Register and Processor level Design and Instruction Set architecture
3. To develop the logical ability to Determine which hardware blocks and control
lines are used for specific instructions
4. Understand memory organization, I/O organization and its impact on computer
cost/performance.
5. Know merits and pitfalls in computer performance measurements.
Course Outcomes
After the completion of this course, students will be able to:
CO1 Describe the merits and pitfalls in computer performance measurements and
analyze the impact of instruction set architecture on cost-performance of
computer design
CO2 Explain Digital Logic Circuits, Data Representation, Register and Processor
level Design and Instruction Set architecture
CO3 Solve problems related to computer arithmetic and Determine which hardware
blocks and control lines are used for specific instructions
CO4 Design a pipeline for consistent execution of instructions with minimum
hazards
CO5 Explain memory organization, I/O organization and its impact on computer
cost/performance.
SYLLABUS
Module I:
INTRODUCTION
Digital Logic Design: Axioms and laws of Boolean algebra, Reduction of Boolean expressions,
conversion between canonical forms, Karnaugh map (4 variable), Half Adder, full adder, 4-bit
parallel parity bit generator, checker circuit, Decoder, Encoder, Multiplexer, IC RAM, ROM,
Memory Organization, Sequential Circuits, State transistors, Flip-flop, RS, JK, D-Latch,
Master-slave.
(8L)
Module II:
INSTRUCTION SET ARCHITECTURE
Memory Locations and Addresses: Byte Addressability, Big-Endian and Little-Endian
Assignments, Word Alignment, Instructions and Instruction Sequencing, Addressing Modes,
Assembly Language, Subroutines, Additional Instructions, dealing with 32-Bit Immediate
Values.
(8L)
Module III:
BASIC PROCESSING UNIT & PIPELINING
Basic Processing Unit: Some Fundamental Concepts, Instruction Execution, Hardware
Components, Instruction Fetch and Execution Steps, Control Signals, Hardwired Control,
CISC-Style Processors.
Pipelining: Basic Concept, Pipeline Organization, Pipelining Issues, Data Dependencies,
Memory Delays, Branch Delays, Pipeline Performance Evaluation.
(8L)
Module IV:
MEMORY ORGANIZATION
Basic Concepts, Semiconductor RAM Memories, Read-only Memories, Direct Memory Access,
Memory Hierarchy, Cache Memories, Performance Considerations, Virtual Memory, Memory
Management Requirements, Secondary Storage
(8L)
Module V:
INPUT OUTPUT & PARALLEL PROCESSING
Basic Input Output: Accessing I/O Devices, Interrupts, Input Output Organization: Bus
Structure, Bus Operation, Arbitration, Interface, Interconnection Standards.
Parallel Processing: Hardware Multithreading, Vector (SIMD) Processing, Shared-Memory
Multiprocessors, Cache Coherence, Message-Passing Multicomputers, Parallel Programming
for Multiprocessors, Performance Modeling.
(8L)
Books recommended:
TEXT BOOK
1. Hamacher Carl, et. al, “Computer Organization and Embedded Systems”, 6th Edition,
Tata McGraw Hill,New Delhi, 2011.(T1)
2. Patterson David A., “Computer Organization and Design: The Hardware Software /
Interface”, 5thEdition, 1994.(T2)
3. Mano M. Morris, “Computer System Architecture”, Revised 3rdEdition, Pearson
Education.(T3)
COURSE OUTCOME (CO) ATTAINMENT ASSESSMENT TOOLS & EVALUATION
PROCEDURE
Direct Assessment
Indirect Assessment –
1. Student Feedback on Faculty
2. Student Feedback on Course Outcome
Course Objectives
This course enables the students:
1. To provide knowledge of practical implementations and usage of Data
Structures and Algorithms.
Course Outcomes
After the completion of this course, students are expected to
CO1 Identify various data structures and their usages.
CO2 Apply data structures in the modeling of computer-based systems in a way that
demonstrates comprehension of the trade-offs involved in design.
CO3 Demonstrate the usage of optimal trees, heaps and priority queues.
CO4 Implement sorting algorithms.
SYLLABUS
Module I:
Fundamental Data Structures: Using Arrays, Singly Linked Lists, Circularly Linked Lists,
Doubly Linked Lists, Asymptotic Analysis.
(8L)
Module II:
Stacks, Queues, Dequeues: The Stack, Queue, Dequeue ADTs, Simple Array Based Stack,
Queue, Dequeue Implementation, Implementing Stack, Queue with Singly Linked List,
Reversing an Array using Stack, Matching Parenthesis and HTML tags, A Circular Queue.
(8L)
Module III:
Trees: General Trees, Binary Trees, Implementing Trees, Tree Traversal Algorithms,
BinarySearch Trees, AVL Trees, B Trees.
(8L)
Module IV:
Sorting: Merge sort, Quick sort, Studying sorting through algorithmic lens, Comparing
SortingAlgorithms.
Heap: Priority Queues, Array Implementation of Heaps, Construction of Heaps, Heap Sort.
(8L)
Module V:
Graphs: Data Structures for graphs, Graph Traversals, Transitive Closure, Directed Acyclic
Graphs, Shortest Paths, Minimum Spanning Trees. (8L)
Text book:
1. Goodrich Michael T., Tamassia Roberto, Goldwasser Michael H. “Data Structures and
Algorithms in Java”, Wiley, 6th Edition, 2014.
2. Klein Shmuel Tomi, Basic Concepts in Data Structures, Cambridge University Press, 1st
Edition, 2016.
Reference books:
1. YedidyahLangsam, Moshe Augenstein J., Tenenbaum Aaron M. “Data Structures using
JAVA”, Pearson Education, 2009.
2. Brass Peter “Advanced Data Structures”, Cambridge University Press, 1st Edition.
COURSE OUTCOME (CO) ATTAINMENT ASSESSMENT TOOLS & EVALUATION
PROCEDURE
Direct Assessment
3 Quizzes 30 % (3 × 10%)
Assignment (s) 10
Indirect Assessment –
1. Student Feedback on Faculty
2. Student Feedback on Course Outcome
Course Objectives
This course enables the students:
1. To observe that how the real world data is stored, retrieved, and communicate under
the DBMS environment
2. To design a logical model which having the unique relation between the Data.
3. To apply the query for the modification of the system.
4. To develop a conceptual design which allows as to avoid anomalies in superior’s
data.
5. To discuss a system which allows to restrict the uncontrolled exaction and provide
rigorous variation of the task.
Course Outcomes
After the completion of this course, students will be able to:
CO1 Describe various data models and schemas used in database management systems.
CO2 Explain the fundamental concepts, data definitions and query processing tasks in
relational query languages.
CO3 Recognize database design theory, and evaluate functional dependencies and normal
forms in databases.
CO4 Formulate the operations of transaction and concurrent query processing tasks to
obtain the correct results even under strict time constraints.
CO5 Interpret the foundational concepts of distributed databases. Illustrate several
techniques related to transaction management and query processing in distributed
database management systems.
SYLLABUS
MODULE I:
Introduction and Conceptual Modelling: Purpose of Database Systems, Data Models,
Schemas and Instances, Three-Schema Architecture and Data Independence, Database
languages, Database Architecture, Classification of DBMS, relational database, Database users
and Administrators, Advantages of DBMS. Entities and Entity Sets, Relationships and
Relationship Sets, Keys, Mapping, Constraints, ER Diagram, Reducing ER Diagram to tables,
Generalization and Specialization, Aggregation.
(8L)
MODULE II:
Relational Model: Concepts, Constraints, Languages, Design and Programming:
Relational database Schemas, Relational Algebra, Relational Calculus (Tuple Relational
calculus and Domain Relational calculus), Update operations, Transactions, Dealing with
constraint violations. Binary Relational operation: JOIN and DIVISION, SQL, More complex
SQL Queries, Security & Integrity violations, authorization and views, integrity constants,
encryption, Statistical databases
(8L)
MODULE III:
Database Design Theory and Methodology: Pitfalls in relational database design, Functional
Dependencies, Decomposition Using Functional Dependencies. Normalization using functional
Dependencies, General Definition of First, Second, Third and Forth Normal Form. Boyce-Codd
Normal Form(BCNF), Multivalued and join dependencies, DKNF.
(8L)
MODULE IV:
Transaction Processing Concepts and Concurrency Control Techniques: Transaction
Processing, Desirable Properties of Transactions, Transaction State, Characterizing Schedules
based on Recoverability and Serializability. Lock-Based Protocols, Timestamp-Based
Protocols, Validation-Based Protocols, Multiple Granularity, Deadlock Handling, Recovery and
Atomicity, Log-Based Recovery.
(8L)
MODULE V:
Distributed Databases and Client-Server Architectures: Concepts and Types of Distributed
databases, data fragmentation, Replication and Allocation Techniques for Distributed Database
Design, Query Processing in Distributed Databases, Overview of Concurrency Control and
Recovery in Distributed Databases, An Overview of 3-Tier Client-Server Architecture.
(8L)
Text Book:
1. Elmasri Ramez, & Navathe S.B., “Fundamentals of Database Systems”, 5th Edition, Pearson
Education, 2006.
Reference Book:
1. Silberschatz A., &Korth H., “Database Systems Concepts”, 5th Edition, McGraw Hill Higher
Education, 2005.
Direct Assessment
Indirect Assessment –
1. Student Feedback on Faculty
2. Student Feedback on Course Outcome
Course Objectives
This course enables the students:
1. The course shall allow students to understand the basic tenets of OOP.
2. The course will exemplify the basic syntax and constructs of JAVA
3. The course will help students understand the application OOP principles and Improve
their programming skills in core Java
4. The course will explain basic JAVA characteristics and their working.
5. The course aims to expose students to Use the Java packages, applets for software
development
Course Outcomes
After the completion of this course, students will be:
CO1 Identify the difference between procedural and OO programming.
CO2 Construct programs using various OOP principles.
CO3 Apply the knowledge gained for their project work as well as to develop some GUI
applications using JAVA
CO4 Operate on files and strings in real life scenarios.
CO5 Analyze thread performance and inter thread communication issues
SYLLABUS
MODULE I:
Procedure-Oriented Programming, Object-Oriented programming, Benefits of OOP,
Applications of OOP, Basics, Evolution of Java, Structure of JAVA Program, Simple Java
Program, Tokens, Comments, Identifiers, Operators, Literals, Control Structures. Java
Environment Setup, Compiling a Java Program, Java Virtual Machine, Philosophy of Java and
Benefits.
(8L)
MODULE II:
Data types and program statements: Primitive and reference data types, variables and
constants, enumerated constants, labelled statement, expression and null statements, compound
statement, control statement – decision and loops, jump statement, declaration statement, try-
throw-catch-finally statement, declaring and creating arrays, accessing array elements, assigning
values to array elements, multidimensional arrays.
(8L)
MODULE III:
Functions, Data Abstraction and classes: Declaration, definition and call, main method
arguments, reference variables, method overloading, parameter passing by value for primitive
types, object references and arrays, scope of variables, return from methods.
Class and object, class members and initialization, access rights of members – public, private and
protected access modifiers, constructor and copy constructor, mutability, finalization, dynamic
memory management, garbage collection, this keyword, static members, scope of variables,
interface – declaration, implementation and extending, package and package visibility.
(8L)
MODULE IV:
Inheritance and Collection classes: multi level and single inheritance, multiple inheritance of
interfaces, Object class, access rights in subclasses and packages, constructor calling sequence,
super keyword, dynamic binding of methods, abstract class, overriding, shadowing and hiding,
finalize, association, aggregation and composition.
String, StringBuffer, Date, Calendar, Math, Object, Class, Exception class.
(8L)
MODULE V:
Input/Output and JAVA Applets: Stream clases – InputStream, OutputStream, Buffered
Stream, file classes and handling, pushback streams, reader and writer classes, file reader and
writer, serialization.
Applet code example, HTML tags for applet, applet lifecycle, color, font and
basic GUI handling, basic graphics, animation.
(8L)
Text books:
E. Balagurusamy - Programming in Java, 2nd Edition; Tata McGraw Hill Publication; New
Delhi.
Reference books:
Patrick Naghton & H. Schildt – The Complete Reference Java 2, Tata McGraw Hill Publication,
New Delhi.
Dietel,Dietel - Java How to program , 7th edition; Pearson Education , New Delhi.
Direct Assessment
Indirect Assessment –
1. Student Feedback on Faculty
2. Student Feedback on Course Outcome
Course Delivery Methods
CD1 Lecture by use of boards/LCD projectors/OHP projectors
CD2 Assignments/Seminars
CD3 Laboratory experiments/teaching aids
CD4 Industrial/guest lectures
CD5 Industrial visits/in-plant training
CD6 Self- learning such as use of NPTEL materials and internets
CD7 Simulation
Course Objectives
This course enables the students to:
1. Present the main components of OS and their working
2. Introduce the concepts of process and thread and their scheduling policies
4. Analyze the different techniques for managing memory, I/O, disk and files.
Course Outcomes
After the completion of the course student will be able to:
CO1 Describe the main components of OS and their working
CO2 Explain the concepts of process and thread and their scheduling policies
CO3 Explain the various memory management techniques.
CO4 Compare the different techniques for managing memory, I/O, disk and files.
CO5 Explains the security and protection features of an Operating System.
SYLLABUS
MODULE I:
Overview of Operating Systems: OS and the Computer System, Efficiency, System
Performance and User Convenience, Classes of Operating Systems, Batch Processing Systems,
Multiprogramming Systems, Time Sharing Systems, Real Time Operating Systems, Distributed
Operating Systems, Modern Operating Systems.
(8L)
MODULE II:
Processes and Threads: Processes and Programs, Programmer view of Processes, OS view of
Processes, Threads, Case studies of Processes and Threads.
MODULE III:
Memory Management: Managing the Memory Hierarchy, Static and Dynamic Memory
Allocation, Memory Allocation to a Process, Reuse of Memory, Contiguous Memory
Allocation, Noncontiguous Memory Allocation, Paging, Segmentation, Segmentation with
Paging, Kernel Memory Allocation, A Review of Relocation, Linking and Program Forms.
Virtual Memory: Virtual Memory Basics, Demand Paging, Page Replacement Policies,
Memory Allocation to a Process, Shared Pages, Memory Mapped Files, Unix Virtual Memory,
Linux Virtual Memory, Virtual Memory using Segmentation.
(8L)
MODULE IV:
File Systems: File System and IOCS, Files and File Operations, Fundamental File
Organizations, Directory Structures, File Protection, Interface between File System and IOCS,
Allocation of Disk Space, Implementing File Access, File Sharing Semantics, File System
Reliability, Virtual File System, Unix File System, Linux File System, Windows File System,
Performance of File Systems.
(8L)
MODULE V:
Security and Protection: Overview of Security and Protection, Goals of Security and
Protection, Security Attacks, Formal and Practical aspects of Security, Encryption,
Authentication and Password Security, Access Descriptors and the Access Control Matrix,
Protection Structures, Capabilities, Unix Security, Linux Security, Windows Security.
(8L)
Text Book:
Reference Books:
1. SilberschatzA.,Galvin Peter B.,Greg Gagne, “Operating System Concepts”, 6th Edition, John
Wiley, Indian Reprint, 2003.
2. Crowley C., “Operating Systems: A Design-Oriented Approach”, TMH, New Delhi, 2002.
3. Deitel H.M., “Operating Systems”, 2nd Edition, Pearson Education, 2003.
4. Tanenbaum A.S., “Operating System: Design and Implementation”, PHI, New Delhi,
2002.
Direct Assessment
Indirect Assessment –
1. Student Feedback on Faculty
2. Student Feedback on Course Outcome
Course Objectives
This course enables the students to:
1. Analyze and demonstrate writing and speaking processes through invention,
organization, drafting, revision, editing, and presentation.
2. Understand the importance of specifying audience and purpose and to select
appropriate communication choices.
3. Interpret and appropriately apply modes of expression, i.e., descriptive,
expositive, Narrative, scientific, and self-expressive, in written, visual, and
oral communication
4. Participate effectively in groups with emphasis on listening, critical and
reflective thinking, and responding.
5. Develop the ability to research and write a documented paper and/or to give
an oral presentation.
Course Outcomes
After the completion of this course, students will be able to:
CO1 Apply business communication strategies and principles to prepare effective
communication for domestic and international business situations.
CO2 Utilize analytical and problem-solving skills appropriate to business
communication.
CO3 Participate in team activities that lead to the development of collaborative
work skills.
CO4 Select appropriate organizational formats and channels used in developing
and presenting business messages
CO5 Communicate via electronic mail, Internet, and other technologies and
deliver an effective oral business presentation.
SYLLABUS
Module I:
Introduction to Business Communication:
Importance and Objectives of Business communication, Process of communication, Barriers to
effective communication, Techniques of effective communication. Forms of communication
(Written, Oral, audio-visual communication).
(8L)
Module II:
Managing Business Communication:
Formal and Informal communication, Non- verbal communication (Body language, Gestures,
Postures, Facial expressions). The cross-cultural dimensions of business communication.
Techniques to effective listening, methods and styles of reading.
(8L)
Module III:
Other aspects of communication:
Vocabulary:
Single word substitution, Idioms and phrases, Precis writing, Comprehension.
Group Discussions, Extempore, Principles of effective speech and presentations, Role-playing.
(8L)
Module IV:
Introduction to managerial writing:
Business letters: Inquiries, Circulars, Quotations, Orders, Acknowledgement, Claims &
adjustments, Collection letters, Sales letters, Drafting of different resumes, Covering letters
Applying for a job, Social correspondence, Invitation to speak.
Official Correspondence: Memorandum, Notice, Agenda, Minutes, Circular letters.
(8L)
Module V:
Report writing and Technical Proposals:
Business reports, Types, Characteristics, Importance, Elements of structure, Process of writing,
Order of writing, the final draft, checklists for reports.
Technical proposals, Definitions, types and format.
(8L)
Books recommended:
TEXT BOOK
1. “Communication Skills”, Sanjay Kumar &PushpLata, Oxford University Press. (T1)
2. “Business Correspondence and Report Writing”, R.C.Sharma, Krishna Mohan, McGraw
Hill. (T2)
3. “Communication for Business”, Shirley Taylor, V. Chandra, Pearson. (T3)
REFERENCE BOOK
1. “Business Communication”, HorySankar Mukherjee, Oxford University Press. (R1)
2. “Basic Business Communication”, Lesikar I Flatley, McGraw Hill. (R2)
3. “Business Communication Today”, Bovee, Thill and Chaterjee, Pearson. (R3)
Direct Assessment
Assessment Tool % Contribution during CO Assessment
Continuous Internal Assessment 50
Semester End Examination 50
3 Quizzes 30 % (3 × 10%)
Assignment (s) 10
Indirect Assessment –
1. Student Feedback on Faculty
2. Student Feedback on Course Outcome
Course
CD Course Delivery methods Outcome Course Delivery Method
Lecture by use of boards/LCD
CD1 projectors/OHP projectors CO1 CD1,CD2,CD3
CD2 Tutorials/Assignments CO2 CD1,CD2,CD3
CD3 Seminars CO3 CD1,CD2,CD3
CD4 Mini projects/Projects CO4 CD1,CD2,CD3,CO4 CD5
CD5 Laboratory experiments/teaching aids
CD6 Industrial/guest lectures
CD7 Industrial visits/in-plant training
Self- learning such as use of NPTEL
CD8 materials and internets
CD9 Simulation
Course Objectives
This course enables the students:
1. To assess how the choice of data structures and algorithm design methods
impact the performance of programs.
2. To choose the appropriate data structure and algorithm design method for a
specified application.
3. To solve problems using data structures such as linear lists, stacks, queues,
hash tables, binary trees, heaps, binary search trees, and graphs and writing
programs for these solutions.
4. Analyse and compare the different algorithms
Course Outcomes
After the completion of this course, students will be able to:
CO1 Choose an appropriate data structure given a computational problem
CO2 Design and analyze the time and space efficiency of various data structures
CO3 Analyze run-time execution of previous learned sorting methods, including
selection, merge sort, heap sort and quick sort
CO4 Have practical knowledge on the applications of data structures
CO5 Justify the choice of data structure for a given problem
SYLLABUS
Text books:
1. Baluja G S, “Data Structure through C”, Ganpat Rai Publication, New Delhi, 2015.
2. Pai G A V, “Data Structures and Algorithms: Concepts, Techniques and Applications”,
2ndEdn, Tata McGraw-Hill, 2008.
3. Horowitz E., Sahni S., Susan A., “Fundamentals of Data Structures in C”, 2nd Edition,
University Press, 2010.
Reference books:
Course Objectives
This course enables the students:
1. To observe that how the real world data is stored, retrieved, and communicate under
the DBMS environment
2. To design a logical model which having the unique relation between the Data.
3. To apply the query for the modification of the system.
4. To develop a conceptual design which allows as to avoid anomalies in superior’s
data.
5. To discuss a system which allows to restrict the uncontrolled exaction and provide
rigorous variation of the task.
Course Outcomes
After the completion of this course, students will be able to:
CO1 Describe various data models and schemas used in database management systems.
CO2 Explain the fundamental concepts, data definitions and query processing tasks in
relational query languages.
CO3 Recognize database design theory, and evaluate functional dependencies and normal
forms in databases.
CO4 Formulate the operations of transaction and concurrent query processing tasks to
obtain the correct results even under strict time constraints.
CO5 Interpret the foundational concepts of distributed databases. Illustrate several
techniques related to transaction management and query processing in distributed
database management systems.
SYLLABUS
emp(empno,ename,job,mgr,hiredate,sal,comm,deptno,gr),
dept(deptno,dname,loc)
SMITH CLERK
ALLEN SALESMAN
SMITH ( Clerk)
ALLEN ( Salesman)
30. Do a case sensitive search for a list of employees with a job that the user enters.
31. It has been discovered that the sales people in dept. 30 are not all male. Please produce
thefollowingoutput.
ENAME DEPTNO JOB
51. Display all employees who earn less than their managers.
52. Display all employees by name and eno along with their managers name and number.
53. Modify above spoliation to display KING who has no MANAGER.
54. Find the job that was files in the first half of 1983 and the name job that was filled in the
same period in 1984.
55. Find all employees who have joined before their manager.
EMPLOYEE HIREDATE MANAGER HIREDATE
56. Find the employees who earn the highest salary in each job, type, sort in descending
order
of salary.
57. Find the employees who earn the minimum salary for their job, Display the result in
descending order of salary
58. Find the most recently hired employees in the department. Order by hiredate.
59. Show the details of any employee who earns a salary greater than the average for their
department. Sort in department number order.
60. List all department where there are no employees.
Text book:
1. SQL, PL/SQL the programming Language of Oracle, Ivan Bayross, 4th edition
Indirect Assessment –
1. Student Feedback on Faculty
2. Student Feedback on Course Outcome
Course Objectives
This course enables the students to:
SYLLABUS
11.Write a Program illustrating how the constructors are implemented and the order in
which they are called when the classes are inherited. Use three classes named alpha, beta,
gamma such that alpha, beta are base class and gamma is derived class inheriting alpha &
beta.
Objective: To Understand and Implement exception handling
12. Write a program to raise an exception if any attempt is made to refer to an element
whose index is beyond the array size.
Books recommended:
Text books:
E. Balagurusamy - Programming in Java, 2nd Edition; Tata McGraw Hill Publication; New
Delhi.
Reference books:
Patrick Naghton & H. Schildt – The Complete Reference Java 2, Tata McGraw Hill Publication,
New Delhi.
Dietel,Dietel - Java How to program , 7th edition; Pearson Education , New Delhi.
COURSE OUTCOME (CO) ATTAINMENT ASSESSMENT TOOLS & EVALUATION
PROCEDURE
Direct Assessment
Indirect Assessment –
1. Student Feedback on Faculty
2. Student Feedback on Course Outcome