COURSE NAME: Database Management System & Administration
COURSE CODE: BIF411
PROGRAM: MSc Bioinformatics
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.