MCA Syllabus

RELATIONAL DATA BASE MANAGEMENT SYSTEM -II
MCA-401
Internal Assessment: 40
External Assessment: 60

SECTION -A
Degree of Data Abstraction, The Database life Cycle (DBLC): Initial study of the database, Database Design, Implementation and loading, Testing and Evaluation, Operation, Maintenance and evolution
SECTION - B
Centralized verses Decentralized Design, >what is a Transaction?, Concurrency Control (Locking Methods, Time stamping Method, Optimistic Method)DDBMS (Distributed Database Management Systems) Advantages and Disadvantages. Homogeneous and Heterogeneous DBMS, Distributed Databases Transparency features. Levels of Data and Process Distribution: SPSD (Single-site processing, Single-Site Data), MPSD (Multiple-Site Processing, Single-Site Data), MPMD (Multiple-Site processing, Multiple-Site Data)
SECTION - C
Client / Server systems, What is Client / Server? The forces that drive client / server system, client / server: Architecture and implementation issues
SECTION - D
(DSS) Decision Support Systems: Operational data vs. Decision support Data, The DSS Database requirements. The Data warehouse: The Evolution of the Date warehouse, rules for data warehouse. On-line Analytical Processing (OLAP): OLAP architecture relational, OLAP and comparison ,Data mining.
REFERENCES:
1. An Introduction to Database Systems (sixth Edition) By C. J. Date
2. Database Systems (3rd Edition) Galgotia Publications (P) Ltd. By Peter Rob Carlos Coronel
3. An Introduction to Database Systems By Bipin. C. Desai

SOFTWARE ENGINEERING
MCA-402
Internal Assessment: 40
External Assessment: 60

A) Instructions for paper-setter The question paper will consist of five sections A, B, C, D and E. Sections A, B, C and D will have two questions from the respective sections of the syllabus. Section E will have 10 short answer type questions which will cover the entire syllabus uniformly and will carry 20 marks in all.
B) Instructions for candidates
1. Candidates are required to attempt one question each from sections A, B, C and D of the question paper and the entire section E.
2. Use of non-programmable scientific calculator is allowed.
SECTION-A
Software : Characteristics, Components, Applications, Software Process Models : Waterfall, Spiral, Prototyping, Fourth Generation Techniques, Concepts of Project Management , Role of Metrics & Measurements .
SECTION-B
S/W Project Planning : Objectives, Decomposition techniques : S/W Sizing, Problem-based estimation, Process based estimation, Cost Estimation Models : COCOMO Model, The S/W Equation, System Analysis : Principles of Structured Analysis, Requirement analysis , DFD, Entity Relationship diagram, Data dictionary.
SECTION-C
S/W Design: Objectives, Principles, Concepts, Design methodologies: Data design, Architectural design, procedural design, Object -oriented concepts
SECTION-D
Testing fundamentals: Objectives, principles, testability, Test cases: White box & Black box testing, Testing strategies: verification & validation, unit test, integration testing, validation testing, system testing
References :
1. Roger. S. Pressman, "Software Engineering - A Practitioner's Approach", McGraw Hill
2. R.E. Fairley, "Software Engineering Concepts", McGraw-Hill.
3. Jalota, "An Integrated Approach to Software Engineering", (Narosa Publishing House).

COMPUTER NETWORKS
MCA-403
Internal Assessment: 40
External Assessment: 60

A) Instructions for paper-setters The question paper will consist of five sections A, B, C, D and E. Sections A, B, C and D will have two questions from the respective sections of the syllabus and will carry 10 marks each. Section E will have 10-20 short answer type questions which will cover the entire syllabus uniformly and will carry 20 marks in all.
B) Instructions for candidates
1. Candidates are required to attempt one question each from sections A, B, C and D of the question paper and the entire section E.
2. Use of non-programmable scientific calculator is allowed.
SECTION-A
Introduction to Data Communication; Analog VS. Digital Communication; Fourier Analysis, Band Width Limitation, Data rate of a channel, Error Detection and Correction: Nature of errors, parity check, CRC, Hamming Code, Modulation techniques, AM, PM, FM, Synchronous and Asynchronous Modulation; Multiplexing; SDM, FDM, TDM, STDM,
SECTION-B
Introduction to Computer networks and applications; Network Structure and Architecture, OSI reference model, Network standardization, Physical Layer: Circuit switching, Packet Switching, Message Switching, Terminal handling, Telephone system, modems, concentrators, Transmission Media.
SECTION-C
The Data link layer: Design Issues, Elementary Data Link Protocols, Sliding Window Protocol: One bit sliding window protocol, DLL in X.25., HDLC/SDLC, Multichannel access: ALOHA,CSMA/CD, collision free protocol, Introduction to IEEE Standards : 802.3, 802.4, 802.5.
SECTION-D
The Network Layer: Design Issues, Routing Algorithms: Optimality principle, shortest path routing, flooding, Broadcast & Multicast routing, Congestion control Algorithms: Principles of congestion control, flow specifications, choke packets, Concept of Internet Working.
BOOKS :
1. Andrew S. Tanenbaum, "Computer Networks 2nd edition", PHI , Third Edition 1997.
2. Schwaber, "Data Communication",
3. William Stalling Maxwell, "Data and Computer Communication", 2nd edition, Macmillan International edition.

MICROPROCESSOR
MCA-404
Internal Assessment: 40
External Assessment: 60

Introduction to microprocessor, its historical background, Microprocessor applications, Microprocessor Architecture, real and protected mode memory addressing, memory paging. Addressing modes
Introduction to 8085, its instruction cycle and Timing diagram, Memory read and write operations, Instruction set for 8085, RISC v/s CISC processors.
Various types of instructions : Data movement, Arithmetic and logic; and program control. Type of instructions, pin diagram of 8086, clock generator (8284A)
Interrupts, 8259 Interrupt controller, 8237 DMA and basic DMA operation; Arithmetic coprocessor, 80 x 87 Architecture, Instruction set.
REFERENCES:
1. B. Brey The intel micro processors 8086/8086, 80186/80188, 80286,80386,80486 pentium and pentium pro processor Architecture, programming and interfacing 4th Edition.
2. B. Ram Fundamentals of microprocessors and HI microcomputers Dhanpat Bai Publication

ROBOTICS ENGINEERING(ELECTIVE I)
MCA-405
Internal Assessment: 40
External Assessment: 60

Section A
Introduction to Robotics, Manipulators & Mobile Robots, Classification of Robots, Robot Applications. Industrial application environment and workcells. Feeders and Oriented devices.Robot Anatomy, Robot and Effectors, Transmission and actuators, with special reference to servomotors.
Section B
Robot Arm Kinematics, World, Tool and joint co-ordinates, DH transformation and inverse Kinematics.Fundamentals of Closed loop control, PWM amplifiers, PID control, Robotics Sensors : Range, Proximity, Touch, Force & Torque Sensing, Uses of sensors in Robotics.
Section C
Machine Vision : Introduction to machine Vision, The sensing and digitizing function in Machine Vision, Image Processing and analysis, Training and Vision System, Robotic Application, Low & High Level Vision
Section D
Robot Programming & Languages & Environment : Different methods, Features of various programming methods, Case study, Robot Task Planning : concept, Different Methods, Robot Learning. Mobile Robot : Introduction, obstacle Representation, Motion Planning in fixed, Changing structured.
ARTIFICIAL INTELLIGENCE (ELECTIVE I)
MCA-405
Internal Assessment: 40
External Assessment: 60


SECTION - A
Introduction to AI : AI Problems, Underlying Assumption, AI technique, Level of the model, Criteria for success.
Problems, problem spaces and search : Defining the problem-Water jug problem, Production systems, problem characteristics, and Production system characteristics.
SECTION - B
Heuristic Search Techniques, Knowledge Representation : Approaches Issues Predicate Logic, Expert System. SECTION - C Weak and strong slot-and-filler structures : Weak : Semantic Nets, Frames as sets and Instances. Strong : Scripts, CYC.
SECTION - D
Natural language processing : Introduction, syntactic processing - Top down v/s Bottom up Parsing, Semantic analysis - Lexical processing, Sentence level processing Morphological, discourse and pragmatic processing.
References :
1. E. Rich and Knight, " Artificial Intelligence", Tata McGraw Hill.
2. E. Charnaik and D. McDermott, "Introduction to artificial Intelligence," Addison - Welsey Publishing Company.
3. Nils J. Nilson, "Principles of Artificial Intelligence," Narosa Publishing Co.

COMPUTER PERIPHERALS AND INTERFACES
MCA-405
Internal Assessment: 40
External Assessment: 60

A) Instruction for paper-setter The question paper will consist of five sections A, B, C, D and E. Sections A, B, C and D will have two questions from the respective sections of the syllabus and will carry 10 marks each. Section E will have 10 short answer type questions which will cover the entire syllabus uniformly and will carry 20 marks in all
B) Instruction for candidates
1. candidate are required to attempt one question each from section A, B, C and D of the question paper and the entire section E.
2. Use of non-programmable scientific calculator is allowed.
OBJECTIVES At the end of this course on Computer Peripheral & Inter faces, the student be able : To learn the functional details of various peripheral devices i.e. video display units, disks tapes cartridges printers, Fax - Modems, TV, Interface, sound and video Blasters, CD-ROM, CD - WORM, DVD, Keyboard, Mouse, Digitizers and Plotters. To learn about different serial and parallel interfacing techniques different types of bus connections. To learn the software aspects of handling a peripheral device through the study of Input/Output drivers of the operating system. To learn design and integration of a peripheral device to a computer system.
COURSE OBJECTIVES
Introduction to Input/Output communication in Computers - Programmed I/O, Interrupt, DMA, Special I/O controllers, I/O Processors.
Computer System Peripherals - Video Display EGA/VGA/SVGA Architectures and Adapters, Mouse Tablet, Magnetic Tape, Floppy disk, Hard disk, Optical disk, dot matrix printers, laser printers, line printers, CD-ROM DRIVE, CD-WORM DRIVE, DVD Keyboard and Plotters.
Serial data Communication - Synchronous and Asynchronous buses, Centronix, ISA, VESA, PCI, MCA, SCSI, EISA and support chip details.
Future Trends, Analysis of Recent Progress in the Peripheral and Bus System. Some Aspects of Cost performance analysis while designing the system.
TEXTS / REFERENCES :
ｷ P. Pal Chaudhari Computer Organisation and Design Prentice Hall of India Pvt. Ltd. 1994
ｷ Robery S. Lai The Group Digital Bus Handbook McGraw Hill Publishing company 1990
ｷ Del Corso, J. D. Nicoud, Microcomputer buses and Links Academic Press 1986
ｷ Govindarajalu IBM PC and Clones : hardware Trouble Shooting and Maintenance Tat McGraw Hill 1991
ｷ Douglas V. Hall Microprocessor and Interfacing programming and Hardware McGraw Hill International Editions, 2nd Edition 1992.

SOFTWARE LAB VII (RDBMS II)
MCA-406
Internal Assessment: 40
External Assessment: 60

This laboratory course will mainly comprise of exercises on what is learnt under the paper: MCA-401 (RDBMS-II)
*
Maximum Marks for Continuous Assessment: 40
Maximum Marks for University Examination: 60
Note: The break up of marks for the practical (University examination) will be as unde
Lab Record15
Marks Viva Voce 15
Marks Program Development 30
Marks And Execution

HARDWARE LAB (UP)
MCA-407
Internal Assessment: 40
External Assessment: 60

This laboratory course will mainly comprise of exercises on what is learnt under the paper: MCA-404 (UP)
*
Maximum Marks for Continuous Assessment: 40
Maximum Marks for University Examination: 60
Note: The break up of marks for the practical (University examination) will be as under
Lab Record 15
Marks Viva Voce 15
Marks Program Development 30
Marks And Execution