Database Management System syllabus

Basic concepts, Advantages of DBMS over file processing systems, Data abstraction and Data independence, Database languages, Components of a DBMS and Overall structure of DBMS, Multi-user DBMS architecture, Data Modeling: Basic concepts, entity, attributes, relationships, relations, constraints, keys, Data models. ER and EER diagrams: Components of ER model, Conventions, Converting ER diagrams into tables, EER Model components, converting EER diagram into tables. Exempla 1. Library Management System: Exemplar rs/Case · Students understand basic DBMS concepts Studies · They apply E-R model concepts to represent book and user data. · Sample Activity: Create an ER diagram and relational schema for the system. 2. Online Retail Store (e.g., Amazon):

Case Study · Students analyze how DBMS supports operations like search, filters, and checkout.

Relational Model: Relational Model Concepts (Domains, Attributes, Tuples, and Relations), Relational Model Constraints, Relational Database Schemas, Codd’s rules. Database design: Features of good relational database design, Purpose of Normalization, Data Redundancy and Data Anomalies, Functional Dependencies, Normal Forms (1NF, 2NF, 3NF, BCNF). Exemplar Student/Timetable/ Reservation any Data Management System s/

Case Studies

Introduction to SQL, Basic Data Types and SQL Syntax, Data Definition Language (DDL), Constraints, Data Manipulation Language (DML), Clauses with SELECT statement: WHERE, ORDER BY, Pattern Matching with LIKE, IN, BETWEEN, Aggregate functions with GROUP BY` and HAVING, Joins, Sub-queries, Set Operations, Views, Index. Introduction to PL/SQL: Overview of PL/SQL architecture, control structures, Cursors, PL/SQL Advanced Features: Procedures and Functions, Triggers.

Transaction Management: Introduction to Database Transaction, Transaction states, ACID Properties, Concept of Schedule: Serial and concurrent Schedule. Serializability: Conflict and View, Cascaded Schedules, Recoverable Schedules. Concurrency Control and Recovery Management: Need for Concurrency Control, Lock-based protocols, Time stamp based protocol, Validation-based protocol, Multiple Granularity, Deadlock. Recovery Techniques: Shadow-Paging, Log-based Recovery, Check Point.

Needs, Challenges with traditional databases, Need for scalability, flexibility, and speed. NoSQL Databases: Definition and types: Document, Key-Value, Column, Graph; Example using MongoDB. Cloud Databases: What is DBaaS (Database-as-a-Service), Examples: AWS/Google Firebase; Benefits: scalability, cost, easy setup. Introduction to Modern Database: Big Data and Hadoop: Basics of Big Data, Introduction to Hadoop and HDFS, Real-world examples (e.g., social media, online shopping), Simple explanation of how they store relationships. AI/ML with Databases: Basic idea of machine learning inside databases, Real-world applications: recommendations, fraud detection. Exemplar · Short quiz on types of NoSQL databases s/Case · Assignment: Compare SQL vs NoSQL Studies · Viva on real-life applications of modern databases · Mini-project idea: Student Attendance using NoSQL DB