{"product_id":"9789355851642-2","title":"Database Design and Management (Engineering Reference Books)","description":"\u003cp\u003eSyllabus Database Design and Management - (AD3391)  UNIT I \tCONCEPTUAL DATA MODELING Database environment - Database system development lifecycle - Requirements collection - Database design - Entity-Relationship model - Enhanced-ER model - UML class diagrams.  (Chapter - 1) UNIT II \tRELATIONAL MODEL AND SQL Relational model concepts - Integrity constraints - SQL Data manipulation - SQL Data definition - Views - SQL programming. (Chapter - 2) UNIT III\tRELATIONAL DATABASE DESIGN AND NORMALIZATION ER and EER-to-Relational mapping - Update anomalies - Functional dependencies - Inference rules - Minimal cover - Properties of relational decomposition - Normalization (upto BCNF).  (Chapter - 3) UNIT IV \tTRANSACTION MANAGEMENT Transaction concepts - properties - Schedules - Serializability - Concurrency Control - Two-phase locking techniques. (Chapter - 4) UNIT V \tOBJECT RELATIONAL AND NO-SQL DATABASES Mapping EER to ODB schema - Object identifier - reference types - rowtypes - UDTs - Subtypes and supertypes - user-defined routines - Collection types - Object Query Language; No-SQL: CAP theorem - Document-based: MongoDB data model and CRUD operations; Column-based: Hbase data model and CRUD operations. (Chapter - 5)\u003c\/p\u003e","brand":"Technical Publications","offers":[{"title":"Default Title","offer_id":47572157628587,"sku":"12733158398","price":425.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0620\/3355\/9723\/files\/9789355851642_2_02a22bdd-1dd1-411c-ad8b-de4fe16e3e75.jpg?v=1786014982","url":"https:\/\/technicalpublications.in\/products\/9789355851642-2","provider":"Technical Publications","version":"1.0","type":"link"}