9540796666
info@ibmedu.in

Information Technology

  • Our Courses

Information Technology

Issues

ELECTIVE- INFORMATION TECHNOLOGY

    Subjects:-

 Information Technology t- Paper 1st

 Database Management Systems- Paper 2nd

 Curriculum of Information Technology – Paper 1st    (IBM – E1009)

S.No.

Topics

 1

Fundamentals of Information System:-Information System, Meaning of Information Systems, Functions of an Information System,  Components of Information System, Benefits of Information System, Information System and Business, Information System Resources, Types of Information System.

2

Leadership Issues in IT Management:-What Is Leadership? , What Affects Leadership?, Who is Manager?  Manager vs Leader, Leadership in IT Organization.

3

The Strategic Role of IT Management:-Strategic Management and Information Technology, Strategic Uses of IT, Information as a Strategic Asset.

4

Information Systems Planning:-Information System Planning, Goal of Information System Planning, Strategic Information Systems Planning Methodologies, Phases of Organizational SISP Activities.

5

Distributed Systems Architecture:-Distributed Systems, Features of Distributed Systems, Advantages of Distributed Systems, Disadvantages of Distributes Systems, Distributes Systems Architecture, Security in Distributed Systems, Distributed Computing Environment.

6

Managing Information Resources I :Hardware and Software :-Information System, Information Technology, Computer, Computer Hardware, Computer Software.

7

Managing Information Resources II :Database And Telecommunication:-Data and Information, Data Processing, Concept of Database, Concept of DBMS, Data Warehousing, Data Mart, Data Mining, Telecommunication, Local Area Network (LAN), Wide Area Network (WAN), Internet, Data Transfer Mode, Wireless Technology.

8

Managing Operations:-Managing the Operations, Managing the Operations of Information Technology.

9

Managing System Development:-System Development, System Development Team, Project Manager, System Development Life Cycle.

10

Decision Support Systems and Executive Information Systems:-Concept of DSS, Characteristics and Objectives of DSS, Advantages and Limitations of Decision Support System, Levels of Decision Support System, Specific DSS, DSS Generator, DSS Tools, Comparison with EDP/MIS, Executive Information System.

11

Group Support Systems and Expert Systems:-Group Support Systems, Expert System.

12

Managing People and Technology:-Managing People, Managing Technology.

13

Creating a New Work Environment:-Concept of Work Environment, Types of Environment the Employee Needs in an Organization, Organizational Redesign, Concept of Learning Organization.

Curriculum of Database Management Systems- Paper 2nd    (IBM – E1010)

S.No.

Topics

1

Introduction to Database:-Database and its Hierarchies, History of Database, Types of DBMS.

2

Database Environment:-Database and DBMS Software, Database Architecture, Three Layered Architecture, Characteristics of Database Approach.

3

Relational Model:-Logical Data Models, Relational Data Model, Querying Relational Data.

4

SQL – Data Manipulation:-SQL Language, SQL Database Objects, SQL Data Types, DDL, DML and TCL Commands, Retrieving Data, Inserting Data, Updating Data, Deleting Data.

5

SQL – Data definition:-Creating and Altering Tables, Views, Sequence, Index.

6

Database Planning, Design and Administration:- Database Application Life-Cycle, Alternate System Development Methodologies, Database Planning, System Definition, Requirements Collections and Analysis, Database Design, DBMS Selection, Application Design, Database Administration.

7

Entity Relationship Modeling:-Database Design, Attributes and Entity Sets, Relationships and Relationship Sets, ER Diagrams, Additional Features of ER Model, Conceptual Database Design with the ER Model.

8

Normalization:-Database Designing Process, Anomalies in Databases, Good Database Designing, Normalization.

9

Conceptual and logical database design:-Conceptual Database Design, Logical Database Design.

10

Physical Database Design for Relational Model:-Physical Database Design.

11

Monitoring and Tuning the Operational Systems:-Proactive Database Monitoring, Database System Implementation, Database Tuning in Relational Systems.

12

Database Security:-Access Control, Discretionary Access Control, Mandatory Access Control, Additional Issues to Security.

13

Transaction Management:-Transaction, Commit and Rollback,. Concurrency, Locking.

14

Query Processing:-Query Execution, Query Execution Algorithms, Heuristics in Query Optimization, Heuristic Optimization of Query Trees.

15

Distributed Databases:-Distributed Database, Levels of Data and Process Distribution, Issues in Distribute Database Designing, Query Processing in Distributed Databases, Client-Server Database, Distributed Data Access, OBDC Connectivity.

16

Object-Oriented Database Management Systems:-Object-Oriented Database, Database Design of OODBMS, Structured Data Types and their Operations, Database Design of ORDBMS, Comparing RDMBS, OODBMS and ORDBMS.

 

M-12345