Senior Year

Senior Year/ Seventh Semester
1. CSC-401: Advanced Database Management System
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.
Course Synopsis: To study the concept of advanced database technique
Reference Books: Elmasri and Navathe, , Fundamentals of Database System Person Education, Raghu Ramakrishna, Johannes Gehrke, Delectatabase Management Systems, McGraw-Hill ,
Korth, Silberchatz, Sudarshan,Database System concepts, McGraw-Hill , Peter Rob and Coronel, Database System, Design, Implementation and Management, Thomson Learning, C.j Date & longman, Introduction to Database Systems, Pearson Education.
Prerequisite: 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 covered throughout the semester.
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%
2. CSC-402: Internet Technology
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 infrastructures, methods for developing content and techniques for site deployment and management.
Introduction
Unit 1. Internet Protocol Overview
1.1. TCP/IP and the IP Layer overview
1.2. IPv4 and IPv6 Address Types and Formats
1.3. IPv4 and IPv6 Header Structure
1.4. Internet RFCs
Unit 2. Protocols and Client/Server Applications
2.1. Standard Protocols: STMP,E-mail Message(RFC22), PGP,POP,IMAP,HTTP,FTP
2.2. N-Tiered Client/Server Architecture
2.3. Universal Internet Browsing
2.4. Multiprotocol Support
Unit 3. HTTP and the web Services
3.1. HTTP, Web Servers and Web Access
3.2. Universal naming with URLs
3.3. WWW Technology: HTML, DHTML, WML, XML
3.4. Tools: WYS/WYG Authoring Tools
3.5. Helper Applications: CGI, PERL, JAVA, JAVA SRIPTS, PHP, ASP, .NET Applications
3.6. Introduction to AJAX(Programming)
3.7. Browser as a rendering engine: test, HTML, gif and jpeg
Unit 4. Designing Internet Systems and Servers
4.1. Designing of Internet System Network Architecture
4.2. Choice of platforms
4.3. Server Concepts: WEB, Proxy, RADIUS, MAIL
4.4. Cookies
4.5. Load Balancing: Proxy Arrays
4.6. Server Setup and configuration Guidelines
4.7. Security System Administration Issues, Firewalls and Content Filtering
Unit 5. Internet and Intranet Systems Development
5.1. Introductions
5.2. Benefits and drawbacks of intranets
5.3. Protocols, Structure and Scope of Networks
5.4. Intranet Resource Assessments: Network Infrastructure, Clients and Server Resources
5.5. Intranet Implementation Guidelines
5.6. Content Design, Development, Publishing and Management
5.7. Intranet Design with Open source Tools: DRUPAL, JUMLA
5.8. Tunneling Protocols:VPN
Unit 6. Internet and Intranet Applications
6.1. General Application: Email, WWW, Gopher, Online Systems
6.2. Multimedia and Digital Video/Audio Broadcasting: Video/Audio Conferencing, Internet Relay Chat(IRC)
6.3. Broadband Communication, Policy, xDSL and Cable Internet
6.4. VoIP, GoIP and IP interconnection
6.5. Datacenters and Data warehousing, packet clearing house
6.6. Unified Messaging Systems
6.7. Fundamental of e-Commerce
6.8. Concept of Grid and Cloud Computing
Reference Books: Computer Networks: Andrew S. Tanenbaum, Prentice Hall India limited, New Delhi, 2010, Internet and Intranet Engineering: Daniel Minoli, MGraw-Hill India Limited, New Delhi, 2009, Internetworking with TCP/IP: Comer, D.E and Stevens
Laboratory Work: 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.
3. CSC-403: Advanced Java Programming
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 Work: 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.
4. CSC-404: Project Work
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
1. Problem Identification
2. Problem Specification
3. Analysis and Design
4. System Development
5. Installation and Testing
6. 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.
Elective (Any one of the following courses)
5. CSC-405: Information Retrieval
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 Work: 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.
Home Work:
Assignment: Assignment should be given from the throughout the semester.
Assignment: Not Specific.
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%.
6. CSC-406: Database Administration
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 Work: 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.
7. CSC-407: Network and System Administration
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.2. SAMBA SWAT
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 Work: 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.
Prerequisite: Computer Networking Course.
8. CSC-408: Software Project Management
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 Work: 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/ Eight Semester
1. CSC-451: Data Warehousing and Data Mining
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 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 7. (6Hrs)
Mining Association Rules in Large Databases: Association Rule Mining, Why association Mining is necessary, Pros and Cons of association Rules, Apriori Algorithm.
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.
Unit 9. (4Hrs)
Mining Complex Types of Data: Mining Text Databases, Mining the WWW, Mining multimedia and Spatial Databases.
Laboratory Work: Cover all the concept of data warehouse and mining mention in a course
Samples
1. Creating a simple data warehouse.
2. OLAP operation: Roll Up, Drill Down, Slice 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, DolfZantnge
5. Data Mining, Alex Berson, Stephen Smith, Korth Theorling, TMH,
6. Data Mining, Adriaans, Addison-Wesley Longman.
2. CSC-452: Internship
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.
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.

3. CSC-453: Advanced Networking with IPv6
Nature of Course: Theory (3Hrs.) +Lab (3Hrs.)
Full Marks: 100
Course Synopsis: Study of Advanced Networking with IPv6
Goal: The course covers about: principles underlying IPv6 Networking Design; Internet routing protocols(unicast 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. IPv6 Addressing (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
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. BGP extensions for IPv6
5.5. 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 NGNLaboratory Work:
For the lab work, one student either in virtual environment or real environment will be provided. Students will be divided into group of 3 students. The working environment and machine connectivity will look like the following:
Tools Needed:
TCPDUMP & WIRESHARK, VMWare Environment, Linux/FreeBSD, Windows
Lab 1: Enable IPv6 in Window/Linux
Lab 2: IPv6 Header Analysis
Lab 3: IPv6 Packet analysis (neighbor/router solicitation/discovery)
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
Lab 7: Case Study
Reference Book
1. Silvia Hagen: IPv6, 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. Hersenk, D. Gurle, J. –P. Petit: IP Telephony, Addison – Wesley. 2000
6. Lecture Notes and Related RFCs
Prerequisite:
Networking & Communications Fundamentals

4. CSC-454: Distributed Networking
Nature of Course: Theory (3Hrs.) +Lab (3Hrs.)
Full Marks: 100
Course Synopsis: Design and Develpment and Distributed networking System
Goal: The course covers about: the function and structure if the communications sub-nets, network architectures and their protocols, approaches to the organization of the sub-nets and their architecture, processes of newir and protocol design, role of network standards and their relationship to products, Networks OS, Distributed Object Network and advne applications.
Course Contents:
Unit 1: 8 Hrs
Protocols-functions, design, implementation and testing, Architectures, Standards and Protocols-TCP OSI/IP, connectionless and connection-oriented protocols, protocol stacks, Internetworking-bridge and routers, Internet design and evolution.
Unit 2: 8 Hrs
Network Design, performance, Operation and Management-architecture, interoperability and open system issues, Introduction to Distributed System-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 Object and Remote Invocation: Communication between distributed objects, remote Procedure Call, Remote Object Invocation, Message- and Stream-oriented communication, Distributed Web-Based System, Common Carrier Services
Unit 5: 8 Hrs
Distributed OS: Network operating system, Distributed File Systems, Distributed synchronization, distributed object-based systems, Fault Tolerant Computing Systems.
Unit 6: 5 Hrs
Advance Application: Grid competing and Application, virtualization and cloud computing
Laboratory Work:
The laboratories include the installation and configuration of Distributed (network) OS, implementation of distributed Web based system RMI and RPC programming and implementation with JAVA and conceptualization of grid and cloud application.
Reference Books:
1. Comer DE (1995), Internet working with TCP/IP Vol. 1, 3e, Prentice-Hall.
2. Hagit Attiya, Jennifer Welch, Distributed Computing: Fundamentals, Simulation, and Advanced Topics, 2nd Edition, March 2004
3. Distributed System: Principles and Paradigms – Andrew Tanenbaum and Maarten van Steen, Prentice Hall, 2007.
Prerequisite:
Networking & Communications Fundamentals
5. CSC-455: Network Security
Nature of Course: Theory (3Hrs.) +Lab (3Hrs.)
Full Marks: 100
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 frauds, security is paramount. This course provides a practical survey of the principles and practice of networks security.
Course Contents:
1. Introduction: 6 Hrs
1.1. Computer Security Concepts
1.2. The OSI Security Architecture
1.3. Security Attacks
1.4. Security Service
1.5. Security Mechanisms
1.6. A model for Network Security
2.Key Management and distribution: 5 Hrs
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: 6 Hrs
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. Federation Identity Management
4.Transport-Level Security 6 Hrs
4.1. Web Security Issues(SSL)
4.2. Transport Layer Security(TLS)
4.3. HTTPS
4.4. Secure Shell(SSH)
5.Wireless Network Security 7 Hrs
5.1. IEEE 802.11 Wireless LAN Overview
5.2. IEEE 802.11i Wireless LAN Security
5.3. Wireless Application Prototype Overview
5.4. Wireless Transport Layer Security
5.5. WAP End-to-End security
6.Electronic Mail Security 3 Hrs
6.1. Pretty Good Privacy (PGP)
6.2. S/MIME
6.3. Domain Keys Identified Mail (DKIM)
7.IP Security 8 Hrs
7.1. IP Security Overview
7.2. IP Security Policy
7.3. Encapsulation Security Payload
7.4. Combining Security Associations
7.5. Internet Key Exchange
7.6. Cryptographic Suites
8.Cyber Security Overview 4 Hrs
Laboratory Work:
All the features covered in this syllabus.
Reference Books:
Cryptography and Network Security: Principles and Practice, 5/E, William Stallings, ISBN-10: 0136097049, Prentice Hall, India Limited
6. CSC-456: Multimedia Database
Nature of Course: Theory (3Hrs.) +Lab (3Hrs.)
Full Marks: 100
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 principle, research results and commercial application f the current technologies.
Course Contents:
Unit: 1 Multimedia Introduction 3 Hrs
Introduction to Multimedia Databases, issues to multimedia data types, media types text document information retrieval.
Unit 2: Multimedia Data types and format 3 Hrs
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 2 Hrs
MIRS architecture, data models and user interface, User Interface design and feature Extraction, Indexing and similarity measure
Unit 4: Text Document Indexing and retrieval 5 Hrs
Automata text document indexing a Boolean Retrieval model, Vector space retrieval model, probabilistic model and closer-based retrieval model, Normalization IR methods, Performance measurement, WWW search engine.
Unit 5: Indexing and retrieval of audio 2 Hrs
Audio properties and classification, speech recognition and retrieval, Music indexing and retrieval
Unit 6: Image Indexing and Retrieval 5 Hrs
Color-based image indexing techniques, Image retrieval based on shape, on texture, Compressed image data, integrated image indexing
Unit 7: Multimedia Indexing and retrieval 5 Hrs
Video shot detection or segmentation, video indexing and retrieval, Video representation and abstraction, Architecture of multimedia Information Management, Ur interface with example
Unit 8: Techniques and data structure for efficient multimedia similarity search 5 Hrs
Filter process, B+ and B trees, Clustering, Multidimensional B+ tre, K-d trees, Gid files, Tree family
Unit 9: System support for distributed multimedia databases 5 Hrs
QoS management, Design goals, data storage devices and management, Data placement on disk, Disk scheduling and admission control, Server configuration and network connection
Unit 10: Multimedia computer architecture and operating system 4 Hrs
Process architectures, computer architectures, design issues of MOS, QoS support, Multimedia networks, Transport protocols, Synchronous presentation
Unit 11: Measurement of multimedia information retrieval effectiveness 3 Hrs
Human Judgment data, Recall and decision pari, Percentage of Weighted Hits, Similarly Ranking, Factor affecting retrieval effectiveness
Unit 12: Products, application and new development 3 Hrs
Multimedia search engine, Digital libraries, Video –on-demand, Multimedia security, MPEG-7, Multimedia database applications
Laboratory Work:
There should be labs related to Multimedia Database
Reference Books:
1. Gunjoun Lu, Multimedia database management systems.
2. G. Lu, Multimedia Database Management System, Artech House, 1999.
3. T. Shih, Distributed Multimedia Database: Techniques and applications, IRM Press, 2002.
4. V.S. Subrahmanian Principles of Multimedia Database Systems, Morgan Kaufmann, 1998.
7. CSC-457: Distribution and Object Oriented Database
Nature of Course: Theory (3Hrs.) +Lab (3Hrs.)
Full Marks: 100
Course Synopsis: Design and development if distributed ad object oriented database systems
Goal: This course introduces fundamental concept and implementation of object oriented and distributed database 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 od Distributed Data Processing, Distributed Vs Centralized Database System; advantage and application. Transparency, performance and reliability. Problem areas of Distributed Database Integrity Constants in Distributed databases.
1.2 Distributer 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 Decomposing and Data localization for distributed data, join ordering, semi-join strategy, Distribution Query optimization methods.
2.2 Distributed Transaction Management: The concept and role of transaction. Properties of transaction-Atomicity, Consistency, isolation and Durability. Architecture aspects of Distributed Transaction, Transaction Serialization.
2.3 Distributed Concurrency Control: Lock-based and Timestamp-based. Concurrency Control method. Optimistic method for concurrency control. Deadlock management- prevention, avoidance detection, and resolution. Non-serializable schedule and nested distribution transection.
2.4 Reliability if Distributed DBMS and Recovery: Concept and measures of reliability, Failure analysis, type of failures. Distributed reliability Protocols. Recovery techniques. Two Phase. Commit, presumed abort, presumed commit. Three phase commit Portions, Scalability of Replication.
Unit 3 16 Hrs
3.1 Object Oriented Database Concept: Data types and objects, Evolution of Object Oriented Concepts, Characteristics of Object Oriented Data Model. Object Hierarchies – Generalization, Specialization, aggregation. Onject Oreanted Schema. Inter-object 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 Structured Typed and ADTs, Object identity, Extending the ER Model, Storage and Access Methods, Query Processing Query optimization, Data Access API(ODDBC, DB Library, DAO, ADO, JDBC, OLEDB), Distributed Computing Concept in COM, COBRA.
Laboratory Work:
All distributed and OO database components mentioned in this course.(Practical implementation in Oracle 9i of Oracle 10g covering both Distributed and Objected Oriented Database Features)
Reference Books:
1. Principles of Distributed Systems; Ozsu, M. Tamer and Patrick Valduriez. Pearson Education.
2. Object Oriented Database System – Approaches and architecture ; C.S.R. Prabhu, PHI
3. Silberschatz, Araham, Henry F. Korth and S. Sudaeshan: Database System Concepts; McGrawHill International Edition.
4. Gerald V. Post: Database Management System – McGrawHill International Edition.
5. Peter Rob, Carlos Coronnel: Database Systems-Design, Implementation and Management; Course technology.
6. R.Cattel: “Odject Data Management”,(1993), Addison-Wesley
Prerequisite
Relational Database Management System, SQL, Computer Network, Object Oriented Programming Languages.
8. CSC-458: Cloud Computing
Nature of Course: Theory (3Hrs.) +Lab (3Hrs.)
Full Marks: 100
Course Synopsis: This course gives and 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 been a great solution for providing a flexible, on-demand, and dynamically scalable computing infrastructure from many applications. Loud computing also presents a significant technology trends, and it is already obvious that it is reshaping information technology processes and the IT marketplace. Thus object of this course is to introduce the aspects of the cloud computing issues.
Course Contents:
Unit 1: Introduction 10 Hrs
Defining the cloud, the emergence of cloud computing, Cloud-Based Servers, Grid computing or Cloud computing, Components of Cloud Computing, Could Computing deployment Moode Public, Private, Hybrid, Benefits of using Cloud Model, Legal Issues in Using Cloud Modes, Characteristics of Cloud Computing, Evolution of Cloud Computing, Challenges for the Cloud Computing, Grid Comuting, 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, Infrastructures-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, latform-as-a-Service (PaaS): The Traditional On-Protection Model, The New Cloud Model, 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 an Incident Response, Security Architecture Design Vulnerability Assessment, Data Privacy and Security, Virtual Machine Security, Disaster Recovery, Disasters in cloud, Disaster management
Laboratory Work:
As a part of the lab work, the student are highly encouraged
 To simulate the concept of virtualization using virtualization programs/systems.
 To understand and practice examples of cloud service 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)
9. CSC-459: Geographical Information System
Nature of Course: Theory (3Hrs.) +Lab (3Hrs.)
Full Marks: 100
Course Synopsis: Basic concept of Geographical Information System
Goal: The course covers about spatial data modelling ad 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 area 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
Unit 2: 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 relations 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 difference 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 output 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 factor 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 Work:
The lab should cover at least the concepts given in the chapters.
Reference Books:
1. Principles of geographic information system: 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.