{"id":1226,"date":"2022-01-28T21:39:33","date_gmt":"2022-01-28T21:39:33","guid":{"rendered":"https:\/\/itgeeks.in\/home\/?p=1226"},"modified":"2022-01-28T21:39:34","modified_gmt":"2022-01-28T21:39:34","slug":"2k6it-504-database-management-systems%ef%bf%bc","status":"publish","type":"post","link":"https:\/\/itgeeks.in\/home\/?p=1226","title":{"rendered":"2K6IT 504: DATABASE MANAGEMENT SYSTEMS\ufffc"},"content":{"rendered":"\n

Module I (12 hours)<\/strong>
Introduction – Characteristics of Database approach – Advantages of using DBMS approach – Data models – schemas and instances – Three-schema architecture and data independence – Database languages and interfaces – The database system environment – Centralized and client-server architectures – Classification of Database Management systems. Entity-Relationship Model – Entity Types, Entity Sets, Attributes and Keys – Relationship types, Relationship Sets, Roles and Structural Constraints – Weak Entity Types – Refining the ER Design – ER Diagrams and Naming Conventions – Example of Other Notation: UML Class Diagrams
Module II (16 hours)<\/strong>
Relational Model and Relational Algebra – Relational Model Concepts – Constraints – Relational Database Schemas \u2013 Relational Algebra: Unary Operations – Set Theoretic operations – Binary Operations – Aggregate functions and grouping \u2013 Outer Join and Outer Union – Examples of Queries – The Tuple Relational Calculus – The Domain Relational Calculus SQL – Data Definition and Data Types – Specifying constraints – Schema change statements – Basic queries \u2013 Aggregate functions and grouping – Insert, Delete and Update statements – Assertions and Triggers – Views Database Design – Informal Design Guidelines for Relation Schemas – Functional Dependencies – Normal Forms Based on Primary Keys (Up to BCNF) – Properties of Relational Decompositions – Algorithms for Relational Database Schema Design – The Database Design and Implementation Process – Use of UML Diagrams in database design.
Module III (12 hours)<\/strong>
Disk Storage, Basic File Structures, and Hashing – Secondary Storage Devices \u2013 Placing File Records on Disk – Operations on Files – Heap Files – Sorted Files – Hashing Techniques – Parallelizing Disk Access Using RAID Technology – New Storage Systems Indexing Structures for Files – Types of Single-Level Ordered Indexes – Multilevel Indexes – Dynamic Multilevel Indexes Using B-Trees and B+ Trees – Indexes on Multiple Keys
Module IV (14 hours)<\/strong>
Transaction Management – Transaction and System Concepts \u2013 ACID Properties – Schedules – Characterizing Schedules Based on Recoverability and Serializability – Transaction Support in SQL Concurrency Control Techniques – Locking Techniques – Timestamp Ordering – Multiversion Concurrency Control – Optimistic Concurrency Control – Using Locks for Concurrency Control in Indexes Database Recovery Techniques – Recovery Concepts – Recovery Techniques Based on Deferred and Immediate Updates – Shadow Paging – Recovery in Multidatabase Systems – Backup and Recovery from Catastrophic Failures<\/p>\n\n\n\n

Text books<\/strong>
R. Elmasri and S. B. Navathe: Fundamentals of Database Systems, 5th Edition, Addison-Wesley, 2007<\/a><\/p>\n\n\n\n

Reference books<\/strong>
1.\u00a0A. Silberschatz, H. F. Korth and S. Sudarshan: Database System Concepts, 5\/E, Mc-Graw Hill, 2006.<\/a>
2.\u00a0Database systems, a practical approach to design implementation and management \u2013 Thomas Connolly and Carolyn Begg, Pearson Education,<\/a>
3.\u00a0Raghu Ramakrishnan and Johannes Gehrke: Database Management Systems, McGraw-Hill<\/a>
4. C.J. Date, A. Kannan, S. Swamynatham: An Introduction to Database Systems, Pearson education<\/a>
5. Jeffrey D Ullman: Principles of Database Systems, Galgotia Publications<\/a>\u00a0\u00a0<\/p>\n\n\n\n

\n
S5 Question Papers<\/a><\/div>\n\n\n\n
Notes<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Module I (12 hours)Introduction – Characteristics of Database approach – Advantages of using DBMS approach – Data models – schemas<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49,20,9,8],"tags":[7],"class_list":["post-1226","post","type-post","status-publish","format-standard","hentry","category-ku-s5-it","category-ku-syb-s5","category-ku-syllabus","category-syllabus","tag-kannur-university"],"_links":{"self":[{"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=\/wp\/v2\/posts\/1226","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1226"}],"version-history":[{"count":1,"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=\/wp\/v2\/posts\/1226\/revisions"}],"predecessor-version":[{"id":1235,"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=\/wp\/v2\/posts\/1226\/revisions\/1235"}],"wp:attachment":[{"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itgeeks.in\/home\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}