DATABASE MANAGEMENT SYSTEMS
Paper Code: ETCS-425
Paper: Database Management Systems
SYLLABUS
Objective: The concepts related to database, database techniques, SQL and database operations are introduced in this subject. This creates strong foundation for application data design.
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
PREVIOUS YEAR PAPERS:
|
AKASH PAPER |
CLICK BELOW TO DOWNLOAD PDF |
|
2014 |
|
|
2015 |
|
|
2016 |
|
|
2017 |
No comments:
Post a Comment