Course Structure of Three Year Degree B.A Programme in Computer Application under Semester System of Dibrugarh University (General Programme)

(1)

Course Structure of Three Year Degree B.A Programme in Computer Application under Semester System of Dibrugarh University

(General Programme)

COURSE LECTURE DURATION(LD)

70 hours/paper

MARKS SEMESTER-I

1. Course Code:CAN101

Subject: Computer Fundamentals Internal Assessment

70 hours

80

20 SEMESTER-II

1. Course Code:CAN201

Subject: System Analysis and Design

Internal Assessment

70 hours

80 20 SEMESTER-III

1. Course Code: CAN 301 Subject: Internet Technology Internal Assessment

2. Course Code: CAN 302 (Practical) Subject: HTML, Javascript Internal Assessment

70 hours

80 20 80 20 SEMESTER-IV

1. Course Code: CAN 401

Subject: Database Management Systems

2. Course Code: CAN 402 (Practical) Subject: Database Management Systems Practical

70 hours

80 20

80

20 SEMESTER-V

1. Course Code: CAN 501

Subject: Introduction to Linux OS Internal Assessment

2. Course Code: CAN 502(Practical) Subject: Shell programming Internal Assessment

70 hours

80

20 80 20 SEMESTER-VI

1. Course Code: CAN 601 Subject: Visual Programming Internal Assessment

2. Course Code: CAN 602 (Practical) Subject: Visual Basic

Programming Internal Assessment

70 hours

80

20 80 20

* CAN = Computer Application Non Major Course.

(2)

Computer Fundamentals

Course code:CAN101 LD-70

Marks 80

Unit 1: Introduction to computers

Evolution of computers, Classification of computers, capabilities and limitations, types of computers, Applications of computers, Block diagram.

Marks: 10 Unit 2: Computer organisation and Architecture:

Basic components of computer system, Internal Communication Input devices and its various types, output devices and its various types, storage devices, Memory

hierarchy and representation. Marks: 15

Unit III : Computer Codes and Binary Arithmetic

Decimal system, Binary system, Octal system, Hexadecimal system, BCD and Unicode systems, Conversion of numbers, Binary addition, subtraction, multiplication, division, complements of binary numbers, signed/unsigned numbers

Marks: 15 Unit IV : Boolean Algebra, Logic gates and Digital Circuits

Elements and postulates of Boolean algebra, Boolean operations, Principle of duality, Laws of Boolean algebra, Demorgan’s Theorem, Logic gates, Conversion of Boolean functions, Adder circuits, Flip flops. Marks: 15

Unit V: Computer Software

Need of software, types of software, system software and application software, programming languages, machine, assembly, high level, 4GL, their merits and demerits, DBMS, Operating systems, OS functions and types Marks: 15 Unit VI: Data Communication and Networks

Computer networks, Network topologies, Network protocols, Internet history and applications, WWW, web browsers, Search engines Marks: 10

Books :

1) Fundamentals of Computers – E Balaguruswamy

(3)

System Analysis and Design

Marks 80

Unit I: System Concepts

System and its parts, System concepts, Organizations, managers and information, Computer based information systems, SDLC, System Documentation, Life cycle models, Roles and skills of System Analysts.

Marks: 15 Unit II: Automated tools for System Development

Use of CASE in organizations, components of CASE, Marks: 5 Unit III: Feasibility study & Requirements

Project feasibility, Report, Requirements determination, methods for

requirements determination. Marks: 10

Unit IV: Modeling

Process Modeling, DFDs and its types, Logic Modeling using Decision Trees, Structured English, Decision Tables, Conceptual data Modeling, Information

gathering, E-R Model. Marks: 10

Unit V: Designing

Designing Forms, Reports, Interfaces and Dialogues, Database Design, Relational database model, Job Design, Process Design, Input /Output Specification

& Design.

Marks: 10 Unit VI: System Development

Systems development, Application testing, Hardware requirements and selection.

Marks: 10 Unit VII: Implementation

System implementation, Installation, Documentation, Training users, organizational issues, Project Closedown. Marks: 10

Unit VIII: Maintenance Review

Maintaining Information Systems, Conducting System Maintenance, Systems

Audit, System Audit Report. Marks: 10

Books :- Structured System Analysis and Design by J.B. Dixit, Raj Kumar

(4)

Internet Technology

Marks 80

Unit -1: Marks 20

Internet basics, Types of connectivity, Network topologies, Concept of IP address, Domain names, e-mail protocols, Concept of telnet and FTP, Web publication.

Unit-2: HTML programming. Marks 20

Unit-3 Javascript-datatypes, variables, function, object, array. Client-side object hierarchy and document. object Model,<script>,event handlers, javascript in urls.

Windows and frames-dialog boxes, status line, navigator object, opening Windows, closing windows, Location object, history object.- Date object- math object-

Accessing

form object. Marks 20

Unit-4

Client-server model, introduction to cgi, environment variables, request-

response model, encoding and decoding form data. Simple programming in CGI- database. Marks 20

Books: 1. HTML-Definitive Guide O’reilley 2. Javascript-Definitive Guide O’reilley

Practical Internet Technology

Marks 80

HTML, JAVA SCRIPT

(5)

Database Management System

Marks 80

Unit I : Introduction

DBMS, its advantages and disadvantages, characteristics, functions, components, Data dictionary, DBA, Database languages, Database architecture, Schemas, Constraints

Marks - 15 Unit II: Database Models

Hierarchical model, Network model, Object oriented model, Relational model, E-R model, E-R diagrams, Entities, Attributes, Relationships, Transforming E-R

Models to relations Marks - 20

Unit III: Functional Dependency and Normalization

Functional dependencies, Normalization, Keys, Denormalization.

Marks:20

Unit IV: Database Security & Backup

Data security risks, requirements, Database users, Privileges, Database backup, causes of failures, Transaction logs, Checkpoints, Recovery techniques, 2PC

Marks - 15 Unit V: Introduction to Modern Databases

Distributed databases, Object oriented databases, Object relational databases, Multidimensional databases, Parallel databases, Temporal databases, Spatial databases, Multimedia databases, Web databases. Marks - 10

Books:-

1) Fundamentals of Database Management Systems – Alexis Leon, Mathews Leon

DBMS Practical

Marks 80

SQL Commands

(6)

Introduction to Linux O.S.

Marks 80

Unit I

Features and benefits of Linux- basic concepts of multi user system-open

source, freedom-Linux-components of Linux, types of users in Linux, types of files.

Introduction-login, password, creating an account, shell and commands, logout,changing

password-files and directories-pathname-directory tree-currend working directory- referring home directory-cbeating new directories,copying files,moving files,deleting files and directories-types of shell-wild cards-hidden files- looking at files: cat, more-

online help:man. Marks:40

Unit II

Vi editor-different modes-command mode, insert mode, last line mode-

redirecting input/output-filter, pipes, file permissions, user, group, changing file permissions - mounting floppy,HDD, CDROM-file systems-structure of /etc/fstab- Bourne shell scripts: script execution-variables and parameters, if, for, case, while construct

Marks:40

Practical Linux O.S

Marks 80

Linux Commands and Shell Scripting.

(7)

Visual Programming

Marks 80

Unit 1 Marks-15

Visual Basic: What is Visual Basic , Structure of a VB Application,

Steps in developing Application, drawing the user interface and setting properties , setting properties of objects at design time and at runtime variables.

Unit-2 Marks-15

VB data types , variable declaration, VB operators and functions, Branching statements – if then , goto, Looping statements, VB Tools, arrays, control arrays.

Unit 3 Marks-15

Designing an application, using general sub procedures in applications,

creating a code Unit, adding menus to an application, note editor, assigning icons to forms, creating VB Executable files, error types.

Unit 4 Marks-20

Debugging VB programs, debugging strategies, sequential files, writing and reading text using sequential files. Random access files , writing and reading text using

random access files , graphics methods, using colors, mouse events, timer tools and delays, animation techniques. Database structure and terminology, ADO data controls

Unit 5 Marks-15

Connection strings, assigning tables, bound data tools, database management, customs controls, multiple form visual basic applications, VB multiple document interface (MDI), creating a help file, connection to the Database

Text Book

1. Visual Basic 6, G Cornell, Tata McGraw Hill

Visual Programming Practical

Marks 80

Visual Basic Programming, Connection to Database