Understand database concepts and structures and query language
Understand the E R model and relational model
To design and build a simple database system and demonstrate competence with the fundamental tasks involved with modeling, designing, and implementing a DBMS.
Understand Functional Dependency and Functional Decomposition.
Apply various Normalization techniques
Perform PL/SQL programming using concept of Cursor Management, Error Handling, Package and Triggers
Execute various advance SQL queries related to Transaction Processing & Locking using concept of Concurrency control.
Understand query processing and techniques involved in query optimization.
Understand the principles of storage structure and recovery management.
Introduction and applications of DBMS, Purpose of data base, Data, Independence, Database System architecture- levels, Mappings, Database, users and DBA.
Entity Relationship Model
Basic Concepts , Constraints, Keys , Design Issues , Entity Relationship Diagram, Weak Entity Sets, Extended E-R Features , Design of an E-R Database Schema Reduction of an E-R Schema to Tables.
Structure of Relational Databases, The Relational Algebra, Extended Relational Algebra Operations, Modifications of the Database Views, The Tuple Relational Calculus , The Domain Relational Calculus.
Basics of SQL, DDL,DML,DCL, structure – creation, alteration, defining constraints – Primary key, foreign key, unique, not null, check, IN operator, Functions - aggregate functions, Built-in functions – numeric, date, string functions, set operations, sub-queries, correlated sub-queries, Use of group by, having, order by, join and its types, Exist, Any, All , view and its types. transaction control commands – Commit, Rollback, Savepoint.
Relational Database Design
First Normal Form, Pitfall of Relational-Database Condition, Functional Dependencies, Decomposition, Desirable Properties of Decomposition, Boyce-Codd Normal Form Third Normal Form.
Introduction, Cursors, Stored Procedures, Stored Functions, database Triggers.
Overview of Storage and Indexing
Data on External Storage – File Organization and Indexing – Cluster Indexes, Primary and Secondary Indexes – Index data Structures – Hash Based Indexing – Tree base Indexing.
Transaction concepts, properties of transactions, serializability of transactions, testing for serializability, System recovery, Two- Phase Commit protocol, Recovery and Atomicity, Log-based recovery, concurrent executions of transactions and related problems, Locking mechanism, solution to concurrency related problems, deadlock, , two-phase locking protocol, Isolation, Intent locking.
Introduction, Discretionary access control, Mandatory Access Control, Data Encryption.
Query Processing and Query Optimization
Overview, Measures of Query Cost
Database System Architecture
Centralized and Client-Server Architectures, Server System Architectures, Parallel Systems,
Case Study of DB2 Vs Oracle
Database System Concepts
An Introduction to Database Systems
SQI, PI/SQL The Programing Language of ORACLE
Basics of Information Management with DB2
Database Management Systems