POST GRADUATE COURSE POST GRADUATE DIPLOMA IN COMPUTER APPLICATION (PGDCA) The broad objective of PGDCA programme is to prepare students for careers in software industry and understanding the skills related to the use of Computers and its application. The PGDCA programme provides a platform for possibility of moving on to MCA. Eligibility: The programme is open to graduates with Mathematics as a distinct subject at the 10+2 level. Students without mathematics will have to pass in Foundation Course in Mathematics (CS-60) along with the PGDCA course. Medium of Instruction: The programme is offered in English only. Duration of the Course: Minimum: One Year. Maximum: Three Years from the date of Registration. Credit Points: The Fakir Mohan University follows the Credit System for the Post Graduate programme. The PGDCA programme comprises of 12 courses involving 36 credit points.

PROGRAMME STRUCTURE AND MARK DISTRIBUTION: Mark distribution Year/ Course Semt Code

Credit Points

Mid-sem/ Practical assignme exam nt

Final /FET

Total

3

20

---

80

100

4

20

---

80

100

MCS-13 Discrete Mathematics

2

20

---

80

100

MCS-14 System Analysis & Design

3

20

---

80

100

MCS-15 Communication Skills

2

20

---

80

100

MCSL16

Internet Concepts & Web Design Lab

2

100

---

100

MCSL17

C & Assembly Language Programming Lab

2

100

---

100

CS-60*

Foundation Course in Mathematics in Non Computing (For Non Math students) Credit

20

---

80

100

4

20

---

80

100

Course Title

MCS-11 Problem Solving & Programming MCS-12

I

1 Y E A R

Computer Organization and Assembly Language Programming

MCS-21 Data & File Structures

II

MCS-22

Operating System Concepts and Networking Management

4

20

---

80

100

MCS-23

Introduction to Database Management System

3

20

---

80

100

MCS-24

Object Oriented Technologies & Java Programming

3

20

---

80

100

MCSL25

Lab-Based on MCS-021, 022, 023, & 024

4

100

---

100

TOTAL

36

Course Fee: The Course Fee for PGDCA is Rs.8, 000 (Rs. 4000 per semester).

1200

REGULATION FOR PGDCA COURSE TITLE: After successful completion of the course the student will be awarded with the ‘Post Graduate Diploma in Computer Application (PGDCA)’ from Fakir Mohan University, Balasore. COURSE VENUE: The DISTANCE EDUCATION STUDY CENTRES of the University designated by the Syndicate can only offer this course EVALUATION SYSTEM: Each semester examination shall consist of two parts: mid-semester test and end-semester examination having the weightage of 20% and 80% respectively for theory papers. The course will consist of 1200 marks. ANCILLARY PAPER: There shall be one ancillary paper in the first semester i.e. ‘Foundation Course in Mathematics (CS-60) the ancillary paper shall consist of 100 marks. A student is required to pass in the ancillary papers but it will not be included in the aggregate. ATTENDANCE: A student has to attend a minimum of 75% of classes both in theory and practical separately to be permitted to sit for the end-semester examination. In case of medical ground, if certified by a Medical Officer not below M.B.B.S. doctor his/ her case may be considered with a minimum attendance of 60% and in no case below this. In case a candidate is unable to acquire the stipulated attendance at the end of any semester, he/ she will not be allowed to take the endsemester examination. The candidate shall have to take re-admission in the concerned semester and acquire minimum stipulated attendance to be eligible for taking the examination. MID SEMESTER EXAMINATION: The mid semester test with a weightage of 20% will be conducted by the teacher teaching the paper who will also evaluate the scripts and show it to the students. EVALUATION OF ANSWER SCRIPTS: Answer scripts of the end term examination will be valued by the examiners appointed by this university. For the End semester examination of theory papers, the questions in each paper shall be set in such a way that a student has to answer one question from each unit of the syllabus of the paper. QUALIFYING LEVEL : In order to pass a theory paper a candidate has to secure at least 40% of the marks at the end semester examination and 40% in aggregate of both end semester and mid semester examination of that paper. For passing a practical paper/project a candidate has to secure at least 50% of the marks in that paper. CREDIT SYSTEM: If a candidate passes all the six semester examinations, he/she will be declared to have passed the Post Graduate Diploma in Computer Application (PGDCA) examination in: (i) First class if he/she secures 60% or more in aggregate of all semester examinations taken together. (ii) Second class if he/she secures 50% or more but less than 60% marks in aggregate of all semester examinations taken together. (iii) General class if he or she secures 40% or more but less than 50% marks in aggregate of all semester examinations taken together. BACK EXAMINATION: If a candidate fails in any one paper (or papers) in any semester examination he/she has to appear the end semester examination for that paper (papers) only whenever the said semester examination is held. If a candidate passes in all the papers of a semester examination but fails in the aggregate then he may appear in one more of the papers of that semester examination in order to make up the aggregate whenever such examination is held. MAXIMUM TENURE: The course has to be completed by a student in all respects in not more than 3 years from the date of his/her admission in to the course failing which the results of the examinations appeared by him/her shall stand cancelled. LATERAL ENTRY: Students completing PGDCA programme will be eligible for 3rd Semester entry into MCA Program.

1ST SEM PGDCA MCS-11: PROBLEM SOLVING AND PROGRAMMING F.M-80 Time-3hrs Unit 1: An Introduction to C Problem Solving, Problem -Solving Techniques, Design of Algorithms, Analysis of Algorithm Efficiency, Analysis of Algorithm Complexity , Flowcharts ,Basics of C: What is a Program and what is a Programming Language ? C Language, Structure of C program, writing a C Program, Compiling a C Program, Link and Run the C program, Diagrammatic Representation of Program Execution Process. Variables and Constants, Character Set ,Identifiers and Keywords, Data Type and Storage ,Data Type and qualifiers,Variables,Declaring Variables, Initializing, Variables, Constants . Unit 2: Expressions and Operators Assignment Statements, Arithmetic Operators, and Relational Operators, Logical Operators, Comma and Conditional Operators, Type Cast Operators, Size of Operator Shorthand, Priority of Operators, Control Statements, Arrays and Functions: Decisions and Loop Control Statements, Decision Control Statements, Loop Control Statements, the Go To Statement, the Break Statement, the Continue Statement, Arrays: Array Declaration, Array, Initialization, Subscript, Processing the Arrays, Multi-Dimensional Arrays. Unit 3: Strings Declaration and Initialization of Strings, Display of Strings Using Different, Formatting Techniques, Array of Strings, Built-in String Functions and Applications, Other String Functions, Functions: Definitions of a Function, Declaration of a Function, Function Prototypes, The Return Statement, Types of Variables and Storage Classes, Types of Function Invoking, Call by Value, Recursion. Unit 4: Structures, Pointers and File Handling Structures and Unions, Declaration of Structures, Accessing the Members of a Structure, Initializing Structure, Structures as Function Arguments, Structures and Arrays, Unions, Initializing an Union, Accessing the Members of an Union, Pointers: Pointers and their Characteristics , Address and Indirection operators, Pointer Type Declaration and Assignment ,Pointer Arithmetic, Passing pointers to Functions, Arrays and Pointers, Array of Pointers, Pointers and Strings. Unit 5: The C Processor # define to Implement Constants, # define to create Functional Macros, Reading from Other Files Using # include, Conditional Selection of Code using # ifdef, Other Preprocessor Commands, Predefined Names Defined by Preprocessor, Macros Vs Functions, Files: File Handling in C Using File Pointers, Input and Output using file Pointers, Sequential Vs Random Access Files, Positioning the File Pointer, The Unbufferred I/O - The UNIX like File Routines.

I-Sem PGDCA MCS -012 F.M-80 Time-3hrs COMPUTER ORGANISATION AND ASSEMBLY LANGUAGE PROGRAMMING (CO&ALP) Unit 1: Introduction to Digital Circuits The Basic Computer, The von Neumann Architecture, Instruction Execution: An Example, Instruction Cycle, Computers: Then and Now The Data Representation: Data Representation, Number Systems, Decimal Representation in Computers, Alphanumeric Representation, Data Representation for Computation. Principles of Logic Circuits I: Logic Gates, Logic Circuits, Combinational Circuits Design of Combinational Circuits, Examples of Logic Combinational Circuits, Principles of Logic Circuits II : Sequential Circuits: The Definition, Flip Flops, Sequential Circuit Design, Examples of Sequential Circuits, Design of a sample Counter. Unit 2: Basic Computer Organization The Memory System: The Memory Hierarchy, RAM, ROM, DRAM, Flash Memory, Secondary Memory and Characteristics Hard Disk Drives, RAID and its Levels , The Concepts of High Speed Memories, Virtual Memory, The Memory System of Micro- Computer, The Input/Output System: Input/Output Devices or External or Peripheral Devices, the Input Output Interface, the Device Controllers and its Structure, Device Drivers, Input Output Techniques, Input Output Processors, External Communication Interfaces. Secondary Storage Techniques: Secondary Storage Systems, Hard Drives, Removable Drives, Removable Storage options. I/O Technology, Keyboard, Mouse, Video cards, Monitors, Liquid Crystal Displays (LCD), Digital Camera, Sound Cards, Printers, Modems, Scanners, Power Supply. Unit 3: The Central Processing Unit Instruction Set Architecture, Instruction Set characteristics, Instruction Set Design Considerations, Addressing Schemes, Instruction Set and Format Design Issues, Example of Instruction Format. Registers, Micro-Operations and Instruction Execution: Basic CPU Structure, Register Organization, General Registers in a Processors, Micro-operation Concepts, Instruction Execution and Micro-operations, Instruction Pipelining. ALU Organization: ALU Organization Unit 4: The Control Unit

The Control Unit, The Hardwired Control, Wilkes Control, The Micro-Programmed Control, The Micro-Instructions, The execution of MicroProgram. Reduced Instruction Set Computer Architecture, Introduction to RISC, RISC Architecture, the Use of Large Register File, Comments on RISC, RISC Pipelining. Assembly Language Programming: Microprocessor Architecture, Microcomputer Architecture, Structure of 8086 CPU, Registers Set of 8086, Instruction Set of 8086, Addressing Modes. Unit 5: Introduction to Assembly Language Programming The Need and Use of the Assembly Language, Assembly Program Execution, An Assembly Program and its Components, Input Output in Assembly Program, The Types of Assembly Programs, How to Write Good Assembly Programs. Assembly Language Programming (I), Simple Assembly Programs. Programming with Loops and Comparisons, Programming for Arithmetic and String Operations Assembly Language Programming (II), Use of Arrays in Assembly, Modular Programming, Interfacing Assembly Language Routines to High Level Language, Programs, Interrupts, Device Drivers in Assembly.

I-Sem PGDCA MCS -013

F.M-80

Time-3hrs

DISCRETE MATHEMATICS Unit-1: Elementary Logic Prepositional Calculus, Prepositions, Logical Connectives, Logical Equivalence, Logical Quantifiers. Unit 2: Methods of Proof, What is a Proof? Different Methods of Proof, Principle of Induction Unit 3: Boolean Algebra and Circuits: Boolean Algebras, Logic Circuits, Boolean Functions. Unit 4: Basic Combinatorics Sets, Relations and Functions, Introducing Sets, Operations on Sets, Relations and Functions. Unit 5: Combinatorics - An Introduction: Multiplication and Addition Principles, Permutations, Combinations, Binomial Coefficients, Combinatorial Probability

I-Sem PGDCA MCS -014 SYSTEMS ANALYSIS AND DESIGN :

F.M-80

Time-3hrs

Unit 1: Introduction to Systems Development Introduction to SAD, Fundamentals of System, Real Time Systems , Distributed Systems, Development of a successful System, Various Approaches for development of Information Systems Systems Analyst- A Profession, Why do Business need Systems Analyst?, Users, Analyst in Various Functional Areas, Role of a Systems Analyst, Duties of a Systems Analyst, Qualifications of a Systems Analyst. Process of System Development: Systems Development Life Cycle, Phases of SDLC, Product of SDLC Phases, Approaches to Development, Case Study Unit 2: Introduction to Documentation of Systems: Concepts and process of Documentation, Types of Documentation, Different Standard for Documentation, Documentation and Quality of Software, Good Practices for Documentation. Planning and Designing Systems: Process of System Planning, Fact Finding Techniques, Issues Involved in Feasibility Study, Cost Benefit Analysis, Preparing Schedule, Gathering Requirements of System. Unit 3: Modular and Structured Design: Design Principles, Structure Charts, Modularity System Design and Modeling, Logical and Physical design, Process Modeling, Data Modeling, Process Specification Tools, and Data Dictionary Unit 4: More Design Issues and CASE Tools: Forms and reports Design, Forms, Reports, Differences Between Forms and Reports, Process of Designing Forms and reports, Deliverables and Outcomes ,Design Specifications, Types of Information, General Formatting Guidelines, Guidelines for Displaying Contents, Criteria for Form Design, Criteria for Report Design. Physical File Design and Data base Design: Introduction to Database design, Design of Database Fields, Design of Physical Records, Design of Physical Files, Design of Database, and Case Study. CASE Tools for Systems Development: Use of CASE tools by Organizations, Components of CASE, and Visual and Emerging CASE tools. Unit 5: Implementation and Security of Systems & MIS Implementation and Maintenance of Systems, Implementation of Systems, Maintenance of Systems. Audit and Security of Computer Systems, Definition of Audit, Audit of Transactions on Computer, Computer Assisted Audit Techniques, Computer System and Security issues, Concurrent Audit Techniques. Management Information Systems: Role MIS in an organization, Different kinds of Information Systems.

I-Sem PGDCA MCS -015 COMMUNICATION SKILLS : F.M-80

Time-3hrs

Unit 1: Skills Needed at the Work Place - I The Process Communication, Introduction: What is Communication? The Process of Communication, Barriers to Communication, Different Types of Communication, Written Vs Oral Communication, Different Types of Face-to-Face Interactions, Characteristics and Conventions Of Conversations, Conversational Problems of Second/Foreign Language Users, Difference between Conversation and Other Speech Events. Telephone Techniques: Warm Up, Speaking and Listening: Commonly Used Phrases in Telephone Conversations, Reading: Conference calls, Vocabulary, Writing and Listening: Leaving a Message, Grammar and Usage: The Perfect Tenses, Pronunciation: Contracted Forms

Unit 2: Job Applications and Interviews, Warm Up, Reading, Vocabulary: Apply for a Job, Curriculum Vitae, Language Focus: Some Useful Words Study Skills: Preparing for an Interview, Listening, Speaking, Writing. Group Discussions: Reading, Writing Skills, Listening: How to be Successful in a Group Discussions Study Skills, Language Focus, Vocabulary, Speaking, Grammar: Connectives, Pronunciation. Unit 3: Managing Organizational Structure Warm Up: Ability to Influence and Lead, Reading: The Role of a Manager, Vocabulary: Leadership Speaking and Listening, Language Focus: Degree of Probability, Grammar: Modals, Writing: Reports Pronunciation. Meetings: Reading: A successful Meeting, Speaking: One to One Meetings, Language Focus: Opening, Middle, and Close, Study Skills: Editing, Listening: Criteria for Successful Meetings, Vocabulary, Grammar: Reporting Verbs, Writing Memos, Pronunciation: Stress According to Part of Speech. Unit 4: Taking Notes and Preparing Minutes: Taking Notes, Preparing Minutes, Grammar: Using the Passive Voice. Presentation Skills - I: Reading: Presentation Skills, Grammar: Verbs often required in Presentations Language Focus, Listening: Importance of Body Language in Presentations, Speaking: preparing an Outline of a Presentation, Pronunciation. Unit 5: Presentation Skills - II: Reading: Structure of Presentation, Study Skills: Visual Aids, Ending the Presentation, Language Focus: Talking about Increase and Decrease, Grammar: Prepositions, Listening: Podium Panic, Speaking, and Pronunciation: Emphasizing the Important words in Context. Negotiation Skills: Language Focus: Idiomatic Expressions, Study Skills: Process of Negotiations, Grammar: Phrasal Verbs, Listening: Effective Negotiations, Speaking, Writing.

I-Sem PGDCA MCSL -016 : F.M-100 Time-3hrs INTERNET CONCEPTS AND WEB DESIGN (Lab course) Scripting Languages Unit 1: The Internet, Classification of Networks, Networking Models, What is Packet Switching? Accessing the Internet, Internet Protocols, Internet Address, How does the Internet Work? Intranet and Extranet, Internet Infrastructure, Protocols and Services on Internet. Unit 2: Introduction to HTML, What is HTML? Basic Tags of HTML, Formatting of Text, Working with Images META Tag Unit 3: Advanced Html: Links, Lists, Tables, Frames, Forms, Some Special Tags. Unit 4: Introduction to Java Script: Java Script Variables and Data Types, Statements and Operators, Control Structures, Object-Based Programming, Message box in Java script, Java Script with HTML, Forms. Unit 5: VB Script: What is VB Script? Adding VB Script Code to an HTML Page, Using Conditional Statements Looping Through Code, VB Script Procedures, VB Script Coding Conventions, Dictionary Object in VB Script, Err Object. Unit 6: Dream Weaver: Using Dream Weaver, Create a Site Home Page, Design a Page in Layout View, Insert Messages, Insert text, Work in Standard View, View the Site Files, Link Your Documents. Lab Manual Section 1: HTML (Hypertext Markup Language) Basic of HTML, How to Create HTML Document, Steps for Creating a Simple HTML Program. Section 2: Advanced HTML Advanced Topics of HTML. Section 3: Java Script Script Basics, Incorporating Java Script into a Web Page. Section 4: B Script VB Script Basics Incorporating VB Script into HTML Page. Section 5: Dream Weaver, How to Work In Dream Weaver? How to save your File? Adding Layers to the Timeline and Giving Motion to the Layer. Inserting Scripts, Inserting External Media in the web Page Adding SSI (Server-side Include to the Page), Adding CSS Style to your Page, Adding XML Files to your Page To Export a Dream Weaver Document as XML File, checking entries, working in frames, windows control, the java script URL.

I-Sem PGDCA MCSL -017 F.M-100 Time-3hrs LAB (C AND ASSEMBLY LANGUAGE PROGRAMMING) (Lab Course) Section 1: C programming Lab Salient Features of C, C Programming Using Borland Compiler, Using C with UNIX Running C Programs using MS Visual C++, Program Development Life Cycle List of Lab Assignments - Session wise. Section 2: Digital Logic Circuits Logic Gates Circuits Simulation Program, Making logic Circuit Using Logic a Revisit of Steps of Logic Circuit Design Session-Wise Problems. Section 3: Assembly Language Programming Assemblers Assembly Programming File Session-wise List of Programs.

I-Sem PGDCA CS-60 FOUNDATION COURSE IN MATHEMATICS IN COMPUTING F.M-80 UNIT-1: Elements of Differential Calculus:

Time-3hrs

Real Numbers and Functions, Limits and Continuity, Differentiation Derivatives of Trigonometric, Derivatives of Some Standard Functions. UNIT-2: Drawing Curves Higher Order Derivatives, the Ups And Downs, Geometrical Properties of Curves Curve Tracing UNIT-3: Integral Calculus Definite Integral, Methods of Integration, Reduction Formulas Integration of Rational and Irrational Functions UNIT-4: Application of Calculus Applications of Differential Calculus, Area under a Curve Further Application of Integral Calculus UNIT-5: Solutions of Polynomial Equations Sets, Complex Numbers, System of Linear Equations, Cramer’s Rule, Inequalities Preliminaries in Plane Geometry, The Standard Conics, Preliminaries in Three-Dimensional, the Sphere.

2nd SEM PGDCA

MCS -021 DATA AND FILE STRUCTURES F.M-80 Time-3hrs UNIT 1: Introduction to Algorithms and data Structures Analysis of Algorithms: Mathematical Background, Process of Analysis, Calculation of Storage Complexity, Calculation of Run Time Complexity. Arrays: Arrays and Pointers, Sparse Matrices, Polynomials, Representation of Arrays, Applications. Lists: Abstract Data Type-List, Array Implementation of Lists, Linked Lists-Implementation, Doubly Linked Lists-Implementation, Circularly Linked Lists-Implementation, Applications. UNIT 2: Stacks, Queues and trees Stacks: Abstract Data Type-Stack, Implementation of Stack, Algorithmic Implementation of Multiple Stacks, Applications Queues: Abstract Data Type-Queue, Implementation of Queue, Implementation of Multiple Queues, Implementation of DEQUEUES. UNIT 3: Trees: Abstract Data Type-Tree, Implementation of Tree, Tree Traversals, Binary Trees, Implementation of Binary Trees, Binary Tree Traversals, Application Graph Algorithms and Searching Techniques. Advanced Trees: Binary Search Trees, AVL Trees and B-Trees. UNIT 4: Graphs: Definitions, Shortest Path Algorithms, Minimum cost Spanning Trees, Breadth First Search, Depth First Search, Finding Strongly Connected Components. Searching: Linear Search, Binary Search, Applications. UNIT 5: File Structures and Advanced Data Structures Sorting, Internal Sorting, Sorting on Several Keys, Advanced Data Structures, Splay Trees, Red-Black Trees, AA-Trees File Structures, Terminology, File Organization, Sequential Files, Direct File Organization, Indexed Sequential File Organization.

II-Sem PGDCA MCS -022 F.M -80 Time-3hrs OPERATING SYSTEM CONCEPTS AND NETWORKING MANAGEMENT UNIT 1: Operating System Fundamentals Networking Graphical User Interface, What is Graphical User Interface? Evolution of Human and Machine Interaction, Common Graphical User Interface, GUI Design Consideration: Psychological factors, GUI Design Consideration: Standards, GUI Example. Introduction to Operating System: What is an Operating System? Evolution of Operating System, Operating System Structure, and Classification of Advanced Operating System, Characteristics of Modern Operating System. UNIT-2: Introduction to Networking Concepts: Why computer Networks? The Topologies, Characteristics of the OSI Layers, OSI Models and Communication between Systems, Interaction between OSI Model Layers, Protocols Types of Networks, Medium, Data Flow, Physical Connection , Transmission Media, Connecting Devices. Internetworking: Concept, Architecture and Protocols: History of Internetworking, Packet Switching, Internetworking Concepts, and Internet Address Object -Based Programming, Configuring IP Address, TCP/IP, Additional Layer Protocols World Wide Web, Domain Name System, SNMP and UDP. UNIT 3: Linux Operating System Introduction to Linux Operating System: Features of Linux, Drawbacks of Linux, Components of Linux. Linux Commands and Utilities: Entering the Machine, The File System, Linux Utilities and Editor: Some Useful Commands, Permission Modes and Standard Files. Pipes, Filters and Redirection, Shell Scripts, Graphical User Interface, Editor. UNIT 4: User-to-User Communication: On-Line Communication, Off-Line Communication, Apache Server Settings, And Network Server Settings UNIX System Administration: System Administration, Installing Linux, Booting the System, Maintaining User Accounts, File Systems and Special Files, Backups and Restoration Windows 2000 Windows 2000 Networking: Windows 2000 Operating System Architecture, Using the Mapped Drive, A Few Important Facts about Windows 2000 Usages. UNIT 5: Managing Windows 2000 Server: Using Windows 2000 and Client, Logging on to the Network, Browsing Network Resources 1, Accessing Network Resources using My Network Places, Mapping a Folder Advanced Windows 2000 Networking, Windows 2000 Domain, Workgroups & Trusted relationships, User Administration, Remote Access. Windows XP Networking: Introduction to Windows XP Networking, Windows XP in File System, Sharing Network Resources in Windows XP, Enabling Offline File Features.

II-Sem PGDCA

MCS -023 INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS F.M-80

Time-3hrs

UNIT 1: The Database Management System Concepts The Basic Concepts: Need for a Database Management System, the Logical DBMS Architecture, Physical DBMS Architecture, Commercial Database Architecture, Data Models Relational and ER Models, The Relational Model, Relational Constraints, Relational Algebra, Entity Relationship (ER) Model, E-R Diagram, Conversion of E-R Diagram to Relational database.

UNIT 2: Database Integrity and Normalization Relational Database Integrity, Redundancy and Associated Problems, Single-Valued Dependencies, Single-Valued Normalization, Desirable Properties of Decomposition, Rules of Data Normalization File Organization in DBMS: Physical Database Design issues, Storage of Database on Hard Disks, File Organization and its Types, Types of Indexes, Index and Tree Structure, Multi-Key File Organization, Importance of File Organization in Databases. UNIT 3: Structured Query Language and Transaction Management The Structures Query Language, What is SQL? Data Definition Language, Data Manipulation Language, Data Control, Database Objects: Views, Sequences, Indexes and Synonyms, Table Handling, Nested Queries. UNIT-4: Transaction & Deadlock: Transactions and Concurrency Management: The Transactions, the Concurrent Transactions, the Locking Protocol, Deadlock and its Prevention, Optimistic Concurrency Control. UNIT 5: Database Recovery and Security: What is Recovery? Recovery Techniques, Security and Integrity, Authorization Distributed and Client Server Databases, Need for Distributed Database Systems, Structure of Distributed Database, Advantages and Disadvantages of DDBMS, Design of Distributed Database, Client Server Databases.

II-Sem PGDCA MCS -024 F.M-80 Time-3hrs OBJECT ORIENTED TECHNOLOGY AND JAVA PROGRAMMING UNIT 1: Object Oriented Technology and Java Object Oriented Methodology - 1: Paradigms of Programming Languages, Evolution of OO Methodology , Basic Concepts of OO Approach, Comparison of Object Oriented and Procedure Oriented Approaches, Benefits of OOPs Object Oriented Methodology - 2, Classes and Objects, Abstraction and Encapsulation, Inheritance, Method Overriding and Polymorphism. UNIT 2: Java Language Basics: Introduction to Java, Primitive Data Type and Variables, Java operators Expressions, Statements and Arrays, Expressions, Statements, Control Statements, Selection Statements Iterative Statements, Jump Statements, Arrays . UNIT 3: Object Oriented Concepts and Exceptions Handling Class and Object , Class Fundamentals, Introducing Methods, This Keyword, Using Objects as Parameters , Method Overloading , Garbage Collection, The Finalize ( ) Method Inheritance and Polymorphism: Inheritance Basics, Access Control, Multilevel Inheritance, Method Overriding, Abstract classes, Polymorphism, Final Keyword Packages and Inheritances: Package, Accessibility of Packages, Using Package Members, Interfaces, Implementing Interfaces, Interface and Abstract Classes, Extends and Implements Together. UNIT 4: Exception Handling, Exception, Handling of Exception, Types of Exceptions, Throwing Exceptions, Writing Exception Subclasses. Multithreading, I/O and String Handling: Multithreaded Programming, Multithreading: An Introduction, The Main Thread, Java Thread Model, Thread Priorities, Synchronization in Java, Inter threads Communication I/O in Java, I/O Basics, Streams and Stream Classes, The Predefined Streams, Reading from, and Writing to , Console, Reading and Writing Files, The Transient and Volatile Modifiers, Using Instance of Native Methods Strings and Characters, Fundamentals of Characters and Strings, The String class, String operations Data Conversion using Value of ( ) Methods, String Buffer Class and Methods. UNIT 5: Exploring Java I/O, Java I/O Classes and Interfaces, I/O Stream Classes, Text Streams Stream Tokenizer, Serialization, Buffered Stream, Print Stream, Random Access File, User Interface Components, Building User Interface with AWT, Swing-Based GUI, Layouts and Layout Manager, Container Networking Features, Socket Overview, Reserved Parts and Proxy servers, Internet Addressing: Domain Naming Services (DNS), JAVA and the net: URL, TCP/IP Sockets Datagram’s , Advance Java, Java Database Connectivity An Overview of RMI Applications, Java Servlets, Java Beans.

II-Sem PGDCA MCSL -025 LABS (DATA STRUCTURE USING C, WINDOWS 2000, LINUX/UNIX, JAVA AND MSACCESS, MY SQL) F.M-100

Time-3hrs

Section 1: Data and File Structures Lab Manual Arrays · Structures · Linked Lists · Stacks · Queues · Trees · Advanced Trees · Graphs · Searching · Sorting Section 2: Operating System and Networking Lab · Overview of Windows 2000 · UNIX and Linux · Advanced concepts of Local Area Network · Network Administration of Windows 2000 · Linux Administration · Unix Networking · Installation and Configuration of the Networking Services like TCP/IP, DNS, DHCP, FTP, SMTP. Section 3: DBMS Lab · Introduction to MS- Access · Database Creation · Use of DBMS Tools/Client-Server Mode · Forms and Procedures. Section 4: Java Programming lab