DESCRIPTION OF COURSES

Close

BI-506/ CA 566 DATABASE MANAGEMENT SYSTEM                                                                                 (2L+2P) II
(Pre-requisite: CA-561)

Objective
  Database systems are backbone of any information system, enterprise resource planning, research activities and other activity that require permanence of data storage. This course provides the basic introduction to database system technologies; design, concurrency, security and backup/recovery issues of database management systems. The major focus in this course is the relational database model.

Theory

UNIT I
  Database system - Operational Data, Characteristics of database approach, architecture.

UNIT II
  Overview of DBMS; Data associations - Entities, Attributes and Associations, Relationship among Entities, Representation of Associations and Relationship, Data Model classification.

UNIT III
  Entity Relationship model; Relational Data Structure- Relations, Domains and Attributes, Relational Algebra and Operations, Retrieval Operations.

UNIT IV
  Relational Database Design - Anomalies in a Database, Normalization Theory, and Normal forms; Query processing and optimization; Security, backup and recovery.

UNIT V
  Distributed Databases- concepts, architecture, design; Object Oriented databases; Structured Query Language (SQL) - Data Definition Language (DDL), Data Manipulation Language (DML), Query by example.

UNIT VI
  PL/SQL - Stored procedure, Database triggers; Relational Data Base Management Package.

Practical
  E-R diagram construction; SQL - Command Syntax, Data types, DDL Statements, DML Statements, integrity constraints; Triggers, creating stored procedures/ functions; Normalization of database and Case study on a database design and implementation.

Suggested Readings