Computer Science Syllabus (4th Semester) 1 of 17

G.B. TECHNICAL UNIVERSITY

LUCKNOW

Syllabus
of
Computer Science & Engineering
2nd Year (IV Sem.)

[Effective from Session 2009-10]

B.Tech.

Ankur Goel [email protected]

 Computer Science Syllabus (4th Semester) 2 of 17

Ankur Goel [email protected]

 Computer Science Syllabus (4th Semester) 3 of 17

Industrial Sociology
EHU-402
LTP
200
Unit-I
Industrial Sociology : Nature and Scope of Industrial Sociology-Development of
Industrial Sociology.

Unit-II
Rise and Development of Industry : Early Industrialism – Types of Productive
Systems– The Manorial or Feudal system – The guild system – The domestic or
putting-out system – and the factory system – Characteristics of the factory system –
causes andConsequences of industrialization.

Unit-III
Industrialization in India. Industrial Poling Resolutions – 1956.

Unit-IV
Contemporary Issues : Grievances and Grievance handling Procedure.
Industrial Disputes : courses, strikes & lockouts, Industrial Relations Machinery Bi-
partite& Tri-partite Agreement, Labour courts & Industrial Tribunals, Code of
Discipline,Standing order.

References :
1. GISBERT PASCAL, Fundamentals of Industrial sociology, Tata McGraw Hill
Publishing Co., New Delhi, 1972.
2. SCHNEIDER ENGNO V., Industrial Sociology 2nd Edition, McGraw Hill
Publishing Co.,New Delhi, 1979.
3. MAMORIA C.B. And MAMORIA S., Dynamics of Industrial Relations in India.
4. SINHA G.P. and P.R.N. SINHA, Industrial Relations and Labour Legislations, New
Delhi, Oxford and IBH Publishing Co., 1977.

Ankur Goel [email protected]

 Computer Science Syllabus (4th Semester) 4 of 17

INTRODUCTION TO SOFT COMPUTING

(Neural Networks, Fuzzy Logic and Genetic Algorithm)
EOE-041

LTP
310

Unit-I
Neural Networks-1
(Introduction & Architecture)
Neuron, Nerve structure and synapse, Artificial Neuron and its model, activation
functions,
Neural network architecture: single layer and multilayer feed forward networks,
recurrent
networks.Various learning techniques; perception and convergence rule,
Auto-associative and hetro-associative memory.
8
Unit-II
Neural Networks-II
(Back propogation networks)
Architecture: perceptron model, solution, single layer artificial neural network,
multilayer
perception model; back propogation learning methods, effect of learning rule co-
efficient ;back
propagation algorithm, factors affecting backpropagation training, applications.
8
Unit-III
Fuzzy Logic-I
(Introduction)
Basic concepts of fuzzy logic, Fuzzy sets and Crisp sets, Fuzzy set theory and
operations,
Properties of fuzzy sets, Fuzzy and Crisp relations, Fuzzy to Crisp conversion.
8
Unit-IV
Fuzzy Logic –II
(Fuzzy Membership, Rules)
Membership functions, interference in fuzzy logic, fuzzy if-then rules, Fuzzy

Ankur Goel [email protected]

 Computer Science Syllabus (4th Semester) 5 of 17

implications and Fuzzy algorithms, Fuzzyfications & Defuzzificataions, Fuzzy

Controller, Industrial applications.

Unit-V
Genetic Algorithm(GA)
Basic concepts, working principle, procedures of GA, flow chart of GA, Genetic
representations, (encoding) Initialization and selection, Genetic operators, Mutation,
Generational Cycle, applications.
8

Text Books:

1.S. Rajsekaran & G.A. Vijayalakshmi Pai, “Neural Networks,Fuzzy Logic and
Genetic Algorithm:Synthesis and Applications” Prentice Hall of India.
2.N.P.Padhy,”Artificial Intelligence and Intelligent Systems” Oxford University
Press.

Reference Books:

1.Siman Haykin,”Neural Netowrks”Prentice Hall of India.

2.Timothy J. Ross, “Fuzzy Logic with Engineering Applications” Wiley India.
3. Kumar Satish, “Neural Networks” Tata Mc Graw Hill.

Ankur Goel [email protected]

 Computer Science Syllabus (4th Semester) 6 of 17

INTRODUCTION TO MICROPROCESSOR
EEC-406
LT P
310

Unit-I Introduction:
Microprocessor evolution and types, microprocessor architecture and operation of its
components, addressing modes, interrupts, data transfer schemes, instruction and data
flow, timer and timing diagram. Interfacing devices. Architectural advancement of
microprocessor. Typical microprocessor development schemes.
(10)
Unit-II *-bit Microprocessors:
Pin diagram and internal architecture of 8085 microprocessor, registers, ALU, Control
& statu, interrupt and machine cycle.Instruction sets. Addressing modes. Instruction
formats,Instruction Classification: data transfer, arithmetic operations, logical
operations,branching operations, machine control and assembler directives.

Unit-III 16-bit Microprocessor:

Architecture of 8086 microprocessor: register organization, bus interface unit,
execution unit, memory addressing, memory segmentation.
Operating modes. Instruction sets, instruction format, Types of instructions.
Interrupts: hardware and software interrupts.

Unit-IV Programming:
Assembly language programming based on intel 8085/8086. Instructions, data transfer,
arithmetic, logic, branch operations, looping, counting, indexing, programming
techniques, counters and time delays, stacks and subroutines, conditional call and
return instructions

Unit-V Peripheral Interfacing:

Peripheral Devices: 8237 DMA Controller, 8255 programmable peripheral interface,
8253/8254programmable timer/counter, 8259 programmable interrupt controller, 8251
USART and RS232C.

Ankur Goel [email protected]

 Computer Science Syllabus (4th Semester) 7 of 17

Books

1. Gaonkar , Ramesh S , “Microprocessor Architecture, Programming and

Applications with 8085”, Penram International Publishing.
2. Ray A K , Bhurchandi K M , “Advanced Microprocessors and Peripherals”,
TMH
3. Hall D V ,”Microprocessor Interfacing’, TMH
4. Liu and Gibson G A , “ Microcomputer System: The 8086/8088 family’’ ,PHI
5. Aditya P Mathur, “ Introduction to Microprocessor”, TMH
6. Brey, Barry B, “INTEL Microprocessors”, PHI
7. Renu Sigh & B.P.Sigh, “Microprocessor, Interfacing and Applications
8. M Rafiqzzaman, “Microprocessors, Theory and Applications”.

Ankur Goel [email protected]

 Computer Science Syllabus (4th Semester) 8 of 17

COMPUTER ORGANIZATION
ECS-401

LTP
310

Unit-I Introduction:
Number representation; fixed and floating point number representation, IEEE standard
for floating point representation. Error detection and correction codes: Hamming code.
Digital computer generation, computer types and classifications, functional units and
their interconnections, buses, bus architecture, types of buses and bus arbitration.
Register, bus and memory transfer.

Unit-II Central Processing Unit:

Addition and subtraction of signed numbers, look ahead carry adders. Multiplication:
Signed operand multiplication, Booths algorithm and array multiplier. Division and
logic operations. Floating point arithmetic operation Processor organization, general
register organization, stack organization and addressing modes.

Unit-III Control Unit:

Instruction types, formats, instruction cycles and subcycles ( fetch and execute etc) ,
micro-operations, execution of a complete instruction. Hardwire and microprogrammed
control: microprogramme sequencing, wide branchaddressing, microinstruction with
next address field, pre-fetching microinstructions, concept of horizontal and vertical
microprogramming.

Unit-IV Memory:
Basic concept and hierarchy, semiconductor RAM memories, 2D & 2 1/2D memory
organization. ROM memories. Cache memories: concept and design issues 9
performance, address mapping and replacement) Auxiliary memories: magnetic disk,
magnetic tape and optical disks Virtual memory: concept implementation.

Unit-V Input / Output:

Peripheral devices, I/O interface, I/O ports, Interrupts: interrupt hardware, types of
interrupts and exceptions. Modes of Data Transfer: Programmed I/O, interrupt initiated
I/O and Direct Memory Access., I/O channels and processors.
Serial Communication: Synchronous & asynchronous communication, standard

Ankur Goel [email protected]

 Computer Science Syllabus (4th Semester) 9 of 17

communication interfaces.

Books

1. Patterson, Computer Organisation and Design, Elsevier Pub. 2009

2. William Stalling, “ Computer Organization”, PHI
3. Vravice,Hamacher & Zaky, “Computer Organization”, TMH
4. Mano,” Computer System Architecture”, PHI
5. John P Hays, “ Computer Organization”, McGraw Hill
6. Tannenbaum,” Structured Computer Organization’, PHI
7. P Pal chaudhry, ‘ Computer Organization & Design’, PHI

Ankur Goel [email protected]

Computer Science Syllabus (4th Semester) 10 of 17

DATA BASE MANAGEMENT SYSTEM

ECS-402

LTP
310

Unit-I
Introduction: An overview of database management system, database system Vs file
system, Database system concept and architecture, data model schema and instances,
data independence and database language and interfaces, data definitions language,
DML, Overall Database Structure. Data Modeling using the Entity Relationship Model:
ER model concepts, notation for ER diagram, mapping constraints, keys, Concepts of
Super Key, candidate key, primary key, Generalization, aggregation, reduction of an ER
diagrams to tables, extended ER model, relationship of higher degree.

Unit-II
Relational data Model and Language: Relational data model concepts, integrity
constraints, entity integrity, referential integrity, Keys constraints, Domain constraints,
relational algebra, relational calculus, tuple and domain calculus.
Introduction on SQL: Characteristics of SQL, advantage of SQL. SQl data type and
literals. Types of SQL commands. SQL operators and their procedure. Tables, views
and indexes. Queries and sub queries. Aggregate functions. Insert, update and delete
operations, Joins, Unions, Intersection, Minus, Cursors, Triggers, Procedures in
SQL/PL SQL.

Unit-III
Data Base Design & Normalization: Functional dependencies, normal forms, first,
second, third normal forms, BCNF, inclusion dependence, loss less join
decompositions, normalization using FD, MVD, and JDs, alternative approaches to
database design.

Unit-IV
Transaction Processing Concept: Transaction system, Testing of serializability,
serializability of schedules, conflict & view serializable schedule, recoverability,
Recovery from transaction failures, log based recovery, checkpoints, deadlock
handling. Distributed Database: distributed data storage, concurrency control, directory
system.

Ankur Goel [email protected]

Computer Science Syllabus (4th Semester) 11 of 17

Unit-V
Concurrency Control Techniques: Concurrency control, Locking Techniques for
concurrency control, Time stamping protocols for concurrency control, validation
based protocol, multiple granularity, Multi version schemes, Recovery with concurrent
transaction, case study of Oracle.

Books

1. Date C J, “ An Introduction to Database Systems”, Addision Wesley

2. Korth, Silbertz, Sudarshan,” Database Concepts”, McGraw Hill
3. Elmasri, Navathe, “ Fudamentals of Database Systems”, Addision Wesley
4. O’Neil, Databases, Elsevier Pub.
5. Leon & Leon,”Database Management Systems”, Vikas Publishing House
6. Bipin C. Desai, “ An Introduction to Database Systems”, Gagotia Publications
7. Majumdar & Bhattacharya, “Database Management System”, TMH
8. Ramkrishnan, Gehrke, “ Database Management System”, McGraw Hill
9. Kroenke, “ Database Processing Fundamentals , Design and Implementation”
Pearson Education.
10. D.Ulman, “ Principles of Database and Knowledge base System”, Computer
Science Press.
11. Maheshwari Jain.’DBMS: Complete Practical Approach”, Firewall Media, New
Delhi

Ankur Goel [email protected]

Computer Science Syllabus (4th Semester) 12 of 17

THEORY OF AUTOMATA AND FORMAL LANGUAGES

ECS-403
LTP
310

Unit – I
Introduction; Alphabets, Strings and Languages; Automata and Grammars,
Deterministic finite Automata (DFA)-Formal Definition, Simplified notation: State
transition graph, Transition table, Language of DFA, Nondeterministic finite Automata
(NFA), NFA with epsilon transition, Language of NFA, Equivalence of NFA and DFA,
Minimization of Finite Automata, Distinguishing one string from other, Myhill-Nerode
Theorem.

Unit – II
Regular expression (RE) , Definition, Operators of regular expression and there
precedence, Algebraic laws for Regular expressions, Kleen’s Theorem, Regular
expression to FA, DFA to Regular expression, Arden Theorem, Non RegularLanguages,
Pumping Lemma for regular Languages. Application of Pumping Lemma, Closure
properties of Regular Languages, Decision properties of Regular Languages, FA with
output: Moore and Mealy machine, Equivalence of Moore and Mealy Machine,
Applications and Limitation of FA.

Unit – III
Context free grammar (CFG) and Context Freee Languages (CFL): Definition,
Examples, Derivation , Derivation trees, Ambiguity in Grammer, Inherent ambiguity,
Ambiguous to Unambiguous CFG, Useless symbols, Simplification of CFGs, Normal
forms for CFGs: CNF and GNF, Closure properties of CFLs, Decision Properties of
CFLs: Emptiness, Finiteness and Memership, Pumping lemma for CFLs.

Unit – IV
Push Down Automata (PDA): Description and definition, Instantaneous Description,
Language of PDA, Acceptance by Final state, Acceptance by empty stack,
Deterministic PDA, Equivalence of PDA and CFG, CFG to PDA and PDA to CFG,
Two stack PDA.

Unit – V
Turing machines (TM): Basic model, definition and representation, Instantaneous

Ankur Goel [email protected]

Computer Science Syllabus (4th Semester) 13 of 17

Description, Language acceptance by TM, Variants of Turing Machine, TM as

Computer of Integer functions, Universal TM, Church’s Thesis, Recursive and
recursively enumerable languages, Halting problem, Introduction to Undecidability,
Undecidable problems about TMs. Post correspondence problem (PCP), Modified PCP,
Introduction to recursive function theory.

Text Books and References:

1. Hopcroft, Ullman, “Introduction Computation to Automata Theory, and Languages

”, Pearson Education.
2. K.L.P. Mishra and N.Chandrasekaran, “Theory of Computer Science : Automata,
Languages and Computation”, PHI.
3. Martin J. C., “Introduction to Languages and Theory of Computations”, TMH
4. Papadimitrou, C. and Lewis, C.L., “Elements of the Theory of Computation”, PHI

Ankur Goel [email protected]

Computer Science Syllabus (4th Semester) 14 of 17

MICROPROCESSOR LAB
EEC-456
LTP
002

1.To study 8085 microprocessor System.

2. To study 8086 microprocessor System.
3. To develop and run a programme to find out largest and smallest number.
4. To develop and run a programme for converting temperature from F to C degree.
5. To develop and run a programme to compute square root of a given number.
6. To develop and run a programme for computing ascending/descending order of a
number.
7. To perform interfacing of RAM chip to 8085/8086.
8. To perform interfacing of keyboard controller.
9. To perform interfacing of DMA controller.
10. To perform interfacing of UART/USART.

Ankur Goel [email protected]

Computer Science Syllabus (4th Semester) 15 of 17

DBMS LAB
ECS-452
LTP
002

1. Write the queries for Data Definition and Data Manipulation Language.
2. Write SQL queries using logical operations (=,<,>,etc)
3. Write SQL queries using SQL operators
4. Write SQL query using character, number, date and group functions
5. Write SQL queries for relational algebra
6. Write SQL queries for extracting data from more than one table
7. Write SQL queries for sub queries, nested queries
8. Write programme by the use of PL/SQL
9. Concepts for ROLL BACK, COMMIT & CHECK POINTS
10. Create VIEWS, CURSORS and TRGGERS & write ASSERTIONS.
11. Create FORMS and REPORTS.

Note:
1. The queries to be implemented on DBMS using SQL.
2. Students are advised to use Developer 2000/Oracle9i or other latest version for
above experiments.. However student may use Power Builder/SQL SERVER .
Mini Projects may also be planned & carried out through out the semester to
understand important concepts of database.

Ankur Goel [email protected]

Computer Science Syllabus (4th Semester) 16 of 17

COMPUTER ORGANIZATION LAB

ECS-453

LTP
002

1.Bread Board Implementation of Flip-Flops.

2. Experiments with clocked Flip-Flop.
3. Design of Counters.
4. Bread Board implementation of counters & shift registers.
5. Implementation of Arithmetic algorithms.
6. Bread Board implementation of Adder/Subtractor (Half, Full)
7. Bread Board implementation of Binary Adder.
8. Bread Board implementation of Seven Segment Display.

Note: Institute may also develop the experiment based on the infrastructure available
with them.

Ankur Goel [email protected]

Computer Science Syllabus (4th Semester) 17 of 17

Bibliography

1. http://uptu.ac.in/academics/syllabus/uptu_study_scheme_1cs.pdf
2. http://uptu.ac.in/academics/syllabus/compulsory_subject_for_all_btech_courses.p
df

For any other acknowledgment you can contact me at my email.

[email protected]

http://ankurgoel.tk/

Ankur Goel [email protected]