Subject Syllabus
CY-405 - Database Management System
CSCY • SEMESTER-4
Course Modules
Learn topic-wise with Hyper AI and revise using mapped PYQs.
Basic Concepts of Data and DBMSFile organization and access methodsIntroduction to DBMSDifference between DBMS and traditional file storage systemCharacteristics of DBMSData Models, Schemas and InstancesDBMS architectureComponents of DBMSData IndependenceStudy of Entity Relationship ModelType of attributesEntity typesRelationship and CardinalitiesParticipation, Roles and constraints
Relational Data Model: Domains, Tuples, Attributes, Relationskeys and types of keysIntegrity ConstraintsRelational Algebra: Queries using Select operation, project operation, renaming, joins, union, intersection, difference, division, and product etc.SQL –basic SQL queries, functions, constraints, joins and nested queriesTriggers, assertions, views and stored procedures and PL/SQL
Transaction Processing: States of transaction and desirable propertiesIntroduction to Concurrency and RecoverySchedules, Recoverability & Serializabilitytypes of serializability and test for serializabilityConcurrency Control: Two phase locking, Timestamp Based concurrency controlDeadlocks: Avoidance, Prevention , detection & resolutionRecovery: Basic concepts, techniques based on deferred update and immediate updateShadow paging, check points