DESCRIPTION OF COURSES
BI-506/ CA 566 DATABASE MANAGEMENT SYSTEM (2L+2P) II
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.
Database system - Operational Data, Characteristics of database approach, architecture.
Overview of DBMS; Data associations - Entities, Attributes and Associations, Relationship among Entities, Representation of Associations and Relationship, Data Model classification.
Entity Relationship model; Relational Data Structure- Relations, Domains and Attributes, Relational Algebra and Operations, Retrieval Operations.
Relational Database Design - Anomalies in a Database, Normalization Theory, and Normal forms; Query processing and optimization; Security, backup and recovery.
Distributed Databases- concepts, architecture, design; Object Oriented databases; Structured Query Language (SQL) - Data Definition Language (DDL), Data Manipulation Language (DML), Query by example.
PL/SQL - Stored procedure, Database triggers; Relational Data Base Management Package.
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.