BCA Syllabus – Database Management Systems

4.1 Database Management Systems

Second Year          Part III Group A              Fourth Semester                Subject Code:   

Unit -1

Introduction to DBMS: Introduction – Why a Database – Characteristics of Data in a Database – Database Management System – Why DBMS – Types of Database Management Systems. Introduction to RDBMS: Introduction – RDBMS Terminology – The Relational Data Structure – Relational Data Integrity – Relational Data Manipulation – Codd’s Rules. Database Architecture and Data Modelling: Introduction – Conceptual, physical and logical Database Models – Database Design – Design Constraints – Functional Dependencies.

Unit - 2

Entity-Relationship (E-R) Modelling: Introduction – E-R model – Components of an E-R model - E-R modelling Symbols. Data Normalization: Introduction – First Normal Form (1NF) – Second Normal Form (2NF) – Third Normal Form (3NF) Boyce-codd Normal Form (BCNF) – Fourth Normal Form (4NF) – Fifth Normal Form (5NF) – Domain-key Normal Form (DKNF) – De-normalization. Relational Algebra and Relational Calculus:   Relational Algebra – Relational Calculus.

Unit - 3

Query-by-Example (QBE):  Introduction – Select Queries in QBE – Make Table Query – DELETE Query – UPDATE Query – APPEND Query – QBE and SQL .QUEL: Introduction – Data Definition in QUEL – Data Retrieval in QUEL – Data Update Operations in QUEL.     Database Security: Introduction – Database Environment – Data Security Risks – Complex User Management Requirements – Dimensions of Database Security – Data security Requirements – Database Users – Protecting the Data within the Database – Granting and Revoking Privileges and roles – Data Encryption – Database integrity – System Availability Factors – Best Security Practices – Network Security – Authenticating users to the Database – Security auditing  

Unit - 4

Data Integrity: Introduction – Types of Integrity Constraints – Restrictions on integrity Constraints. Backup and Recovery: Introduction – Database Backups – Why Plan Backups – Hardware Protection and Redundancy – Transaction Logs – Importance of Backups – Database Recovery – Data Storage – Causes of Failures – Recovery Concepts and Terminology – Recovery Facilities – Recovery Techniques – Detached Transaction Actions -  Recovery in multi-database Systems – Database Recovery Catastrophic Failures.  Web Databases:  Introduction – Internet and World Wide Web – Accessing Databases on the Web – Oracle9i application server portal

Unit - 5

Knowledge Discovery in Databases (KDD): Introduction – Knowledge Discovery – Knowledge Discovery in Databases – Basic features of KDD – Advantages of KDD – Phases of  KDD – KDD Techniques.  Data Warehouses and data Marts:  Introduction – Data in the Data Warehouse – Data Warehouse Design Issues – OLTP vs Data Warehouse – Configuration of Data Warehouse Process – Data Warehouse components – Structure of Data Warehouse - Data Warehouse life Cycle – The Data Warehouse Environment – Data Architecture for Data Warehouse operations – How much data? – Data integration and Transformation operations – The Data Integration and Transformation Process – Technology to support the Data Warehouse – Database Management – User Interfaces to the Data Warehouse - Data Warehousing System – Advantages of a Data Warehouse – Uses of a Data house – Data marts – Advantages of data Marts – Types of Data Marts.  Data Mining:Introduction – What is Data Mining? – Evolution of Data Mining - Data Mining-Verification vs Discovery – Tasks Solved by Data Mining – Advantages of Data Mining.

TEXT BOOK :

 Database Management Systems by Alexis Leon & Mathews Leon, Leon Vikas  Publishing, Chennai 2002.

Unit I: Chapters 5,7,8

Unit II: Chapters 9,11,12

Unit III: Chapters 23,24,27

Unit IV: Chapters 28,30,38

Unit V: Chapters 39,40,41

REFERENCE  BOOKS:

1. Raghu Ramakrishnan & Johannes Gehrke, “Database Management Systems”, 2nd Edition, McGraw Hill International Edition, 2000.

2. Fred R.McFadden, Jeffrey A.Hoffer & Mary.B.Prescott, ”Modern Database Management, ” 5th Edition, Pearson Education Asia, 2001.