DBMS Syllabus

Database Management System (CAM5011C)

Unit-01: Introduction to Database (25%)

• Introduction to Database: Introduction to Database
• Applications of DBMS
• Purpose of DBMS
• Data Independence
• Types of Database System Architecture (1- tier, 2- tier, 3-tier)
• Database System levels(External, Conceptual, Internal)
• Mappings
• Database, Users and DBA
• Types of Data Models: Hierarchical data model, Network Data Model, Relational Data Model, E-R Data Model

Unit-02: Entity Relationship Diagram (25%)

• Using high level conceptual data models for database design (Design Phases of database design)
• Entity types
• Entity Sets
• Attributes and keys
• Relationship Types
• Relationship sets
• Roles and structural constraints
• Weak entity Types
• Refining the ER diagram for company Database
• Entity Relationship Diagram Naming conventions Design issues

Unit-03: Database Design (25%)

• Informal Design Guidelines for Relational Schema
• Functional Dependencies
• Normal Forms based on Primary keys
• General Definitions of 1NF, 2NF and 3NF
• Boyce-Codd Normal Forms (BCNF)
• Multi-valued Dependency
• Fourth Normal Form

Unit-04: Transaction Processing (25%)

• Introduction to Transaction Processing
• Transaction and System concepts
• Desirable properties of Transactions
• Characterizing Schedules based on recoverability and Serializability