MBA AREA-5: INFORMATION TECHNOLOGY-
BA 691 DATABASE MANAGEMENT SYSTEM
Unit 1:
Overview and Fundamentals, Database oriented approach to Data Management; History of Database Applications; DBMS Architectures; Data
Dictionary, Data Models, Data Definitions, Data Modification Models.
Unit 2:
Entity Relational Model: Design and Construction, ER diagram conversion to relational model; Relational Model, Basic Relational Algebra, Basic Relational Calculus.
Unit 3:
Query Languages: SQL, SQL Constructs, Query Compositions, Transaction Processing, Embedded SQL Integrity Constraints.
Unit 4:
Normalization, Level of Normalization and their use, Dependencies, Keys, Concepts of Keys; Indexing and Hashing, Tables Clustering.
Unit 5:
Concurrency Control Techniques, Concurrency Control Based on Timestamp Ordering; Database Security Concepts; Levels of security; Database Recovery Techniques; Recovery Techniques Based on Deferred Update, Recovery Techniques Based on Immediate Update; Recent trends in Database Management.
Unit 6:
Design and Implementation of a Small Database, along with use of Queries.
Text Books:
- Elmasri, R, Navathe, S; Fundamentals Of Database Systems, 6/E; Pearsons; 2011
- Abraham Silberschatz, Henry Korth, S. Sudarshan; Database System Concepts; 6/e; Tata McGraw Hill; 2011
References:
- Narang Rajesh: Database Management Systems, Prentice Hall of India Private Limited, New Delhi, 2/e, 2006.
- Connolly: Database Systems: A Practical Approach to Design, Implementation and Management, Pearson Education (Singapore) Pvt. Ltd., Delhi, 4/e, 2008.
BA 692 OBJECT ORIENTED ANALYSIS AND DESIGN
Unit 1: Keys Concepts of Object-Oriented Programming
Concepts of Structured Programming and Object-Oriented Programming Paradigms, Data Abstraction, Information Hiding, Class, Object, Constructors, Destructors, Members Functions, Friend Functions, Templates, Exception Handling.
Unit 2: Inheritance
Concept of Inheritance, Single inheritance, Multiple Inheritance, Multilevel Inheritance and Hybrid Inheritance, Virtual Bass Class.
Unit 3: Polymorphism
Compile time Polymorphism: Operator Overloading, Function Overloading, Static Binding. Run-Time Polymorphism: Virtual Functions, Pure Virtual Functions, Abstract Class, Dynamics Binding.
Unit 4: Object Oriented Design
Object Oriented Design Approaches: Object Model, Dynamic Model, and Functional Model. (Object Diagram, State Diagram, and Data Flow Diagram). Phases of Object-Oriented Development: Object Analysis, System Design, Object Design.
Text books:
- Balaguruswamy, E. Object Oriented Programming with C++, Tata McGraw Hill, New Delhi, 2001.
- Balaguruswamy, E. Programming with Java – A Primer, Tata McGraw Hill, New Delhi, 1998.
- Rumbaugh, J., Blaha, M., Premerlani, W., Eddy, F. & Lorensen, W. ObjectOriented Modelling and Design, Prentice Hall of India Private Ltd., New Delhi, 1997
Reference Books:
- Farewell, J. Java for Beginners, Cengage Learning, New Delhi, 2000.
- Bhave, M. & Patekar, S. Object Oriented Programming with C++, 2/e, Pearson Education, New Delhi, 2012.
- Schild, H. The Complete Reference to Java, MacGraw Hill, New York, 2002.
BA 693 SOFTWARE ENGINEERING
Unit 1: Basic Concepts of Software Engineering
Introduction to software engineering, concept of a software project, size factor, quality and productivity factor, different phases of a software development life cycle, managerial issues.
Unit 2: Software project planning
Problem definition, development of a solution strategy, development process planning, software development models and their comparative study,
Organizational structure planning, project formats and team structures, Planning for quality assurance and configuration Management, Planning for
verification and validation. Cost estimation and evaluation techniques, cost estimation based on COCOMO model and Raleigh model. Software
requirements analysis and specifications techniques- their notations & languages.
Unit 3: Software design and implementation
Concept of fundamental design, Design approaches- top-down & bottom-up, structured, object-based & object-oriented design, Design specification and notations. Structured coding techniques, coding styles, and standards, Guidelines for coding and documentation.
Unit 4: Software verification, validation and reliability
Theoretical foundation, black box and white box approaches, Integration and system testing. Definition and concept of reliability, software faults, errors, repair and availability, reliability and availability models.
Text books:
Reference Books:
- Shooman, M, L. Software Engineering: design, reliability, and management McGraw Hill, New York, 1983.
- Fairley, R.E. Software Engineering Concepts, McGraw Hill, New York, 1985.
BA 694 WEB DESIGNING
Unit 1: Client/Server Computing
Introduction to Client Server Computing: What is C/S Computing, Middleware, Fat client VS Fat Servers, N-tiered Software Architecture. Web Browser: Browser Architecture, Configuration of Netscape and Internet Explorer Web Server Architecture: Web Server Architecture, Server Features, Configuration of Apache and IIS.
Unit 2: HTML Basics
Document Basics, Tables, Hyperlink, Images, Formatting Techniques, Embedding Multimedia Objects, Background Sound, Frames, Using Cascading Style Sheets.
Unit 3: PHP
Introduction to PHP, Control Flow in PHP, Arrays in PHP, Loops in PHP, Functions in PHP, Object Oriented Programming using PHP, Database
Connectivity using PHP.
Unit 4: JavaScript
Introduction to JavaScript, Functions in JavaScript, For Loop in JavaScript, While Loops in JavaScript, Control Flow in JavaScript, Introduction to Object I and II in JavaScript.
Text book:
- Zakour, J., Foust, J. & Kerven, D. HTML 4 How-To, Techmedia, New Delhi 1998
Reference Books:
- Jaworski, J. Javascript and Jscript, BPB Publication, New Delhi, 1999.
- Gilmore, W.J. & Bryla, B. Beginning PHP and ORACLE: From Novice to Professional, Berkley, Apress, C.A., 2007.
- Croft, B. A., Darnell, R. & Powers, S. Dynamic Web Publishing Unleashed (2nd Edition), New Delhi: Techmedia, 1997.
BA 695 OPERATING SYSTEM
Unit 1: Introduction to Operating System
Features of an Operating System, Operating Systems Concepts: Single User Vs Multiple Users, Multiprogramming, Time Sharing, Multitasking.
Unit 2: Process and Memory Management
Process Management: Process states, process control block, process scheduling algorithms, Mutual exclusion, Inter-process communication issues.
Memory Management: Contiguous and non-contiguous allocation, virtual memory, segmentation, paging, page scheduling and replacement algorithms.
Unit 3: I/O Management, File System and Deadlock and Recovery I/O management I/O overview, disk scheduling algorithms. File System: Management, protection mechanisms. Deadlock and Recovery: Introduction to Deadlocks, Deadlock Detection and Recovery, Deadlock Avoidance, Deadlock Prevention.
Unit 4: UNIX Operating System Concepts
Overview of UNIX Architecture – Structure of UNIX System, User Commands, File Handling, Shell Programming, System Commands, Utilities.
Text book:
Reference Books:
- Das, S. UNIX Concept & Application (Fourth Edition), Tata McGraw Hill, New Delhi, 2006.
- Stephens, W.R. Advanced Programming in the UNIX Environment, AddisonWesley, New Delhi, 1992.
BA 696 NETWORKING AND COMMUNICATION
Unit 1: Basics concepts of Networking
Definition, Classification, Network Structure, Connection-Oriented vs Connectionless Service, ISOOSI reference Model, TCP/IP reference model
Unit 2: Physical Layer
Concepts of data transmission, Transmission media like Coaxial cable, Twisted Pair, Optical Fibre, Wireless Transmission, Communication satellites, digital modulation and multiplexing methods, modem, standard protocols like RS232C, RS-449, X.21.
Unit 3: Medium Access Control and Data link Layers
Medium Access Control: Broadcast Networks: ALOHA, CSMA, CSMA/CD, token ring, token bus, Standard LAN Protocols (IEEE 802.X), FDDI, satellite networks. Data link layer: Framing, error control techniques, data link protocols and their performance, SDLC protocol.
Unit 4: Network and Transport layer
Network Layer: Routing, Congestion and deadlock control Algorithms, Internetworking issues and devices, gateways, bridges and routers, IP & X.25
protocols. Transport Layer: Connection management, Quality of Service, TCP/IP Protocol, ATM.
Unit 5: Session and Presentation Management
Session Management: Session establishment and maintenance, Dialogue management, Recovery. Presentation Management: Data Compression,
Lossless Compression Algorithms- Run length encoding, DPCM, Dictionarybased methods, Image compression- JPEG, Video compression- MPEG; Security and authentication techniques, Encryption algorithms.
Unit 6: Applications and Network Administration
Applications: Telnet, Remote login, File transfer, Network file system, Network management. Network Administration: UNIX network programming with TCP/IP, Network File System, and Windows NT installation, configuration and use.
Text books:
- Tanenbaum: A. S. Computer Networks, Prentice Hall of India Private Limited, New Delhi, 2003.
- Stephens, W.R. Advanced Programming in the UNIX Environment, AddisonWesley, New Delhi, 1992.
Reference Books:
- Stalling, W. Data & Computer Communication, Pearson Education, New Delhi, 2004.
- Forouzan, B.A. Data Communication and Networking (Third Edition), Tata McGraw Hill, New Delhi, 2004
BA 697 DATA MINING
Unit 1: Data Mining Basics
Definition, Knowledge Discovery in Databases vs Data Mining, Database Management System vs Data Mining, Application of Data Mining, Data Mining Technique, Issues and Challenges of Data Mining.
Unit 2: Association Rule Mining Techniques
A Priori Algorithm, Partition Algorithm, Pincer-Search Algorithm, Dynamic Itemset Counting Algorithm, FP-tree Growth Algorithm, Other Algorithms.
Unit 3: Clustering Techniques
Partitioning Algorithms, k-Medico Algorithm, Hierarchical Clustering, Other Clustering Techniques.
Unit 4: Other Techniques
Decision Tree Techniques, Neural Network, Genetic Algorithm, Rough Sets.
Unit 5: Web Mining
Definition, Web Content Mining, Web Structure Mining, Text Mining.
Unit 6: Mining of Complex Types of Data
Mining of Spatial Databases, Multimedia Databases, Time-series Analysis.
Text book:
Reference Books: