K2Questions Logo
MBA Common Subjects MBA Marketing MBA Finance MBA Human Resource MBA General Management MBA Systems MBA Operations

Study Database Management MBA Subject


STUDY - DATA BASE MANAGEMENT



Objective:
This course has been designed to introduce the participants with applications of systems designed to manage the data resources of organizations. It provides the participants an opportunity to study the hands-on implementation of a data base in corporate environment.

STUDY - File System and Databases:

Introducing the database – files and file systems – database systems – introduction to database models – data base models and internet. The Relational Database Model: A Logical view of data – keys – integrity rules – relational database operators – relationships within the relational database – data redundancy indexes.

STUDY - Entity Relationship Modeling:

Basic Modeling Concepts – degrees of data abstraction – entity relationship model – converting an E-R Model into a database structure. Normalization: Database tables and normalization – normalization and data base design
Higher level normal forms – Denormalization.

STUDY - Structured query language:

SELECT Statement – distinct clause – handling of null values – ORDER BY clause, WHERE clause – relational operators – logical operators (AND, OR, NOT), SQL Operators – (BETWEEN, AND, IN, LIKE) – numeric functions – string functions – date functions – conversion functions – GROUP BY clause – group functions – HAVING clause – joining tables – SET Operators (UNION, INTERSECTION, MINUS) – Sub queries.

STUDY - Distributed database management system:

Evolution – distributed processing and distributed databases – distributed database management systems – DDBMS Components – levels of data and process distribution.

STUDY - Client server systems:

Client/server systems – need – evolution – managerial expectations – client/server architecture styles – client/server implementation issues – backend database connection – to front end application like Visual Basic.

STUDY - Object oriented databases:

Object oriented concepts – features of an object oriented DBMS – How object orientation affects database design – Advantages and disadvantages of OODBMS. Web based databases

STUDY - Database security and administration:

Database security – access control – GRANT, REVOKE – GRANT, REVOKE on views and integrity constraint – data as a corporate asset – the evolution of database administration function – The DBA’s managerial role.





MBA Operations Subjects


Business Process Re engineering
System Analysis and Design
Data Base Management MBA PGDM Systems
Data Base Management
E Business E commerce MBA PGDM Systems
ERP Implementation MBA PGDM Systems
IT Project Management MBA PGDM Systems
Knowledge Management MBA PGDM Systems
Management Support System
Software Project Quality Management MBA PGDM Systems
Strategic Management of Information Technology

About us | SiteMap | Terms of use | Privacy Policy | Disclaimer | Contact us | ©2010 K2Questions.com

Page Description: Database Management MBA Subject, MBA Database Management, Class MBA Subject, Post Graduate Degree in management MBA Subject