Introduction to DBMS

₹145.00

Tax excluded

Quantity

ISBN- 978-93-89516-36-4

Dr. Neeraj Sharma & Shailendra Sharma

BCA, Fifth Semester, According to ‘UP Unified Syllabus’
Syllabus
 
BCA-S301T: INTRODUCTION TO DBMS
 
Unit-I: Introduction
Characteristics of Database Approach, Data Models, DBMS Architecture and DataIndependence.
 
Unit-II: E-R Modeling
Entity Types, Entity Set, Attribute and Key, Relationships, Relation Types, Roles and Structural Constraints, Weak Entities, Enhanced E-R and Object Modeling, Sub Classes; Super Classes, Inheritance, Specialization and Generalization.
 
Unit-III: File Organization
Indexed Sequential Access Files; Implementation Using B and B++ Trees, Hashing, Hashing Functions, Collision Resolution, Extendible Hashing, Dynamic Hashing Approach Implementation and Performance.
 
Unit-IV: Relational Data Model
Relational Model Concepts, Relational Constraints, Relational Algebra.
 
SQL
SQL Queries, Programming Using SQL.
 
Unit-V: EER and ER to Relational Mapping
Database Design Using EER to Relational Language.
 
Unit-VI: Data Normalization
Functional Dependencies, Normal Form upto 3rd Normal Form.
 
Concurrency Control
Transaction Processing, Locking Techniques and Associated, Database Recovery, Security and Authorization. Recovery Techniques, Database Security.
UP/BCA/2019/5/02
75 Items
New product

3 other products in the same category: