Resources for BSC(IT) STUDENTS

Spatial Data Concepts:
Introduction to GIS, Geographically referenced data, Geographic, projected and planer coordinate system, Map projections, Plane coordinate systems, Vector data model, Raster data model

Unit II

Data Input and Geometric transformation:
Existing GIS data, Metadata, Conversion of existing data, Creating new data, Geometric transformation, RMS error and its interpretation, Resampling of pixel values.

Unit III

Attribute data input and data display :
Attribute data in GIS, Relational model, Data entry, Manipulation of fields and attribute data, cartographic symbolization, types of maps, typography, map design, map production

Unit IV

Data exploration:
Exploration, attribute data query, spatial data query, raster data query, geographic visualization

Unit V

Vector data analysis:
Introduction, buffering, map overlay, Distance measurement and map manipulation.

Raster data analysis:
Data analysis environment, local operations, neighbourhood operations, zonal operations, Distance measure operations

Spatial Interpolation:
Elements, Global methods, local methods, Kriging, Comparisons of different methods

Text Book

Introduction to Geographic Information Systems by Kang-Tsung Chang Published by Tata Mcgraw Hill

Reference Books and websites

Concepts and Techniques in Geographic Information Systems by Chor Pang Lo and Albert K. W. Yeung

http://www.ncgia.ucsb.edu/giscc/

Tybsc (IT) SEM - 6

Project Management

Unit-I

Conventional Software Management :
The waterfall model, conventional software Management performance.

Evolution of Software Economics :

Software Economics, pragmatic software cost estimation.

Improving Software Economics :
Reducing Software product size, improving software processes, improving team effectiveness, improving automation, Achieving required quality, peer inspections.

Unit-II

The old way and the new :
The principles of conventional software Engineering, principles of modern software management, transitioning to an iterative process.

Life cycle phases :
Engineering and production stages, inception, Elaboration, construction, transition phases.

Artifacts of the process :
The artifact sets, Management artifacts, Engineering artifacts, programmatic artifacts.

Model based software architectures :
A Management perspective and technical perspective.

Unit-III

Work Flows of the process :
Software process workflows, Iteration workflows

Checkpoints of the process :
Major mile stones, Minor Milestones, Periodic status assessments.

Iterative Process Planning :

Work breakdown structures, planning guidelines, cost and schedule estimating, Iteration planning process, Pragmatic planning.

Unit-IV

Project Organizations and Responsibilities:
Line-of-Business Organizations, Project Organizations, evolution of Organizations.

Process Automation:

Automation Building blocks, The Project Environment.

Unit-V

Project Control and Process instrumentation:

The seven core Metrics, Management indicators, quality indicators, life cycle expectations, pragmatic Software Metrics, Metrics automation.

Tailoring the Process:
Process discriminants.

Unit-VI

Future Software Project Management:
Modern Project Profiles, Next generation Software economics, modern process transitions.

Books:

1. Software Project Management, Walker Royce: Pearson Education, 2005.

2. Information Technology Project management (4th Edition) – Kathy Schwalbe (Centgage Learning – Indian Edition)

Reference Books:

1. Project Management Core Textbook – Mantel Jr., Meredith, Shafer, Sutton with Gopalan (Wiley India Edition)

2. Information Technology project Management,: a concise study, (3rd ed.) by S A Kelkar (PHI)

3. Project Management- A systems Approach to planning, scheduling and controlling - Harold Kerzner (John Wiley & Sons, Inc)

4. A Guide to the Project Management Body of Knowledge (3rd Edition)- Newtown Square, PA, Project Management Institute, 2005.

Tybsc (IT) SEM 6 SYLLABUS IPR & CYBER LAW

IPR and Cyber Laws

Unit-I

Basic Principles and Acquisition of Intellectual Property Rights:
Focus on the: Philosophical Aspects of Intellectual Property Laws, Basic Principles of Patent Law, Patent Application procedure, Drafting of a Patent Specification, Understanding Copyright Law, Basic Principles of Trade Mark, Basic Principles of Design Rights, International Background of Intellectual Property.

Unit II

Information Technology Related Intellectual Property Rights :
Computer Software and Intellectual Property-Objective, Copyright Protection, Reproducing, Defences, Patent Protection.

Database and Data Protection-
Objective, Need for Protection, UK Data Protection Act, 1998,US Safe Harbor Principle, Enforcement.

Protection of Semi-conductor Chips-
Objectives Justification of protection, Criteria, Subject-matter of Protection, WIPO Treaty, TRIPs, SCPA.

Domain Name Protection-
Objectives, domain name and Intellectual Property, Registration of domain names, disputes under Intellectual Property Rights, Jurisdictional Issues, and International Perspective.

Unit-III

Patents (Ownership and Enforcement of Intellectual Property) :
Patents-Objectives, Rights, Assignments, Defences in case of Infringement Copyright-Objectives, Rights, Transfer of Copyright, work of employment Infringement, Defences for infringement Trademarks-Objectives, Rights, Protection of good will, Infringement, Passing off, Defences.
Designs-Objectives, Rights, Assignments, Infringements, Defences of Design Infringement.

Unit-IV

Enforcement of Intellectual Property Rights - Civil Remedies, Criminal Remedies, Border Security measures.
Practical Aspects of Licencing – Benefits , Determinative factors, important clauses, licensing clauses.

Unit-V

Cyber Law:

Basic Concepts of Technology and Law : Understanding the Technology of Internet, Scope of Cyber Laws, Cyber Jurisprudence.

Law of Digital Contracts : The Essence of Digital Contracts, The System of Digital Signatures, The Role and Function of Certifying Authorities, The Science of Cryptography.

Intellectual Property Issues in Cyber Space: Domain Names and Related issues, Copyright in the Digital Media, Patents in the Cyber World.

Rights of Netizens and E-Governance : Privacy and Freedom Issues in the Cyber World, E-Governance, Cyber Crimes and Cyber Laws

Unit-VI

Information Technology Act 2000 :
Information Technology Act-2000-1 (Sec 1 to 13), Information Technology Act-2000-2 (Sec 14 to 42 and Certifying authority Rules), Information Technology Act-2000-3 (Sec 43 to 45 and Sec 65 to 78), Information Technology Act-2000-4(Sec 46 to Sec 64 and CRAT Rules), Information Technology Act-2000-5 (Sec 79 to 90), Information Technology Act- 2000-6 ( Sec 91-94) Amendments in 2008.

International Scenario in Cyber Laws :
Data Protection Laws in EU and USA, Child Abuse Protection Laws in EU and USA, Cyber Laws - the Malaysian Approach.

Cyber Law Issues for Management :
Cyber Law Issues in E-Business Management, Major issues in Cyber Evidence Management, Cyber Law
Compliancy Audit. References:

References:

1. Peter Weill , Jeanne Ross “IT Governance: How Top Performers Manage IT Decision Rights for Superior Results”

2. Jeanne W. Ross “Enterprise Architecture As Strategy: Creating a Foundation for Business Execution”

3. Peter Weill “IT Savvy: What Top Executives Must Know to Go from Pain to Gain

4. www.wipo.org

5. IT Act 2000 with amendments in 2008

6. How To Register Your Own Copyright by Marx Warda, Sphinx Publishing

7. Licensing Art & Design by Caryn R. Leland, Allworth Press

8. Managing Intellectual Property: The Strategic Importance, (2 ed.) V. V. Sopale ( PHI)

Tybsc (IT) SEM - 6

Data warehousing

Unit-I

History of data warehousing:
Database management system, personal computers and 4GL technology, spider web environment, evolution from business perspective, data warehouse environment, what is datawarehouse? , integrating data, volumes of data, different development approach, evolution to DW 2.0 environment, business impact of the data warehouse, components of datawarehouse environment, evolution of data warehouse from the business perspective, other notions about data warehouse, federated data warehouse, star
schema, data mart.

Introduction:
Lifecycle of data warehouse, reasons for different sectors, metadata, Access of data, structures data/ unstructured data, Textual analysis, blather, issue of terminology, specific text, metadata – a major component, local metadata, changing business requirements, flow of data within DW 2.0, volumes,
useful applications, DW 2.0 and referential integrity, reporting in DW 2.0

DW components:
Interactive sector, integrated sector, Near Line sector, Archival sector.

Unit-II

Metadata in DW:
Reusability of data analysis, Metadata, Active/ passive repository, enterprise metadata, metadata and the system record, Taxonomy, Internal and external taxonomy, metadata in archival sector, maintaining metadata, using metadata – an example, end user perspective.

Methodology and Approach for DW:
Spiral model methodology, seven streams approach, enterprise reference model, enterprise knowledge coordination stream, information factory development stream, Data correction stream, infrastructure stream, Total information quality management stream.

Statistical processing and DW:
Two types of transaction, statistical analysis, integrity of comparison, heuristic analysis, freezing data, exploration processing, frequency of analysis, exploration facility, sources for exploration processing, refreshing exploration data, project based data, Data marts and exploration facility, A backflow of data, using exploration data internally, perspective of business analyst.

Unit-III

Data models and DW:
Datamodel and business, scope of integration, making the distinction between granular and summarized data, levels of the data model, data models and interactive sector, corporate data model, transformation of models,
data models and unstructured data, perspective of business user.

Monitoring the DW environment:
Monitoring DW environment, transaction monitor, monitoring data quality, datawarehouse monitor, transaction monitor, peak period processing, ETL data quality monitor, Dormant data.

DW and security:
Protecting access to data, encryption, drawbacks, firewall, moving data offline, limiting encryption, direct dump, datawarehouse monitor, sensing an attack, security for near line data.

Unit-IV

Time variant data:
All data in DW, Time relativity in the interactive sector, data relativity elsewhere in DW, Transactions in integrated sector, discrete data, continuous time span data, a sequence of records, nonoverlapping records, beginning and ending a sequence of records, continuity of data, Time-collapsed data, time variance in the archival sector

Flow of data in DW:
flow of data throughout the architecture, entering the interactive sector, role of ETL, data flow into integrated sector, near line, archival sector, falling probability of data access, exception flow of data.

ETL processing and DW:
Changing states of data, Where ETL fits, application data to corporate data, ETL in online mode and batch mode, source and target, ETL mapping, more complex transformation, ETL and throughput, ETL and metadata, ETL and an audit trail, ETL and data quality, creating ETL, code creation or parametrically driven ETL, ETL and rejects, changed data capture, ETL and rejects, Changed data capture, ELT

Unit-V

DW and granularity manager:
granularity manager, raising the level of granularity, filtering data, functions of the granularity manager, homegrown versus third party granularity manager, parallelizing the granularity manager.

DW and performance:
Online response time, analytical response time, flow of data, Queues, heuristic processing, analytical productivity and response time, many facets to performance, indexing, removing dormant data, end user education, monitoring the environment, capacity planning, metadata, batch parallelization, parallelization for transaction processing, workload management, data marts, exploration facilities, separation of transactions into classes, service level agreements, protecting the interactive sector, partitioning data, choosing the proper hardware, separating farmers and explorers, physically group data.

Migration:
Migration in perfect world, adding components incrementally, adding archival sector, creating enterprise metadata, building the metadata infrastructure, swallowing source system, ETL as shock absorber, migration to the unstructured environment.

Unit-VI

Implementation And Maintenance:
Physical design process, data warehouse deployment, growth and maintenance.

Books

DW2.0 The architecture for Next Generation of Datawarehousing W.H. Inmon, Derek Strauss, Genia Neushloss, ELSEVIER. (Unit I to V)

Paulraj Ponnian, “Data Warehousing Fundamentals”, John Wiley. (Unit VI)

Practical List:

1.            Create around 25 records and design the tabular view using Excel. Create around 25 records and design the Chart view using Excel.

2.            Extract the data from excel , access and sql and integrate it in SQL server.

3.            Perform the same process using DTS package

4.            Design the star schema and create a cube using OLAP services

5.            Perform the cube analysis on MOLAP

6.            Perform the cube analysis on ROLAP

7.            Perform the cube analysis on   HOLAP

8. Consider a data warehouse storing data about sales, where the total items sold are stored, organised by customer order and product. Each customer order includes the name of the customer and the date of the order; each product includes a description of the product and its price.

i.   Devise the relational schema (specifying the relations, the attributes, the primary keys, and the foreign keys) of the above data warehouse using the star schema.

ii.   Write a SQL query to answer the following question: ”Which customer(s) made an order containing at least five products with different descriptions?”

iii.   Write a SQL query for the following report: ”W hich customer(s) made the largest order (i.e., those that would result in the largest bill)?”

iv.   Consider to add a new level product categories to the product dimension. Devise the new relational star schema, and write a SQL query for the following report: ”Select the total number of products sold per product category”.

9.            Design at least five queries for the created cube using MDX application.

10. Retrieve the cube data into the excel sheet and present the information in tabular and graphical form.