AKTU Basics of Database Management System (BOE307 / BOE407) Syllabus PDF – B.Tech Open Elective

Course Outcome ( CO) Bloom’s Level (KL) At the end of course , the student will be able to understand CO 1 Acquire knowledge of database design methodology for real-life applications. Understanding CO 2 Design an information model using the concept of ER diagram. Create CO 3 Apply the concept of SQL on real-life databases. Apply CO 4 Analyze the redundancy problem in the database and reduce it using normalization. Analyze CO 5 Identify the broad range of database management issues including data integrity, security, and Analyze recovery transactions, as well as enforce entity integrity, referential integrity, key constraints, and domain constraints on the database.

Course Content

Unit Topic Lecture I Introduction to Database System: Database System vs File System, Database System Concept 08 and Architecture, Data Model Schema and Instances, Data Independence and its Types, Overall Database Structure.

Entity Relationship Model: ER Model Concepts, Notation for ER Diagram, Mapping Constraints, Key attribute, Generalization, Aggregation, Reduction of an ER Diagrams to Tables.

II Relational data Model: Relational Data Model Concepts, type of keys, Integrity Constraints- 08 Entity integrity and referential integrity, Keys Constraints, Domain Constraints, Relational Algebra-Unary Relational Operations- SELECT and PROJECT, Binary Relational Operations- CROSS, JOIN and DIVISION, Queries in Relational Algebra.

III Database Implementation using SQL: Introduction to SQL, Characteristics of SQL, SQL Data 08 Types, Basic Queries in SQL- create, select Insert, Delete and Update Statements, concepts of group by and having, order by, Sub Queries, Aggregate Functions, Joins, Unions, Intersection, Minus, Views.

IV Database Design and Normalization: Functional Dependencies, Inference rules, Closure of 08 attributes, FD equivalence and Minimal cover.

Normalization: Normal forms, first, second, third normal forms, and BCNF. Lossless join decompositions, Dependency Preservation, Multi-valued Dependencies and Fourth Normal Form, Join Dependencies and Fifth Normal Form.

V Transaction processing: Transaction and its States, ACID property, Transaction Scheduling, 08 Serializability of scheduling, Conflict, and View Serializability Concurrency Control Techniques: Concurrency Control, Locking Techniques for Concurrency Control, Two-phase locking techniques for concurrency control, Time Stamping Protocols for Concurrency Control

Text Books

1. Elmasri, Navathe, “ Fundamentals of Database Systems”, Addision Wesley
2. Korth, Silbertz, Sudarshan,” Database Concepts”, McGraw Hill
3. Date C J, “An Introduction to Database Systems”, Addision Wesley Reference Books
4. Bipin C. Desai, “An Introduction to Database Systems”, Gagotia Publications 8. Majumdar & Bhattacharya, “Database Management System”, TMH
5. RAMAKRISHNAN"Database Management Systems", McGraw Hill