+- studentsuvidha (https://studentsuvidha.com/forum)
+-- Forum: Student Stuffs (https://studentsuvidha.com/forum/Forum-Student-Stuffs)
+--- Forum: Indraprastha University IPU notes and papers (https://studentsuvidha.com/forum/Forum-Indraprastha-University-IPU-notes-and-papers)
+---- Forum: IPU B.tech/ B.E. papers and Notes -free downloads (https://studentsuvidha.com/forum/Forum-IPU-B-tech-B-E-papers-and-Notes-free-downloads)
+----- Forum: IPU B.tech/ B.E. CIVIL papers and Notes -free downloads (https://studentsuvidha.com/forum/Forum-IPU-B-tech-B-E-CIVIL-papers-and-Notes-free-downloads)
+------ Forum: 7th semester IPU B.tech CIVIL papers and Notes -free downloads (https://studentsuvidha.com/forum/Forum-7th-semester-IPU-B-tech-CIVIL-papers-and-Notes-free-downloads)
+------ Thread: Database Management Systems IPU civil notes and question paper free download (/Thread-Database-Management-Systems-IPU-civil-notes-and-question-paper-free-download)
Database Management Systems IPU civil notes and question paper free download - Dipesh S - 04-25-2017
SYLLABUS:-
UNIT-I :
Introductory Concepts of DBMS: Introduction and application of DBMS, Data Independence, Database System Architecture – levels, Mapping, Database users and DBA, Entity – Relationship model, constraints, keys, Design issues, E-R Diagram, Extended E-R features- Generalization, Specialization, Aggregation, Translating E-R model into Relational model.
UNIT-II :
Relational Model: The relational Model, The catalog, Types, Keys, Relational Algebra, Fundamental operations, Additional Operations-, SQL fundamentals, DDL,DML,DCL PL/SQL Concepts, Cursors, Stored Procedures, Stored Functions, Database Integrity – Triggers.
UNIT-III:
Functional Dependencies, Non-loss Decomposition, First, Second, Third Normal Forms, Dependency Preservation, Boyce/Codd Normal Form, Multi-valued Dependencies and Fourth Normal Form, Join Dependencies and Fifth Normal Form.
UNIT-IV:
Transaction Management: ACID properties, serializability of Transaction, Testing for Serializability and concurrency control, Lock based concurrency control (2PL, Deadlocks), Time stamping methods, Database recovery management.
Implementation Techniques: Overview of Physical Storage Media, File Organization, Indexing and Hashing, B+ tree Index Files, Query Processing Overview, Catalog Information for Cost Estimation, Selection Operation, Sorting, Join Operation, Materialized views, Database Tuning.