Database Management Systems BCA 2nd Sem UOR

Syllabus

BCA-52T-113

Database Management Systems

UNIT-I

Database System Concepts & Architecture: Overview of DBMS, Basic DBMS Terminology, Data Base System v/s File System, Advantages and Disadvantages of DBMS, Coded Rules, Data Independence. Architecture of a DBMS, Schemas, Instances, Database Languages, Database Administrator, Data Models.

UNIT-II

Data Modelling: Data Modelling using the Entity Relationship Model – ER Model Concepts, Notation for ER Diagram, Mapping Constraints, Keys, Concepts of Super Key, Candidate Key, Primary Key, Generalisation, Aggregation.

Relational Model: Concepts, Constraints, Languages, Relational Database Design by ER & EER Mapping. Relational Algebra Relational Calculus. Relational Algebra, Fundamental Operations of Relational Algebra.

UNIT-III

Database Design: Functional Dependencies, Loss Less Decomposition, Normalisation – 1-NF, 2-NF, 3-NF and BCNF. Transaction Management: Transactions – Concepts, ACID Properties, States of Transaction, Serialisability, Isolation, Checkpoints, Deadlock Handling,

Recovery System and Security: Failure Classifications, Recovery and Atomicity, Log Base Recovery, Recovery with Concurrent Transactions, Introduction to Security & Authorisation.

UNIT-IV

Introduction to SQL: Characteristics of SQL, Advantages of SQL, SQL Data Types and Literals, Types of SQL Commands, SQL Operators and Their Procedure, Tables, Views and Indexes, Queries and Sub Queries, Aggregate Functions, Insert, Update and Delete Operations, Joins, Unions, Intersection, Minus in SQL.