{"product_id":"9789355859099-2","title":"Database Management System  for GTU 24 Course (III - CE\/CSE\/IT\/CSE(AI\u0026ML)\/I\u0026CT\/AI\u0026DS\/AI\u0026ML - BE03000091)","description":"\u003cp\u003eSyllabus Database Management System - (BE03000091) Total Credits = TH\/30\tAssessment Pattern and Marks\tTotal Marks \tTheory\tTutorial \/ Practical\t \tESE(E)\tPA(M)\tPA\/(I)\tTW\/SL (I)\tESE (V)\t 04\t70\t30\t20\t30\t50\t200  Unit No.\tContent 1.\tIntroductory concepts of DBMS Purpose of database system, View of data, Database Languages, Relational Databases, Database Architecture, Database users, DBA.  (Chapter - 1) 2.\tRelational Model Structure of relational databases, Database Schema, Keys, Schema Diagrams, Relational algebra operators, relational algebra queries.  (Chapter - 2) 3.\tIntroduction 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.\tEntity-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.\tRelational 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.\tTransaction 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.\tQuery Processing \u0026amp; 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.\tDatabase Security Security-Security and Authentication, authorization in SQL, access control, DAC, MAC and RBAC models, Intrusion detection, SQL injection.  (Chapter - 8) 9.\tIndexing 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.\tPL\/SQL Concepts Cursors, Stored Procedures and Database Triggers.  (Chapter - 10)\u003c\/p\u003e","brand":"Technical Publications","offers":[{"title":"Default Title","offer_id":46822119669931,"sku":"11949091117","price":550.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0620\/3355\/9723\/files\/9789355859099_2_602a0dc3-3421-4a63-8f71-58b58aff1fb1.jpg?v=1779520684","url":"https:\/\/technicalpublications.in\/products\/9789355859099-2","provider":"Technical Publications","version":"1.0","type":"link"}