MBA - 323 : DATA BASE AND INFORMATION MANAGEMENT SYSTEMS-Jamia Hamdard

MBA - 323 : DATA BASE AND INFORMATION MANAGEMENT SYSTEMS

UNIT I :- Data Base Concepts :
What is Database ? Need of Database, Function of the Database ; Types Database ; Relational Database Management System, Relational Model - Key Concept ; Integrity Constraints ; Foreign Key.

UNIT II :- Database Development Process, Database Modeling & Database Design.
Information Engineering Methodology, Planning, Analysis , Design and Implementation , E- R. Model, Attributes, Relationship, Logical database design , Normalization , First form, Second Normal Form , Third Normal form, Translating E-R Diagram to Relations. Physical Database Design.

UNIT III :- Relational Algebra & SQL Relational database commands.
Data-types, create table, Drop Table, Alter Table, Insert Into, Delete From, Update, General Query Syntax ( Select ), Create View , Drop View , Set Operators - Union, Intersect, Minus, Functions, Group Functions , Join.

UNIT IV :- Data Administration, Client / Server and Distributed Databases
Data administration functions, Data administration tools - Repositories, CASE Tools, Concurrency Control, Database Security , Database Recovery. Client / Server Architecture, Functions of Client / Server, Advantages, Issues. Distributed Databases, Objectives, Distributed DBMS, Location transparency, Replication Transparency, Failure transparency, Commit protocol, Concurrency transparency.

UNIT- V :- Database Applications
Financial Systems, Marketing System, foreign Trade, Inventory Information systems.

SUGGESTED READINGS :

Modern Database Management 4th Edition - Mcfadden

Database Systems - Design Implantation and Management - Rob & Coronal

Database Systems - Elmsari, Nawathe

Database Systems - C. J. Date

Post Comment:

Notify me by email when others post comments to this article.

Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.

No HTML formatting and links to other web sites are allowed.

This is a strictly moderated site. Absolutely no spam allowed.

Name:	Sign In to fill automatically.
Email:	(Will not be published, but required to validate comment)
	Type the numbers and letters shown on the left.