DETAILS:

COURSE NAME: Database Management System & Administration
COURSE CODE: BIF411
CREDIT: 3
SEMESTER: 2
PROGRAM: MSc Bioinformatics

SYLLABUS

Introduction to DBMS: Basic Concepts - Data Abstraction - Data models and data independence. Instances and Schemas.  Components of a DBMS and overall structure of a DBMS- Life Cycle of a DBMS application- Database terminology.Data Modeling: Basic concepts- Types of data models- Conceptual, physical and logical database models- E-R data model and Object-oriented data model. Components of ER Model- ER Modeling symbols.  Entity and entity sets- Relations and relationship sets- E-R Diagrams- Reducing E-R Diagrams into tables. Relational DBMS Model: Basic concepts, Attributes and domains- Intention and extensions of a relation- concept of integrity and referential constraints- Relational Query Languages (Relational algebra and relational calculus (Tuple and domain relational calculus). Relational Database Design: Notion of normalized relations- Normalization using Functional Dependency- First Normal form- Second Normal Form- Third Normal form- BCNF. SQL: Structure of a SQL query- DDL and DML, TCL- SQL queries and sub queries- Tables, views and indexes- Aggregate functions- Set Operations, predicates and joins, Set Membership- Tuple variables- Set comparison- Database modifications using SQL. . PL/SQL: Basic Concepts-SQL within PL/SQL- Cursors -Concept of stored procedures and functions-packages-Triggers.

TEXT BOOKS

  1. Database Management Systems : Raghu Ramakrishnan
  2. ORACLE PL/SQL Programming – Scott Urman BPB Publications.

REFERENCES

  1. Database Systems Concepts – Henry F Korth, Abraham Silberschatz.
  2. Database Management Systems – Alexis Leon, Mathews Leon – Leon, Vikas Publications
  3. Oracle 9i The Complete Reference – Kevin Loney, George Koch - Oracle Press