Subject Syllabus
AD-402 - Database Management System
AIDS · Semester 4
Course Modules
Learn topic-wise with Hyper AI and revise using mapped PYQs.
IntroductionDatabase approach v/s Traditional file accessing approachAdvantages of database systemsData models, Schemas and instancesData independenceData Base Language and interfacesOverall Database StructureFunctions of DBA and designerER data model: Entitles and attributes, Entity typesDefining the E-R diagramConcept of Generalization, Aggregation and SpecializationTransforming ER diagram into the tablesObject oriented data Model, Network data model, and Relational data modelComparison between the three types of models
Domains, Tuples, Attributes, RelationsCharacteristics of relationsKeys, Key attributes of relationRelational database, Schemas, Integrity constraintsReferential integrity, Intension and ExtensionRelational Query languages: SQL-DDL, DML, integrity constraintsComplex queries, various joins, indexing, triggers, assertionsRelational algebra and relational calculusRelational algebra operations like select, Project, Join, Division, outer unionTypes of relational calculus i.e. Tuple oriented and domain oriented relational calculus and its operations
Introduction to normalizationNormal formsFunctional dependencyDecompositionDependency preservation and lossless joinProblems with null valued and dangling tuplesMultivalued dependenciesQuery Optimization: Introduction, steps of optimizationVarious algorithms to implement select, project and join operations of relational algebraOptimization methods: heuristic based, cost estimation based
Transaction SystemTesting of SerializabilitySerializability of schedules, conflict & view serializable scheduleRecoverability, Recovery from transaction failuresLog based recovery, Checkpoints, deadlock handlingConcurrency Control Techniques: locking Techniques for concurrency controlTime stamping protocols for concurrency control, validation based protocol, multiple granularityMulti version schemes, Recovery with concurrent transactionIntroduction to Distributed databases, data mining, data warehousingObject Technology and DBMS, Comparative study of OODBMS Vs DBMSTemporal, Deductive, Multimedia, Web & Mobile database
Architecture, physical files, memory structures, background processConcept of table spaces, segments, extents and blockDedicated server, multi threaded serverDistributed database, database links, and snapshotData dictionary, dynamic performance viewSecurity, role management, privilege management, profiles, invoker defined security modelSQL queries, Data extraction from single, multiple tables equi-join, non equi-join, self-join, outer joinUsage of like, any, all, exists, in Special operatorsHierarchical queries, inline queries, flashback queriesIntroduction of ANSI SQL, anonymous block, nested anonymous block, branching and looping constructs in ANSI SQLCursor management: nested and parameterized cursors, Oracle exception handling mechanismStored procedures, in, out, in out type parameters, usage of parameters in proceduresUser defined functions their limitationsTriggers, mutating errors, instead of triggersIntroduction to NoSql Database