Syllabus
|
Course Code: BCA-407 Course Name: DATA BASE MANAGEMENT SYSTEM – II |
||
| MODULE NO / UNIT | COURSE SYLLABUS CONTENTS OF MODULE | NOTES |
|---|---|---|
| 1 | Database Concepts and Terminology, Characteristics of Database Approach, Data Dictionary, Database Languages,
Actors on the Scene, Mapping in Three Levels of Architecture, Data Independence. Classification of Database Management System, Conceptual and Physical Data Models, Comparison among data models, Codd’s Rule for Relational Model, Symbolic notations for designing ER Diagrams. |
|
| 2 | Functional Dependency: Characteristics, Inference Rules for Functional Dependency, Types of Functional Dependency, Normalization: Benefits and Need of Normalization, Normal Forms Based on Primary Keys- (1NF, 2NF, 3NF, BCNF), Multi-valued Dependencies, 4 NF, Join dependencies, 5 NF, Domain Key Normal Form. | |
| 3 | Transactions: Acid Properties, Operations on Transactions, Concurrency: Problems, Concurrency Control Techniques, Locking Schemes, Deadlock: Methods for Handling Deadlock, Database Backup and Recovery: Recovery Techniques, Shadow Paging, Database Security. | |
| 4 | SQL: Data Definition and Data Types, DDL, DML, and DCL, Views & Queries in SQL, Specifying Constraints & Indexes in SQL. PL/SQL: Architecture of PL/SQL Character Set, Data Types, User Defined Subtypes, Literals, Operators, Control Statement of PL/SQL. PL/SQL Arrays, Functions, Packages, Cursors, Procedure and Triggers. | |
