{"product_id":"9789355851642","title":"Database Design and Management for BE Anna University R21CBCS (III- AI \u0026 DS- AD3391)","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":47489223524644,"sku":"9789355851642","price":260.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0671\/3661\/8788\/files\/9789355851642_1.jpg?v=1699012683","url":"https:\/\/bookstation.in\/mr\/products\/9789355851642","provider":"BookStation","version":"1.0","type":"link"}