2023 2024 Student Forum > Management Forum > Main Forum

 
  #2  
16th July 2015, 11:37 AM
Super Moderator
 
Join Date: Apr 2013
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.
Attached Files
File Type: pdf PGDCA syllabus.pdf (279.5 KB, 212 views)


Quick Reply
Your Username: Click here to log in

Message:
Options

Thread Tools Search this Thread



All times are GMT +5. The time now is 07:05 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
SEO by vBSEO 3.6.0 PL2

1 2 3 4