Senior Year / Seventh Semester

Nature of Course: Theory (3 Hrs) + Lab (3 Hrs)

Course Synopsis: To study the concept of advanced database technique

Goal: To study the further advanced database technique beyond the fundamental database techniques which were covered in the sophomore year (fourth semester) B Sc CSIT course and thus to acquaint the students with some relatively advanced issues. At the end of the course, students should be able to: critically assess new developments in data technology. Interpret and explain the impact of emerging database standards. Evaluate the contribution of database theory to practical implementation of database management systems.

Course Contents:

Unit 1. The Relational Model Of Data and RDBMS Implementation Techniques (5Hrs)
Theoretical concepts, Relational model conformity and integrity, Advanced SQL programming, Query optimization, Concurrency control and Transaction management, Database performance tuning, Distributed relational systems and Data Replication, Security considerations

Unit 2. The Extended Entity Relationship Model and Object Model (6 hrs)
The ER model revisited, Motivation for complex data types, User defined abstract data types and structured types, Subclasses, Super Classes, Inheritance, Specialization and Generalization, Constraints and characteristics of specialization and generalization, Relationship types of degree higher than two.

Unit 3. Emerging Database Management System Technologies (18 hrs)
Object Oriented Database Concepts, Object Relational database concepts, Active database concepts, Temporal database concepts, Spatial database concepts, spatial database concepts and architecture, Deductive databases and Query processing, Mobile Databases, Geographic Information Systems.

Unit 4. New Database Applications and Environments(8 hrs)
Data Warehousing and Data Mining, Multimedia, Mobility, Multi Databases, Native XML databases (NXD), Internet.

Unit 5. Database Related Standards (8 hrs)
SQL standards, SQL 1999, SQL 2003, Object Data Management Group (ODMG) version 3.0 standard, Standards for interoperability and integration e.g. Web Services, SOAP, XML related specifications, e.g. XQuery, XPath.

Laboratory works: The course involves a mini project using any one of the popular Commercial Object-Oriented DBMS software such as Oracle, MS SQL Server etc, along with any MVC software development framework.

Reference Books:

  1. Elmasri and Navathe, Fundamentals of Database Systems, Pearson Education
  2. Raghu Ramakrishnan, Johannes Gehrke, Database Management Systems, McGraw-Hill
  3. Korth, Silberchatz, Sudarshan , Database System Concepts, McGraw-Hill
  4. Peter Rob and Coronel, Database Systems, Design, Implementation and Management, Thomson Learning.
  5. C. J. Date & Longman, Introduction to Database Systems, Pearson Education

Prerequisites: Be familiar with at least one OO programming language such as .Net or C++ or Java, Fundamentals of DBMS, SQL

Homework: Homework assignments can be given according to the course

Computer Usage: Windows or Linux based PC or workstation, Commercial OODBMS software package and MVC software development framework installed at the server.

Category Content: Science Aspects: 60% Design Aspects: 40%

Nature of Course: Theory (3 Hrs) + Lab (3 Hrs)

Course Synopsis: Study on internet protocols, client/server applications and web services. Designing and applications of internet and intranet system

Goal: This course deals on the practical application of internetworking technologies to private intranets for information management and public internets for electronic commerce students will learn theoretical details, strategies for designing sites, techniques for creating their technical infrastructures, methods for developing content, and techniques for site deployment and management.

Course Contents:

Unit 1. Introduction
1.1. History and Development of Internets and Intranets
1.2. IANA, RIR/NIR/LIR and ISPs for internet number management
1.3. Internet Domain and Domain Name System
1.4. Internet Access Overview
1.5. Internet Backbone Networks: Optical Backbone, Marine Cables, Teleports, Satellite and Terrestrial Links

Unit 2. Internet Protocol Overview
2.1. TCP/IP and the IP Layer overview
2.2. IPv4 and IPv6 Address Types and Formats
2.3. IPv4 and IPv6 Header Structure
2.4. Internet RFCs

Unit 3. Protocols and Client/Server Applications
3.1. Standard Protocols: SMTP, E-mail Message (RFC22), PGP, POP, IMAP, HTTP, FTP
3.2. N-Tiered Client/Server Architecture
3.3. Universal Internet Browsing
3.4. Multiprotocol Support

Unit 4. HTTP and the web Services
4.1. HTTP, Web Servers and Web Access
4.2. Universal naming with URLs
4.3. WWW Technology: HTML, DHTML, WML, XML
4.4. Tools: WYS/WYG Authoring Tools
4.5. Helper Applications: CGI, PERL, JAVA, JAVA SRIPTS, PHP, ASP, .NET Applications
4.6. Introduction to AJAX(Programming)
4.7. Browser as a rendering engine: text, HTML, gif and jpeg

Unit 5. Designing Internet Systems and Servers
5.1. Designing of Internet System Network Architecture
5.2. Choice of platforms
5.3. Server Concepts: WEB, Proxy, RADIUS, MAIL
5.4. Cookies
5.5. Load Balancing: Proxy Arrays
4.6. Server Setup and configuration Guidelines
4.7. Security System Administration Issues, Firewalls and Content Filtering

Unit 6. Internet and Intranet Systems Development
6.1. Introductions
6.2. Benefits and drawbacks of intranets
6.3. Protocols, Structure and Scope of Networks
6.4. Intranet Resource Assessments: Network Infrastructure, Clients and Server Resources
6.5. Intranet Implementation Guidelines
6.6. Content Design, Development, Publishing and Management
6.7. Intranet Design with Open source Tools: DRUPAL, JUMLA
6.8. Tunneling Protocols:VPN

Unit 7. Internet and Intranet Applications
7.1. General Application: Email, WWW, Gopher, Online Systems 7.2. Multimedia and Digital Video/Audio Broadcasting: Video/Audio Conferencing, Internet Relay Chat(IRC) 7.3. Broadband Communication, Policy, xDSL and Cable Internet 7.4. VoIP, GoIP and IP interconnection 7.5. Datacenters and Data warehousing, packet clearing house 7.6. Unified Messaging Systems 7.7. Fundamental of e-Commerce 7.8. Concept of Grid and Cloud Computing

Laboratory works: Laboratory should include features like packet capturing and analysis, design of internet/intranet system, proxy administration, firewall configuration and management, VPN, implementation of IRC, Content development with JUMLA/DRUPAL mentioned in the syllabus.

Reference Books:

  1. Computer Networks; Andrew S. Tanenbaum, Prentice Hall India limited, New Delhi, 2010.
  2. Internet and Intranet Engineering; Daniel Minoli, MGraw-Hill India Limited, New Delhi, 2009.
  3. Internetworking with TCP/IP; Comer, D.E and Stevens

Nature of Course: Theory (3 Hrs) + Lab (3 Hrs)

Course Synopsis: A study in Java techniques beyond the introductory course. Emphasis will include, GUI and event-driven programming, Database Connectivity, Socket Programming, Remote Method Invocation and Services and JSP Technology.

Goal: The purpose of this is to present the concept of GUI programming and JDBC, Socket programming and remote objects, JSP Technology. Since software components are best learned by implementation, each student will complete a project independently which will involve the design and implementation three software components.

Course Contents:

Unit 1. Programming in Java (8 Hrs)
1.1. Introduction to Java: Java Architecture, Advantages of Java, PATH and CLASS PATH variables, Compiling and Running Java Program
1.2. Class and Object: Creating Classes, Interfaces, Creating, Objects, Access Modifiers, Arrays, Packages, Inheritance
1.3. Exception Handling and Threading: Try, catch, Finally, Throws, Creating Multi treaded Programs, Thread Life Cycle
1.4. File IO: Byte Stream Classes(FileInputStream and FileOutputStream), Character Stream Classes(File Reader and File Writer), Random Access File Class

Unit 2. User Interface Components with Swing (10 Hrs)
2.1. Swing and MVC Design Patterns: Design Pattern, MVC Pattern, MVC Analysis of Swing Buttons
2.2. Layout Management: Border Layout, Grid Layout, Gridbag Layout, Group Layout, Using, No Layout managers, Custom Layout Managers
2.3. Text Input: Text Fields, Password Fields, Test Areas, Scroll Pane, Label and Labelling Components
2.4. Choice Components: Check Boxes, Radio Buttons, Borders, Combo Boxes, Slides
2.5. Menus: Menu Building, Keyboard Mnemonics and Accelerators, Enabling and Design menu Items, Toolbars, Tooltips
2.6. Dialog Boxes: Option Diaglogs, Creating Dialogs, Data Exchange, File Choosers, Colors Choosers
2.7. Components Organizers: Split Panes, Tabbed Panes, Desktop Panes and Internal Frames, Cascading and Tiling
2.8. Advance Swing Components: List, Trees, Tables, Progress Bars

Unit 3. Even Handling (3 Hrs)
3.1. Introduction: Standard Event Handling, Using Delegated Class, Using Action Commands, Listener Interfaces, Adapter Classes
3.2. Handling Events:Action Events, Key Events, Focus Events, Window Event, Mouse Event, Item Events

Unit 4. Database Connectivity (4 Hrs)
4.1. Design of JDBC: Driver Types, Typical uses of JDBC
4.2. JDBC Configuration: Database URLS, Driver JAR Files, Starting Database, Registering Driver Class, Connecting to the database
4.3. Executing SQL Statements: Managing Connections, Statements, Result Set, SQL Exceptions, Populating Database
4.4. Query Execution: Prepared Statements, Reading and writing LOBs, SQL Escapes, Multiple Results, Scrollable Result Sets, Updateable Result Sets, Row Sets and Cached Row Sets, Transactions

Unit 5. Network Programming (5 Hrs)
5.1 Network Basics: Transmission control Protocol(TCP), User Datagram Protocol(UDP), Ports, IP Address Network Classes in JDK
5.2 Working with URLS: Connecting to URLS, Reading Directly from URLS, Inet Address Class
5.3 Sockets: TCP Sockets, UDP Sockets, Serving Multiple Clients, Half Close, Interruptible Sockets, Sending Email

Unit 6. Java Beans (3 Hrs)
6.1. Introduction: Creating, Updating and Reading From JAR Files, Java Beans, Advantages of Java Beans, Class vs Beans, BDK and Bean Box
6.2. Java Bean: Creating a Java Bean, Creating a Bean Manifest File, Creating a Bean JAR File, Using a New Bean, Adding Controls to Beans, Giving a Bean Properties, Creating Bound Properties, Giving a Bean Methods, Giving a Bean an Icon

Unit 7. Servlets and Java Server Pages (8 Hrs)
7.1. Servlets: Introduction to Servlets, Life cycle of servlets, Java Servlets Development Kit, Creating, Compiling and running servlet, The servlet API(javax.servlet package), Reading the servlet Parameters, Reading Initialization parameter, The javax.servlet.http. Package, Handling HTTP Request and Response (GET/ POST Request), Using Cookies, Session Tracking
7.2. Java Server Pages: Advantage of JSP technology(Comparision with ASP/ Servlet), JSP Architecture, JSP Access Model, JSP Syntax Basic(Directions, Declaration, Expression, Scriplets, Comments), JSP Implicit Object, Object Scope, Synchronization Issue, Exception Handling, Session Management, Creating and Processing Forms.

Unit 8. RMI and CORBA (3 Hrs)
8.1. Remote Method Invocation: Introduction of RMI, Architecture of RMI, Remote Objects, Creating and Executing RMI Applications
8.2. CORBA: Introduction to CORBA, Architecture of CORBA, Functioning of CORBA Applications, CORBA Services

Laboratory works: Student should design at least two projects. Desktop Application(Address Book, Library system etc), Simple Networks Application(e.g. Chatting Application) or Simple Web Applications (online banking Application, online Music Application, etc).

Reference Books: Cay Horstmann and Grazy Cornell, Core Java Volume I-Fundamentals, Eighth Edition, Cay Horstmann and Grazy Cornell, Core Java Volume II-Fundamentals, Eighth Edition, Steven Holzner, Java 2 Programming-AWT, Swing, XML and Java Beans Black Book, Dreamtech Press, Pallvi Jain and Shadab Siddiqui, J2EE Professional Projects, Premier Press.

Prerequisites: Any One Course in Object Oriented Programming.

Nature of Course: Project

Course Synopsis: This course introduces students to the practical environment. Special foucus will be given in enabling students with the skills, pertaining to the analysis, design and development, installation, testing and servicing a corporate organization. The course has a practical approach to building real application.

Goal: To develop the skills associated with analysis design and development of meaning and efficient real world application.

Course Contents:

  • Problem Identification
  • Problem Specification
  • Analysis and Design
  • System Development
  • Installation and Testing
  • System Maintenance
The content of this course is divided into six different phases; the students will first involve themselves in identifying a problem that needs to be addressed. Such problem needs to be specified precisely and several solutions need to be prescribed out in which most viable will be selected. The selected proposed solution now has to be analyzed properly and design. This might involve the use of tools depending upon the nature of the problem and environment.

Evaluation Criteria of the Project Work: Internal Evaluation (At the mid of Project work by supervisor, HOD/coordinator) Final Evaluation with External (At the end of the project by external, Inter and Supervisor).

Mark Allocation: Supervisor: 60, Internal: 20, External: 20, Total: 100.

Prerequisites: Depending upon types of project.


Nature of Course: Theory (3 Hrs) + Lab (3 Hrs)

Course Synopsis: Advanced aspects of Information Retrieval and Search Engine.

Goal: To study advance aspects of information retrieval and working of search engine, encompassing the principle, researching results and commercial application of the current technologies.

Course Contents:

Unit 1. Introduction (2 Hrs)
Introduction, History of Information Retrieval, The retrieval process, Block diagram and architecture of IR system, Web search and IR, Areas and role of AI for IR

Unit 2. Basic IR Models (4 Hrs)
Introduction, Taxonomy of information retrival models, Document retrieval and ranking, A formal characterization of IR models, Boolean retrieval model, Vector-space retrieval model, probabilistic model, Text-similarity metrics: TF-IDF (term frequency/inverse document frequency) weighting and cosine similarity.

Unit 3. Basic Tokenizing, Indexing and Implementation of Vector-Space (4 Hrs)
Retrieval: Simple tokenizing, Word tokenizing, Text Normalization, Stop-word removal, word stemming (Porter Algorithm), case folding, Lemmatization, Inverted indices (Indexing architecture), Efficient processing with sparse vectors, Sentence segmentation and Decision Trees.

Unit 4. Experimental Evaluation of IR (4 Hrs)
Relevance and Retrieval, Performance metrics, Basic Measures of text retrieval (Recall, Precision and F-measure).

Unit 5. Query Operations and Languages (3 Hrs)
Relevance feedback and pseudo relevance feedback, Query expansion/reformulation (with a thesaurus or WordNet, Spelling correction like techniques), Query languages (Single-word Queries, Context Queries, Boolean Queries, Natural Language.)

Unit 6. Text Representation (3 Hrs)
Word statistics (Zipf’s law), Morphological analysis, Index term selection, using thesauri, Metadata, Text representation using markup languages(SGML, HTML, XML).

Unit 7. Search Engine (6 Hrs)
Search engines (working principle), Spidering(Structure of a spider, simple spidering algorithm, multithreaded spidering, Bot), Directed Spidering(Topic directed, Link directed), Crawlers(Basic crawler architecture), Link analysis(e.g. hubs and authorities, Page ranking, Google Page Rank), Shopping Agents.

Unit 8. Text Categorization and Clustering (8 Hrs)
Categorization algorithms (Rocchio; naïve Bayes; decision trees; and nearest neighbor), Clustering algorithms (agglomerative clustering; K-means; expectation maximization (EM)), Application to information filtering; organization

Unit 9. Recommender System (3 Hrs)
Personalization, Collaborative filtering recommendation, Content-based recommendation.

Unit 10. Information Extraction and Integration (3 Hrs)
Information extraction and application, Extraction data from text, Evaluating IE Accuracy, XML and information Extraction, Semantic web (purpose, Relation to Hypertext page), Collecting and integrating specialized information on the web.

Unit 11. Advanced IR Models with indexing and searching text (4 Hrs)
Probabilistic models, Generalized Vector Space Model, Latent Indexing (LSI), efficient string searching, Pattern matching.

Unit 12. Multimedia IR (3 Hrs)
Introduction, multimedia data support in commercial DBMs, Query languages, Trends and research issues.

Laboratory works: The laboratory should contain all the features mentioned in a course.

Reference Books: Modern Information Retrieval, Ricardo Baeza-Yates, Berthier Ribeiro-Neto, Information Retrieval; Data Structures & Algorithm: Bill Frakes.

Prerequisites: Server side programming language like PHP, JSP, ASP, .NET(Any One) and with good concept on any programming languages.

Category Content: Science Aspect: 20%, Design Aspect: 75%.

Nature of Course: Theory (3 Hrs) + Lab (3 Hrs)

Course Synopsis: DBA Roles, DB backup, restoration and recovery, Tuning of database.

Goal: The course covers about: principles of DBA Roles, DB backup, Restoration and recovery, Tuning of database and overall DB administration which could be for administrator in the future.

Course Contents:

Unit 1 (5 Hrs)
Introduction: DBMS architecture and data independence, DBA roles and responsibilities, SQL *PLUS Overview: SQL Plus Fundamentals, Producing more readable outputs, Accepting values at urn time, Using iSQL *Plus.

Unit 2 (5 Hrs)
Control and Redo Log Files: Managing the control files, Maintaining and monitoring redo log files.

Unit 3 (10 Hrs)
Managing Users and Security: Profiles, Managing users, managing privileges, managing roles, querying role information, Database Security and Auditing, Creating and managing DB’s tables, integration services.

Unit 4 (10 Hrs)
Backup and Recovery Overview, Database backup, restoration and recovery, defining a backup and recovery strategy, Testing the backup and recovery plan, parallel instance recovery, recovering from non-critical loses.

Unit 5 (5 Hrs)
Database corruption, automatic database management, automatic storage management, RMAN.

Unit 6. (10 Hrs)
Introduction to performance tuning: brief overview of tuning methodology, general tuning concept, AADM (Automatic Database Diagnostic Monitor) and SQL Tuning Advisor, Virtual Private Database: policy types, selective columns, column masking.

Laboratory works: Labs should cover all the chapters using Oracle/SQL-Server or any other database server tools.

Reference Books: C.J. Date, Database Systems, Addison Wesley, 2000 , Introduction to Database Administration, by O’reilly , ORACLE DBA handbooks.

Nature of Course: Theory (3 Hrs) + Lab (3 Hrs)

Course Synopsis: Provides the concept of network and system administration.

Goal: The class concentrates on the network and system administration and covers subjects ranging from initial installation of OS to day-to-day administrative tasks such as Network and Server Configurations, management of user accounts and disk space and even imparting the troubles-shooting skills future system administrators will need to cope with unexpected behavior.

Course Contents:

1. Networking Overview
1.1. History
1.2. Protocol Standards
1.3. Reference Model(OSI, TCP/IP)
1.4. Windows and Linux Networking Basics
1.5. Switching and Routing basics

2. Server Administration Basics
2.1. Server and Client Installation
2.2. Boot Process and Startup, Services: Xinetd/Inetd
2.3. Managing accounts: users, groups and other privileges
2.4. File Systems and Quota Management
2.5. Job Scheduling with cron, crontab, anacron and system log analysis
2.6. Process controlling and management
2.7. Online Server upgrade/update process
2.8. Administering Database Server (MYSQL)

3. Network Configuration Basics
3.1. IPv4 and IPv6 addressing
3.2. Network Interface Configuration
3.3. Diagnosing Network Startup Issues
3.4. Linus and Windows Firewall configuration
3.5. Network troubleshooting commands

4. Dynamic Host Configuration Protocol (DHCP)
4.1. DHCP Principle
4.2. DHCP Server Configuration
4.3. DHCP Options, Scope, Reservation and Relaying
4.4. DHCP Troubleshooting

5. Name Server and configuration
5.1. DNS principles and operations
5.2. Basic Name Server and Client Configuration
5.3. Caching Only name server
5.4. Primary and Slave Name Server
5.5. DNS Zone Transfers
5.6. DNS Dynamic Updates
5.7. DNS Delegation
5.8. DNS Server Security
5.9. Troubleshooting

6. Web and Proxy Server Configuration
6.1. HTTP Server Configuration Basics
6.2. Virtual Hosting
6.3. HTTP Caching
6.4. Proxy Caching Server Configuration
6.5. Proxy-Authentication Mechanisms
6.6. Troubleshooting

7. FTP, File and Print Server
7.1. General Samba Configuration
7.3. NFS and NFS Client Configuration
7.4. CUPS configuration basics
7.5. FTP Principles
7.6. Anonymous FTP Server
7.7. Troubleshooting

8. Mail Server basics
8.1. SMTP,POP and IMAP principles
8.2. SMTP Relaying Principles
8.3. Mail Domain Administration
8.4. Basic Mail Server Configuration (Send mail, Postfix, Email, Exim)
8.5. SPAM control and Filtering
8.6. Troubleshooting

9. Remote Administration and Management
9.1. Router Configuration
9.2. Webmin/usermin
9.3. Team Viewer
9.4. Telnet
9.5. SSH
9.6. SCP,Rsync

Laboratory works: All the features of this course.

Samples: 1. Server/Client Installation over VMware Environment.
2. Packet Analysis by using TCPDUMP and WIRESHARK.
3. Network Practice with Packet Tracer.
4. System Administration: User/Group management, File System Management.
5. Network Configuration: Start/Stop network Service, network interface configuration.
6. Firewall Configuration.
7. DNS and DHCP Configuration and Troubleshooting.
8. Web and Proxy Server Configuration and Troubleshooting.
9. Basic Mail Server Configuration and Troubleshooting.
10. SAMBA, NFS, CUPS and FTP configuration and Trou

Reference Books: The Practice of system and Network Administration, Second Edition Thomas A.Limoncelli, Christina J. Hogan, Strata R.Chalup , Advanced Linux Networking, Roderick W.Smith, Addisom-Wesley Professional (pearson Education), 2002 , Linux Network Administrator’s Guide, Tony Bautts, Terry Dawson, Gregor N.Purdy, O’Reilly, Third Edition, 2005.

Prerequisites: Computer Networking Course.

Nature of Course: Theory (3 Hrs) + Lab (3 Hrs)

Course Synopsis: Concept of Software project, software project management framework.

Goal: This course introduces the concepts of Software Project management framework, project evaluation, Software quality assurance and project management and its tools.

Course Contents:

Unit 1: Introduction to Software Project Management (SPM) (5 Hrs)
Software engineering problem and software product attributes, Definition of a Software Project(SP), SP Vs. other types of Projects activities covered by SPM, categorizing SPs, Project management cycle, SPM framework, types of project plan.

Unit 2: Project Organization, Scheduling and management issues (5 Hrs)
Project life cycle and product life cycle, project planning and scheduling resource allocation.

Unit 3: Project Evaluation & Estimation (6 Hrs)
Cost benefit analysis, cash flow forecasting, cost benefit evaluation techniques, risk evaluation, Selection of an appropriate project report; Choosing technologies, choice of process model, structured methods, rapid application development, water fall, V-process, spiral-model, Prototyping, delivery.

Unit 4: Activity Planning (7 Hrs)
Objectives of activity planning, project schedule, projects and activities, sequencing and scheduling activities, network model, representation of lagged activities, adding the time dimension, backward and forward pass, identifying critical path, activity throat, shortening project, precedence networks

Unit 5:Resource Allocation (4 Hrs)
Introduction, the nature of resources, identifying resource requirements, scheduling resources creating critical paths, counting the cost, being specific, publishing the resource schedule, cost schedules, the scheduling sequence.

Unit 6: Monitoring the Control (4 Hrs)
Introduction, creating the frame work, collecting the data, visualizing progress, cost monitoring, earned value, prioritizing monitoring, getting the project back to target, change control.

Unit 7: Managing contracts and people (5 Hrs)
Introduction, types of contract, stages, in contract, placement, typical terms of a contract, contract management, acceptance, managing people and organizing terms: Introduction, understanding behavior, organizational behavior: a back ground, selecting the right person for the job, instruction in the best methods, motivation, working in groups, becoming a team, decision making, leadership, organizational structures, conclusion, further exercises.

Unit 8: Software Quality Assurance and testing (5 Hrs)
Testing principles and objectives, test plan, types and levels of testing strategies, program verification and validation, software quality, SEI-CMM,SQA activities, QA organization structure, SQA paln.

Unit 9: Project management and project management tools (4 Hrs)
Software confirmation management, SCM tasks and roles, RISK management, risk management process, SPM tools.

Laboratory works: Project on Software Project Management.

Reference Books: Software project management-Rajiv Chopra,2009 , Software project management by Bob Hughes and Mike Cotterell, Latest Publication , Software Engineering- A Practitioner’s approach, Roger S.Pressman Latest Publication , Software Project Management, Walker Royee, 1998, Addison Wesley , Managing Global Software Projects, Ramesh, 2001, TMH.

Senior Year / Eighth Semester

Nature of Course: Theory (3 Hrs) + Lab (3 Hrs)

Course Synopsis: Analysis of Advanced aspects of data warehousing and data mining

Goal: This course introduces advanced aspects of data warehousing and data mining, encompassing the principles, research results and commercial application of the current technologies

Course Contents:

Unit 1. (5Hrs)
Concepts of Data Warehouse and Data Mining including its functionalities, stages of Knowledge discovery in database(KDD), Setting up a KDD environment, Issues in Data Warehouse and Data Mining, Application of Data Warehouse and Data Mining.

Unit 2. (4Hrs)
DBMS vs. Data Warehouse, Data marts, Metadata, Multidimensional data model, Data Cubes, Schemes for Multidimensional Database: Stars, Snowflakes and Fact Constellations.

Unit 3. (6Hrs)
Data Warehouse, Architecture, Distributed and Virtual Data Warehouse, Data Warehouse Manager, OLTP, OLAP,MOLAP, HOLAP, types of OLAP, servers

Unit 4. (4Hrs)
Computation of Data Cubes, modeling: OLAP data, OLAP queries, Data Warehouse back end tools, tuning and testing of Data Warehouse.

Unit 5. (4Hrs)
Data Mining Definition and Task, KDD versus Data Mining Techniques, tools and application

Unit 5. (4Hrs)
Data Mining Definition and Task, KDD versus Data Mining Techniques, tools and application

Unit 6. (5Hrs)
Data mining query language, data specification, specifying knowledge, hierarchy specification, pattern presentation & visualization specification, data mining language and standardization of data mining

Unit 8. (7Hrs)
Classification and Prediction: Issues Regarding Classification and Prediction, Classification by Decision Tree Induction, Intoduction to Regression, Types of regression, Introduction to clustering K-mean and K-Mediod Algorithms.

Laboratory Works: Cover all the concept of datawarehouse and mining mention in a course


  1. Creating a simple data warehouse
  2. OLAP operations: Roll Up, Drill Down, Slice, Dice through SQL- Server
  3. Concepts of data cleaning and preparing for operation
  4. Association rule mining though data mining tools
  5. Data Classification through data mining tools
  6. Clustering through data mining tools
  7. Data visualization through data mining tools

Reference Books:

  1. Data Mining Concepts and Techniques, Morgan Kaufmann J. Han, M Kamber Second Edition ISBN: 978-1-55860-901-3.
  2. Data Warehousing in the Real World – Sam Anahory and Dennis Murray, Pearson Edition Asia.
  3. Data Mining Techniques – Arun K Pujari, University Press.
  4. Data Mining- Pieter Adriaans, DolfZantinge.
  5. Data Mining, Alex Berson,StephenSmith,KorthTheorling,TMH.
  6. Data Mining, Adriaans, Addison-Wesley Longman.

Nature of Course: Internship [6 Credits]

Full Marks: 200

Course Synopsis: The student are required to complete a six credit (minimum ten weeks/180 hours long) internship as a part of the course requirement. Industry is a crucial requirement of the Internship course and this will have to be secured before getting started with the course. The work that the students perform during the Internship will have to be supervised by the faculty members as well as by representatives from the participating Industries. The internship experience is expected to enable the students to assist in the resolution of complex problem associated with Database systems.
At the end if the Internship, the students are required to write a report on their internship work. Such a report needs to be structured according to the prescribed format. The report forms a major aspect of the evaluation of the Internship work.Goal: Main goal is to assist students in focusing their interests, thus aiding in their professional career. It gives students the opportunity to re-examine their career objectives and explore the variety of opportunities in the field of computing.

Goal: Main goal is to assist students in focusing their interests, thus aiding in their professional carrier. It gives students the opportunity to re-examine their career objectives and explore the variety of opportunities in the field of computer networking.

Preparation: Students, the advisors and the industry/organization, with the student team is affiliated will have to agree on a problem that needs to be addressed during the internship. An internship is designed by the advisor and the student according to mutual interests, needs and availability of related industry/organization. To develop a rewarding program, at the beginning of the internship, the advisor and student are asked to establish an internship plan, in the form of written objectives and goals and to develop a strategy for attaining those goals. The plan may include a schedule of activities that need to be carried out in order to reach a solution for the problem being addressed. The internship plan is not intended to be rigid. Advisor may be unable to asses certain responsibilities until he student demonstrates his or her ability. The plan should be flexible and subject to revision. The advisor and student should assess the student’s progress throughout the term of the internship both to evaluate the student’s performance and to establish new directions as needed.
Concepts of Data Warehouse and Data Mining including its functionalities, stages of Knowledge discovery in database(KDD), Setting up a KDD environment, Issues in Data Warehouse and Data Mining, Application of Data Warehouse and Data Mining.

Role of the Advisor
Advisor are expected to share their experience, insight and enthusiasm with the student throughout the internship. They should continually monitor the progress of the student, assessing written and oral communications and guiding the development of the student’s technical and managerial skills, effectiveness and presentation of self. Advisors are expected to submit a post-internship evaluation of the student’s accomplishments and abilities and of the internship program in general.

Role of the Student
In order for the internship to be a mutually beneficial experience, a student should begin with a definition of his/her objectives and specific interests for the minimum of 10-week/180 hour period to ensure that appropriate activities and projects are selected by the advisor and the student. The student will be responsible for the timely completion and professional quality of all activities and projects assigned. The student is expected to speak frequently with the advisor on his/her progress and interest in other projects, as well as to discuss observations and questions about meetings, project and other activities with which he/she is involved.
The student is required to submit to Advisor, with the first two weeks of the internship, a brief plan for the internship.

Internship Group Size and document preparation

  • Each group must be of maximum 4 students.
  • Each student should prepare individual document on the basis of his/her part in the group project.
  • Supervisors must be assigned to each group

Domain/Scope of Internship (Project Implementation/Research)

  • Bank.
  • Hospitals.
  • Software Companies.
  • NTC, Ncell and other Telecommunication Sectors.
  • Government Organization (IT Related) etc.

Report Format
APA Format

Tentative Contents of Report

  • Abstract
  • Introduction(organization + Work Done)
  • Statement of the problem and objective
  • Literature Review and methodology (optional)
  • System Analysis
  • System Design
  • Implementation
  • System Testing
  • Limitation/future enhancement
  • Conclusion
  • References and Bibliography

Evaluation Criteria
Proposal Defense: 10% weight (Evaluated by Supervisor and Mentor)
Mid-Term: 30% weight (Evaluated by Supervisor and Mentor)
End-Term: 60% weight.

Proposal Defese (At beginning of the Internship)

  • Topic Selection with Proposal (5 of total)
  • Presentation (5% of total)

Mid-Term (After 2 month)

  • Program Design (10% of total)
  • Demo Presentation (10% of total)
  • Viva (10% of total)

End-Term (After Completion of internship and before final exam)

  • Depth of Work (15% of total)
  • Report (25% of total)
  • Viva (10% of total)
  • Presentation (10% of total)

Note: External examiner assigned from TU will be present in final presentation. External Examiner along with Supervisors, Mentor will evaluate internship of students, Proportion of the marks will be same for all evaluators.

Nature of Course: Theory (3 Hrs) + Lab (3 Hrs)

Course Synopsis: Study of Advanced Networking with IPv6

Goal: The course covers about: principles underlying IPv6 Network Design; Internet routing protocols (unicast, multicast and unidirectional) with IPv6; algorithmic issues related to the Internet; IPv6 Migration; measurement and performance; next generation Internet (IPv6, QoS) and applications.

Course Contents:

1. Networking Protocols
1.1 OSI Model
1.2 Internet IP/UDP/TCP
1.3 Routing in the Internet & CIDR
1.4 Multicasting
1.5 Unidirectional Link Routing

2. Next Generation Internet
2.1 Internet Protocol Version 6 (IPv6)
2.2 History of IPv6
2.3 IPv6 Header Format
2.4 Feature of IPv6
2.5 International trends and standards
2.6 IPv6Addressing (Unicast, Anycast & Multicast)

3. ICMPv6 and Neighbor Discovery
3.1 ICMPv6 General Message Format
3.2 ICMP Error and Information Message Types
3.3 Neighbor Discovery Processes and Messages
3.4 Path MTU Discovery 3.5 MLD overview

4. Security and Quality of Service in IPv6
4.1 Types of Threats
4.2 Security Techniques
4.3 IPSEC Framework
4.4 QoS Paradigms
4.5 QoS in IPv6 Protocols

5. IPv6 Routing
5.1 RIPng
5.2 OSPF for IPv6
5.3 BGP extensions for IPv6
5.4 PIM-SM & DVMRP for IPv6

6. IPv4/IPv6 Transition Mechanisms
6.1 Migration Strategies
6.2 Tunneling
  6.2.1 Automatic Tunneling
  6.2.2 Configured tunneling
6.3 Dual Stack
6.4 Translation
  6.4.1 NAT-PT

7. IPv6 Network and Server Deployment
7.1 IPv6 Network Configuration in Linux and Windows Machines
7.2 IPv6 enabled WEB/PROXY/DNS/MAIL Server Configuration
7.3 IPv6 Deployment: Challenges and Risks
7.4 IPv6 and the NGN

Laboratory Work:
For the lab work, one PC to one student either in virtual environment or real environment will be provided. Students will be divided into group of 3 students.

Tools Needed: TCPDUMP & WIRESHARK, VMWare Environment, Linux/FreeBSD, Windows

  • Lab 1: Enable IPv6 in Windows/Linux
  • Lab 2: IPv6 Header Analysis
  • Lab 2: IPv6 Header Analysis
  • Lab 4: Unicast Routing Implementation using Zebra-OSPF & OSPF phase analysis
  • Lab 5: Multicast Routing Implementation using XORP-PIM/SM & PIM/SM phase analysis
  • Lab 6: IPv6 DNS/WEB/Proxy implementation & test
  • Lab 7: Case Study

Reference Books:

  1. Silvia Hagen: IPv6 Essentials, O’reilly
  2. Joseph Davies: Understanding IPv6; eastern economy edition
  3. J. F. Kurose and K. W. Ross: Computer Networking - A Top-Down Approach Featuring the Internet, Addison-Wesley, 2000
  4. S. A. Thomas: IPng and the TCP/IP Protocols, Wiley, 1995
  5. O. Hersent, D. Gurle, J.-P. Petit: IP Telephony, Addison-Wesley, 2000.
  6. Lecture Notes and Related RFCs

Prerequisites: Networking & Communications Fundamentals

Nature of Course: Theory (3 Hrs) + Lab (3 Hrs)

Course Synopsis: Design and development of distributed networking system.

Goal: The course covers about: the function and structure of communications sub-nets, network architectures and their protocols, approaches to the organisation of sub-nets and their architectures, processes of network and protocol design, role of network standards and their relationship to products, Network OS, Distributed Object Network and advance applications.

Course Contents:

Unit 1 (8 Hrs)
Protocols-functions, design, implementation and testing, Architectures, Standards and ProtocolsTCP OSI/IP, connectionless and connection-oriented protocols, protocol stacks, Internetworkingbridges and routers, Internet design and evolution.

Unit 2 (8 Hrs)
Network Design, Performance, Operation and Management-architecture, interoperability and open systems issues, Introduction to Distributed Systems-client/server model, workstations.

Unit 3 (8 Hrs)
Inter-process Communication: API for Internet protocols, External data representation and Marshalling, Client server architecture, Peer-to-peer architecture, Client-Server communication and Group communication

Unit 4 (8 Hrs)
Distributed Objects and Remote Invocation: Communication between distributed objects, Remote Procedure Call, Remote Object Invocation, Message- and Stream-oriented communication, Distributed Web-Based Systems, Common Carrier Services

Unit 5 (8 Hrs)
Distributed OS: network operating systems, Distributed File systems, Distributed synchronization, Distributed object-based systems, Fault Tolerant Computing Systems.

Unit 6 (5 Hrs)
Advance Application: Grid Computing and Application, virtualization and cloud computing

Laboratory works: The laboratories include the installation and configuration of Distributed (network) OS, implementation of Distributed Web based systems, RMI and RPC programming and implementation with JAVA and conceptualization of grid and cloud applications

Reference Books:

  1. Comer DE, (1995), Internet working with TCP/IP Vol. 1, 3e, Prentice-Hall.
  2. Hagit Attiya, Jennifer Welch, Distributed Computing: Fundamentals, Simulations, and Advanced Topics, 2nd Edition, March 2004
  3. Distributed Systems: Principles and Paradigms - Andrew Tanenbaum and Maarten vanSteen, Prentice Hall, 2007

Prerequisite: Networking and Communications Fundamentals

Nature of Course: Theory (3 Hrs) + Lab (3 Hrs)

Course Synopsis: Study of different network security concepts and methods

Goal: In this age of universal electronic connectivity, viruses and hackers, electronic eavesdropping, and electronic fraud, security is paramount. This course provides a practical survey of the principles and practice of network security.

Course Contents:

1. Introduction
1.1 Computer Security Concepts
1.2 The OSI Security Architecture
1.3 Security Attacks
1.4 Security Services
1.5 Security Mechanisms
1.6 A Model for Network Security

2. Key Management and Distribution
2.1 Symmetric Key Distribution Using Symmetric Encryption
2.2 Symmetric Key Distribution Using Asymmetric Encryption
2.3 Distribution of Public Keys
2.4 X.509 Certicates
2.5 Public Key Infrastructure

3. User Authentication Protocols
3.1 Remote User Authentication Principles
3.2 Remote User Authentication Using Symmetric Encryption
3.3 Kerberos
3.4 Remote User Authentication Using Asymmetric Encryption
3.5 Federated Identity Management

4. Transport-Level Security
4.1 Web Security Issues
4.2 Secure Sockets Layer (SSL)
4.3 Transport Layer Security (TLS)
4.5 Secure Shell (SSH)

5. Wireless Network Security
6.1 Pretty Good Privacy (PGP)
6.2 S/MIME
6.3 DomainKeys Identified Mail (DKIM)

6. Electronic Mail Security
6.1. HTTP Server Configuration Basics
6.2. Virtual Hosting
6.3. HTTP Caching
6.4. Proxy Caching Server Configuration
6.5. Proxy-Authentication Mechanisms
6.6. Troubleshooting

7. IP Security
7.1 IP Security Overview
7.2 IP Security Policy
7.3 Encapsulating Security Payload
7.4 Combining Security Associations
7.5 Internet Key Exchange
7.6 Cryptographic Suites

8. Cyber Security Overview

Laboratory works: All the features of this course.

Reference Books: Cryptography and Network Security: Principles and Practice, 5/E,William Stallings, ISBN-10: 0136097049, Prentice Hall, India Limited

Nature of Course: Theory (3 Hrs) + Lab (3 Hrs)

Course Synopsis: Advanced aspects of multimedia database, indexing and retrieval

Goal: To study advanced aspects of indexing, storage device, retrieval of multimedia information encompassing the principles, research results and commercial application of the current technologies

Course Contents:

Unit 1: Multimedia introduction
Introduction to multimedia databases, issues related to multimedia data types, media types, text document information retrieval, indexing

Unit 2: Multimedia Data types and formats
Text, vector graphics and animation, digital images and digital video, major characteristics and requirements of multimedia data and applications

Unit 3: Multimedia database design issues
MIRS architecture, data models and user interface, User Interface design and feature Extraction, Indexing and similarity measure

Unit 4: Text Document Indexing and retrieval
Automatic text document indexing and Boolean Retrieval model, Vector space retrieval model, probabilistic model and cluster-based retrieval model, Nontraditional IR methods, Performance measurement, WWW search engines

Unit 5: Indexing and retrieval of audio
Audio properties and classification, Speech recognition and retrieval, Music indexing and retrieval

Unit 6: Image Indexing and retrieval
Colour –based image indexing and retrieval techniques, Image retrieval based on shape, on texture, Compressed image data, integrated image indexing

Unit 7 : Multimedia Indexing and retrieval
Video shot detection or segmentation, video indexing and retrieval, Video representation and abstraction, Architecture of multimedia Information Management, user interface with example

Unit 8: Techniques and data structures for efficient multimedia similarity search
Filter process, B+ and B trees, Clustering, Multidimensional B+ tree, K-d trees, Grid files, Tree family

Unit 9: System support for distributed multimedia databases
QoS management, Design goals, Data storage devices and management, Data placement on disks, Disk scheduling and admission control, Server configuration and network connection

Unit 10: Multimedia computer architectures and operating system
Process architectures, Computer architectures, Design issues of MOS, QoS support, Multimedia networks, Transport protocols, Synchronous presentation

Unit 11: Measurement of multimedia information retrieval effectiveness
Human Judgment data, Recall and precision pari, Percentage of Weighted Hits, Similarity Ranking, Factors affecting retrieval effectiveness

Unit 12: Products, application and new development
Multimedia search engine, Digital libraries, Video –on-demand, Multimedia security, MPEG-7, Multimedia database applications

Laboratory works: There should be labs related to Multimedia Database

Reference Books:

  1. Gunjoun Lu, Multimedia database management systems
  2. G. Lu, Multimedia Database Management Systems, Artech House, 1999.
  3. T. Shih, Distributed Multimedia Databases: Techniques and Applications, IRM Press, 2002.
  4. V.S. Subrahmanian, Principles of Multimedia Database Systems, Morgan Kaufmann, 1998.

Nature of Course: Theory (3 Hrs) + Lab (3 Hrs)

Course Synopsis: Design and development of distributed and Object oriented database systems

Goal: This course introduces fundamental concept and implementation of object oriented and distributed database systems with focus on data distribution, query processing, transaction processing, concurrency control and recovery.

Course Contents:

Unit 1 (12 Hrs.)
1.1 Introduction to Distributed Database: Distributed Data Processing, Concept of Distributed Database. Distributed vs Centralized Database System; advantages and Application. Transparency, performance and reliability. Problem areas of Distributed Database. Integrity Constraints in Distributed Databases
1.2 Distributed Database Architectures: DBMS standardization. Architectural models for Distributed DBMS – autonomy, distribution and heterogeneity. Distributed Database architecture – Client/Server, Peer-to-Peer distributed systems, MDBS Architecture. Distributed Catalog management
1.3 Distributed Database Design: Design strategies and issues. Data Replication. Data Fragmentation – Horizontal, Vertical and Mixed. Resource allocation. Semantic Data Control in Distributed DBMS.

Unit 2 (17 Hrs.)
2.1 Distributed Query Processing: Query Decomposition and Data localization for distributed data, join ordering, semi-join strategy, Distributed Query optimization methods.
2.2 Distributed Transaction Management: The concept and role of transaction. Properties of transactions-Atomicity, Consistency, Isolation and Durability. Architectural aspects of Distributed Transaction, Transaction Serialization.
2.3 Distributed Concurrency Control: Lock-based and Timestamp-based Concurrency Control methods. Optimistic method for Concurrency Control. Deadlock management- prevention, avoidance detection, and resolution. Nonserializable schedule and nested distributed transaction.
2.4 Reliability of Distributed DBMS and Recovery: Concept and measures of reliability, Failure analysis, types of failures. Distributed Reliability Protocols. Recovery techniques. Two Phase Commit , Presumed abort, Presumed commit. Three phase commit, Partitions, Scalability of Replication.

Unit 3 (16 Hrs.)
3.1 Object Oriented Database Concept: Data types and Object, Evolution of Object Oriented Concepts, Characteristics of Object Oriented Data Model. Object Hierarchies - Generalization, Specialization, Aggregation. Object Schema. Interobject Relationships, Similarities and difference between Object Oriented Database model and Other Data models
3.2 OODBMS Architecture Approach: The Extended Relational Model Approach. Semantic Database Approach, Object Oriented Programming Language Extension Approach, DBMS Generator Approach, the Object Definition Language and the Object Query Language.
3.3 The Object Oriented DBMS Architecture, Performance Issue in Object Oriented DBMS, Application Selection for Object Oriented DBMS, the Database Design for an Object Relational DBMS. The Structured Typed and ADTs, Object identity, Extending the ER Model ,Storage and Access Methods, Query Processing Query Optimization, Data Access API(ODBC,DB Library, DAO,ADO,JDBC,OLEDB), Distributed Computing Concept in COM, COBRA.

Laboratory works: All distributed and OO database components mentioned in this course. (Practical implementation in Oracle 9i or Oracle 10g covering both Distributed and Object Oriented Database Features)

Reference Books:

  1. Principles of Distributed Database Systems; Ozsu, M. Tamer and Patrick Valduriez. Pearson Education.
  2. Object Oriented Database System – Approaches and Architectures ; C.S.R. Prabhu, PHI
  3. Silberschatz,Abraham, Henry F. Korth and S. Sudarshan: Database System Concepts; McGrawHill International Edition
  4. Gerald V. Post: Database Management System – McGraw Hill International Edition
  5. Peter Rob, Carlos Coronnel: Database Systems – Design, Implementation and Management; Course Technology.
  6. R.Cattel: "Object Data management",(1993),Addison-Wesley

Prerequisite: Relational Database Management System, SQL, Computer Network , Object Oriented Programming Languages

Assignment: Assignment should be given throughout the semester

Nature of Course: Theory (3 Hrs) + Lab (3 Hrs)

Course Synopsis: This course gives an introduction to cloud computing and its techniques. The topics covered include; introduction to cloud computing, cloud architecture, cloud service models, Service Oriented Architectures, security in cloud computing, disaster management in clouds.

Goal: Cloud computing has become a great solution for providing a flexible, on-demand, and dynamically scalable computing infrastructure for many applications. Cloud computing also presents a significant technology trends, and it is already obvious that it is reshaping information technology processes and the IT marketplace. Thus objective of this course is to introduce the aspects of cloud computing issues.

Course Contents:

Unit 1: Introduction (10 Hrs.)
Defining the Cloud, The Emergence of Cloud Computing, Cloud-Based Services, Grid Computing or Cloud Computing, Components of Cloud Computing, Cloud Computing Deployment Models: Public, Private, Hybrid, Benefits of Using a Cloud Model, Legal Issues in Using Cloud Models, Characteristics of Cloud Computing, Evolution of Cloud Computing, Challenges for the Cloud computing, Grid Computing, Distributed Computing in Grid and Cloud

Unit 2: Cloud Service Models (15 Hrs.)
Communication-as-a-Service (CaaS): Advantages of CaaS, Fully Integrated, Enterprise-Class Unified Communications, Infrastructure-as-a-Service (IaaS): Modern On-Demand Computing, Amazon’s Elastic Cloud, Amazon EC2 Service Characteristics, Monitoring-as-a-Service (MaaS), Protection Against Internal and External Threats, Platform-as-a-Service (PaaS): The Traditional On-Premises Model, The New Cloud Model, Key Characteristics of PaaS, Software-as-a-Service (SaaS): SaaS Implementation Issues, Key Characteristics of SaaS, Benefits of the SaaS Model, Jericho Cloud Cube Model

Unit 3: Building Cloud Networks (9 Hrs.)
Evolution from Managed service providers (MSP) to Cloud Computing, Single Purpose architectures to multi-purpose architectures, Data center virtualization, Cloud data center, Service Oriented Architectures (SOA), Combining and SOA, Characterizing SOA, Open Source Software in data centers

Unit 4: Security in Cloud Computing (11 Hrs.)
Cloud Security Challenges, Software-as-a-Service Security: Security management, Risk Management, Security Monitoring and Incident Response, Security Architecture Design, Vulnerability Assessment, Data Privacy and Security, Application Security, Virtual Machine Security, disaster Recovery, Disasters in cloud, Disaster management

Laboratory works: As a part of lab work, the students are highly encouraged

  • To simulate the concept of virtualization using virtualization programs/systems.
  • To understand and practice examples of cloud services and applications.
  • To understand and implement distributed storage and security issues in cloud computing.

Reference Books:

  1. Cloud Computing: Implementation Management and Security, John W. Rittinghouse and James F. Ransome (Recommended for Unit 1, 2, 3 4)
  2. Cloud Application architecture, George Reese (Recommended for Unit 4)
  3. Cloud Computing for Dummies, Judith Hurwitz, Robin Bloor, Marcia Kaufman, Fern Halper(Recommended for Unit 3)
  4. Handbook of cloud computing, Borko Furht, Armando Escalante (Recommended for Unit 1)
  5. Cloud Computing and SOA Convergence in your Enterprise, a step by step guide, David S. Linthicum (Recommended for Unit 1, 2, 3)

Nature of Course: Theory (3 Hrs) + Lab (3 Hrs)

Course Synopsis: Basic concepts of Geographical Information System

Goal: The course covers about spatial data modelling and database design, capturing the real world, spatial analysis and visualization, overview of open GIS

Course Contents:

Unit 1: Introduction (6 Hrs.)
1.1 Overview, History and concepts of GIS
1.2 Scope and application areas of GIS
1.3 Purpose and benefits of GIS
1.4 Functional components of GIS
1.5 Importance of GPS and remote sensing data in GIS

Unit2: Digital mapping concept (3 Hrs.)
2.1 Map concept: map elements, map layers, map scales and representation
2.2 Map projection: coordinate system and projection system

Unit 3: spatial data modeling and database design (9 Hrs.)
3.1 introduction to geographic phenomena and data modeling
3.2 spatial relationships and topology
3.3 scale and resolution
3.4 vector, raster and digital terrain model
3.5 Spatial database design with the concepts of geodatabase

Unit 4: capturing the real world (8 Hrs.)
4.1 different methods of data capture
4.2 map projection and spatial reference
4.3 data preparation, conversion and integration
4.4 quality aspects of spatial data
4.5 GPS 4.6 Remote Sensing

Unit 5: spatial analysis and visualization (7 Hrs.)
5.1 spatial analysis
  i. overlay
  ii. buffering
5.2 map outputs and its basic elements

Unit 6: introduction to spatial data infrastructure (8 Hrs.)
6.1 SDI concepts and its current trend
6.2 The concept of metadata and clearing house
6.3 Critical factors around SDIs

Unit 7: Open GIS (4 Hrs.)
7.1 Introduction of open concept in GIS
7.2 Open source software for spatial data analysis
7.3 Web Based GIS system
7.4 System Analysis and Design with GIS

Laboratory works: The lab should cover at least the concepts given the chapters

Reference Books:

  1. Principles of geographic information systems: An introductory textbook, international institute for Geo-information science and Earth observation, the Netherlands- By rolf De By, Richard A. knippers, yuxian sun
  2. ESRI guide to GIS analysis Andy Mitchell, ESRI press, Red lands
  3. GIS Cook BOOK

Leave a Message