#1
16th July 2015, 08:01 AM
| |||
| |||
Veer Narmad South Gujarat University PGDCA
Will you please provide here syllabus for Post Graduate Diploma in Computer Application (PGDCA ) course of Veer Narmad South Gujarat University?
|
#2
16th July 2015, 11:37 AM
| |||
| |||
Re: Veer Narmad South Gujarat University PGDCA
As you want I am here providing you syllabus for Post Graduate Diploma in Computer Application (PGDCA ) course of Veer Narmad South Gujarat University. Syllabus : Paper 1 : COMPUTER ORGANIZATION & FUNDAMENTALS OF OPERATING SYSTEMS: 1. Memory, Number System & Basic Computer Architecture 1.1. RAM, ROM, PROM, EPROM etc, Virtual Memory, Cache Memory 1.2. Secondary Storage Devices 1.3. Binary, Hexadecimal, Octal Number System 1.4. Integer & Floating Point representation 1.5. Block Diagram of CPU and execution process 1.6. Introduction to bus architecture 1.7. H/W parts of PC 1.8. I/O devices: keyboard, display, pointing devices, modem, scanners, OMR, OCR, CD- ROM, DVD, printers. 2. Operating System Concepts 2.1. Evolution of Operating System & History 2.2. Need of an Operating System 2.3. Single-User & Multi-User Operating System 2.4. Elements of an Operating System 3. Single User Operating System 3.1. BIOS, POST Operation, Vector Table, Device Drivers, TSR Programs 3.2. System Files 3.3. Configuration Files 3.4. Disk Architecture 3.5. Commands 3.6. Introduction to Windows 4. Multi-user Operating System 4.1. Introduction to Windows-NT, UNIX 4.2. LAN Fundamentals 4.3. Basic Commands of NETWARE, Windows-NT, UNIX PGDCA syllabus 1. Basic Concepts of Database Management System. 1.1 Fundamental concepts of File and databases 1.2 Purpose of database system 1.3 Introduction to Data models 1.3.1 Conceptual Data model – E- R model 1.3.2 Record – base Data models – Hierarchical. Relation , Network 2. Features of Database Systems 2.1 Data abstraction & Data independence 2.2 Type of Database Languages : DDL, DML,TCL 2.3 Database users : Database manager, administrator and Users 2.4 Overall system structure. 3. Relational Commercial Language - SQL 5. Commercial DBMS : Microsoft Access / DB2 5.1 Basic Architecture as DBMS 5.2 Working with databases and tables. 5.3 Managing constrains and relationships. 5.4 Using SQL queries. 5.5 Introduction to other object : Forms , Reports, Macros, etc. 6. Integrity Constrains 6.1 Domain Constrains , key Constrains, Referential Integrity Constrains 6.2 Functional Dependencies 7. Relational Database Design 7.1 Pitfalls in relational database design 7.2 Normalization using Functional Dependencies 7.3 Normalization using Multi valued Dependencies 7.4 Normalization using Join Dependencies 7.5 Domain – Key normal form 8. [Self Study] Security features provided by access / DB2 Reference Books 1. Database System Concepts – SILBERSCHATZ , KORTH, SUDARSHAN- McGraw- Hill 2. An introduction to Database Systems- C.J.DATE – Addison Wesley 3. Database System : A practical approach to design implementation and management – THOMAS CONNOLLY , CAROLYN BEGG, Pearson Education 4. Access - The Complete Reference – Virginia Andersen – McGraw - Hill 5. Access Database Design & Programming – Steven Roman - O' Reilly 6. Microsoft Access : Bible – Cary N. Prague (1st SEMESTER) SYLLABUS Paper Title : COMPUTER PROGRAMMING & PROGRAMMING METHODOLOGY 1. Algorithm & Flowcharting 2. Constants & Variables 2.1. Character Set 2.2. Constants - needs & definition 2.3. Variables - needs & definition 2.4. Storage Class 2.5. Scope of Variables 3. Expressions & Operations 3.1. Operators: Assignment, Arithmetic, Increment, Decrement, Relational, Logical, Bitwise, Conditional 3.2. Expression 3.3. Evaluation & Assignment of Expression 4. Basic Input & Output Functions 5. Jumping, Branching & Looping Statements 6. Array 7. Built-in Functions: Arithmetic functions, Data Conversion functions, String functions, Character Classification functions 8. Structure Union & Enumerated data types 9. User Defined Functions 9.1. Call by value 9.2. Passing Structures & Array 9.3. Recursion 10. Pointers 11. Program Bugs & Testing 11.1. Program Bugs 11.2. Preparing Test data 11.3. Functional & Structural Testing Reference Books: 1. C Language Programming - Byron Gottfried - TMH 2. Programming ANSI C – E Balagurusamy – 3. Let US 'C' – Yashwant Kanitkar 4. Pointers in C – Yashwant Kanitkar 5. C Programming Language - Karnighan & Ritchie – TMH 6. 'C' Odyssey (6 Volumes) - Vijay Mukhi - PHI 7. The Complete Reference - C - Herbert Schildt, Tata Mc Graw Hill 8. Structured programming concepts - La Budde - (Mc.Graw HIll) 9. Programming in 'C' - Stephan Kochan - CBS 10. Mastering Turbo C - Kelly & Bootle - BPB 11. Mastering Turbo C - Stan Kelly - BPB (1st SEMESTER) SYLLABUS Paper Title : COMPUTER NETWORKS 1. Networking Fundamentals An Introduction to Networks, Network Topologies and Types What is Networking? Exchange, Sharing, preserving and protecting Information Sharing Hardware and Software Resources Need, Uses and Advantages of Network Networks in the workplace (Tools, Tasks and Personnel) Clients, Servers and Peers based and Hybrid Networks Server types Network Topologies (Bus, Star, Ring, Star Bus, Star Ring and Physical Mesh) Network ( Transmission) Media (Wires, Cables, Fibre Optics, Wave) Defining Network Protocols (H/W Protocols, S/W Protocols, H/W – S/W Interface) The OSI Model Major Protocol Suites Review of Protocols, Models and Implementations NetWare IPX/SPX Protocols(Lower, Middle and Upper Layer Protocols) Internet Protocols(Middle and Upper Layer Protocols) Basics of Miscellaneous Protocols(SLIP, PPP, FDDI, X.25, Frame Relay, ISDN, B-ISDN, SONET, SDH, ATM, SMRS) 2. Network H/W And S/W Cards and Cables, Repeaters, Hubs, Routers, and Bridges Network Cards Repeaters – its uses and selection criteria Hubs (Chassis Hubs and Stackable Hubs) Splitting Up Networks Bridges (The Spanning Tree Protocol, Traffic Segmentation and Monitoring with examples) Switches (Full Duplex Operation, Various Switching Modes, Avoiding Switch overload, VLAN technology, Applicability) Routers (Protocols, A Routed Network Example, Protocol Specificity, Bridging and Routing compared, Protocol Address Conventions) Switch Routers Network Operating Systems Peer Network Operating Systems ( Windows 95-98-NT workstation) Client-Server Operating System( Common Features, Windows NT-2000, Novell Netware, Various Flavours of Unix) Client Software (DOS Clients, Windows Clients, Macintosh Clients) Novell Netware fundamentals File system (volumes), Directories, files & flags(i.e. attributes) of the File. Administrative command: Creating users & groups, assigning trustee directories & attributes, Login script, Security 3. Network Management And Security Understanding IEEE Standards Understanding Wireless Networks Reference Books: 1. Data Communication and Networking – B. Forouzon –MC Graw Hill 2. Networking Complete- 1st Edition 2002, BPB Publication (Text Book) 3. Computer Networks By- TenenBaum- PHI Publication 4. Mastering Local Area Networks By Christa Anderson & Mark Minasi – BPB Publication 5. Mastering Novell Netware-Currid C.C, C.A Gillett-BPB 6. MCSE: Networking Essentials Study Guide- Tata McGraw Hill Publication 7. Introduction to Local Area Networks Address: Veer Narmad South Gujarat University Udhana - Magdalla Rd, Someshwar Char Rasta, Near University College, Choryasi Ta Surat, Gujarat 395007 MAP: [MAP]Veer Narmad South Gujarat University[/MAP] Here is the attachment. |