Course

Unit 1

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 set- Relations and relationship sets- E-R Diagrams- Reducing E-R Diagrams into tables.

Unit 2

Relational DBMS Model: Basic concepts, Attributes and domains- Intention and extensions of relation- the 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.

Unit 3

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.

Unit 4

Database administration: Security and access control, Backup and recovery, Performance tuning, Maintenance and monitoring. Data integration and warehousing: NoSQL databases, Big data technologies, Cloud databases

Learning objective:

To introduce concepts of the database management system and make use of this in storing and retrieving biological data

Course Outcome:

CO1. To implement Oracle to create and design databases

CO2. To apply PL/SQL programming in building platforms for storing and retrieving biological data

Textbooks

1. “Database Management Systems” by Raghu Ramakrishnan and Johannes Gehrke, (3^rd edition), McGraw Hill Education
2. “ORACLE PL/SQL Programming” by Scott Urman (5^th edition), McGraw Hill Education.
3. “Insight into Data Mining – Theory and Practice” by K.P.Soman, Shyam Diwakar, V.Ajay, PHI, 2006.

References

1. “Database Systems Concepts” by Henry F Korth, Abraham Silberschatz, and S. Sudarshan (7^th edition), McGraw Hill Education.
2. “Database Management Systems” by Alexis Leon, Mathews Leon and Vikas Shukla, (3^rd edition) Vikas Publications
3. “Oracle 9i The Complete Reference” by Kevin Loney, George Koch,(1^st edition) Oracle Press