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 Reference http://www.jamiahamdard.edu
|
No responses found. Be the first to respond...
|