Syllabus Database Management System - (BE03000091) Total Credits = TH/30 Assessment Pattern and Marks Total Marks Theory Tutorial / Practical ESE(E) PA(M) PA/(I) TW/SL (I) ESE (V) 04 70 30 20 30 50 200 Unit No. Content 1. Introductory concepts of DBMS Purpose of database system, View of data, Database Languages, Relational Databases, Database Architecture, Database users, DBA. (Chapter - 1) 2. Relational Model Structure of relational databases, Database Schema, Keys, Schema Diagrams, Relational algebra operators, relational algebra queries. (Chapter - 2) 3. Introduction to SQL Overview of SQL Query Language, Basic structure of SQL Queries, DDL, DML, Additional Basic Operations, defining constraints - Primary key, foreign key, unique, not null, check, Set operations, Null values, Aggregate functions, Built-in functions -numeric, date, string functions, nested sub-queries, Modification of the Database, DCL and TCL. (Chapter - 3) 4. Entity-Relationship Model Design process, E-R Model, constraints, Removing redundant attributes in Entity Sets, E-R diagrams, Reduction of E-R database schema to Relational schema, Design issues. (Chapter - 4) 5. Relational Database Design Features of good relational designs, Dependency preservation, Functional Dependency-definition, Trivial and Non-Trivial FD, Closure of FD set, Closure of attributes, Irreducible set of FD, Decomposition using FD, Normalization-1Nf, 2NF, 3NF, BCNF, Multivalued dependency, 4NF. (Chapter - 5) 6. Transaction Management Transactions : Transaction concepts, transaction model, ACID Properties of transactions : Serializability of transactions, testing for serializability, Concurrency Control : Lock based protocols, deadlock handling, Timestamp protocols, Recovery System : Types of failure, Storage, Recovery and atomicity, Recovery Algorithms. (Chapter - 6) 7. Query Processing & Optimization Overview, measures of query cost, selection and join operation, evaluation of expressions. Transformation of relational expressions, estimating statistics of expression results, evaluation plans, materialized views. (Chapter - 7) 8. Database Security Security-Security and Authentication, authorization in SQL, access control, DAC, MAC and RBAC models, Intrusion detection, SQL injection. (Chapter - 8) 9. Indexing and Hashing Basic Concepts, Ordered Indices, B+-Tree Index Files, Multiple-Key Access, Static Hashing, Dynamic Hashing, Comparison of Ordered Indexing and Hashing, Bitmap Indices, Index Definition in SQL (Chapter - 9) 10. PL/SQL Concepts Cursors, Stored Procedures and Database Triggers. (Chapter - 10)
