Data base Management System (CSIT 405)-Computer Science & Information Technology (IV-Semester) | RGPV

---

• Syllabus

• Syllabus - Data base Management System (CSIT 405)

• Unit-I: Basic Concepts

• Introduction to DBMS
• File system vs DBMS
• Database System Architecture
• Data Models, Schemas and Independence
• Functions of DBA and Designer
• Entities, Attributes and Relationships
• E-R Diagram of Database

• Unit-II: Relational Model

• Structure of Relational Databases
• Relational Algebra
• Entity-Relationship Model

• Unit-III: SQL

• Data Definition in SQL
• Update Statements and Views in SQL
• Data Storage and Definitions
• Data Retrieval Queries and Update Statements
• Query Processing & Query Optimization
• Case Study of ORACLE and DB2

• Unit-IV: Relational Database Design

• Functional Dependency
• Normalization
• Multi-valued Dependency
• Join Dependency

• Unit-V: Transaction Processing and Recovery

• Introduction of Transaction
• Transaction Processing and Recovery
• Concurrency Control
• Protection and Security
• Introduction to Distributed Databases
• Basic Concepts of Object Oriented Database System