Syllabus
Course Code: ELECTIVE-I Course Name: DATABASE MANAGEMENT SYSTEM |
||
MODULE NO / UNIT | COURSE SYLLABUS CONTENTS OF MODULE | NOTES |
---|---|---|
1 | Basic Concepts: File Systems vs. DBMS, Characteristics of Database Approach, Abstraction and Data Integration,
Database users, Advantages and Disadvantages of DBMS. Database Systems Architecture: Data Models, Schema and Instances, DBMS architecture and Data Independence, Database languages and Interfaces, DBMS functions. Entity Relationship Model: Entity Types, Entity Sets, Attributes & keys, Relationships Types & instances, Roles and Structural Constraints, E-R Diagrams |
|
2 | Relational Data Model: Basic Concepts, Integrity Constraints over Relations, Relational Algebra: Basic Operations. Relational Database Design: Functional Dependencies, Decomposition, Normal forms based on primary keys- (1NF, 2NF, 3NF, BCNF), Multi-valued Dependencies, 4 NF, Join dependencies,5 NF, Domain Key Normal form | |
3 | SQL: Meaning, Purpose and Need of SQL, Data Types, SQL Components: DDL, DML, DCL and DQL, Basic Queries,
Join Operations and Sub-queries, Views, Specifying Indexes. Constraints and its Implementation in SQL. Relational Algebra: Basic Operations: Select, Project, Join, Union, Intersection, Difference, and Cartesian Product etc. Relational Calculus: Tuple Relational and Domain Relational Calculus. Relational Algebra Vs. Relational Calculus. |
|
4 | Transaction Processing Concepts: Introduction to Transaction Processing, Transaction & System Concepts, Properties
of Transaction, Schedules and Recoverability Concurrency Control Techniques: Locking Techniques, Timestamp ordering, Multi-version Techniques, Optimistic Techniques, Granularity of Data items. Recovery Techniques: Recovery concepts, Recovery Techniques in centralized DBMS. |