Database Management System

₹150.00

(₹150.00 Book)

Tax excluded

Quantity
Meghendra Singh Dhaked
University of Rajasthan - UOR, BCA, Part II
Syllabus
BCA 204: DATABASE MANAGEMENT SYSTEM
 
UNIT-1
Database System Concepts & Architecture: Overview of DBMS, Basic DBMS terminology/data base system v/s file system, Advantages and dis-advantages of DBMS, Codd rules, data independence. Architecture of a DBMS, Schemas, Instances, Database Languages, Database Administrator, Data Models.
 
UNIT-II
Data Modeling: Data modeling using the Entity Relationship Model: ER model concepts, notation for ER diagram, mapping constraints, keys, Concepts of Super Key, candidate key, primary key, Generalisation, aggregation.
 
Relational Algebra: Fundamental operations of relational algebra & their implementation, interdependence of operations.
 
UNIT-III
Database Design: Functional dependencies, loss less decomposition, 1st, 2nd & 3rd normal forms, dependency preservation, boyce codd NF. Introduction to Transactions, transaction states. Security: Access control, Backup, recovery, maintenance and performance.
 
UNIT-IV
Introduction to SQL: Characteristics of SQL, Advantages of SQL, SQL data types and literals, Types of SQL commands, SQL operators and their procedure, Tables, views and indexes, Queries and sub queries, Aggregate functions, insert, update and delete operations, Joins, Unions, Intersection, Minus in SQL.
 
UNIT-V
Introduction to Advance DBMS
Object-based Databases: Object-Oriented Databases: Object-oriented data model, Object Oriented Languages, Persistent Programming Languages. Object-Relational Databases: Nested Relations, Storage for Object Databases
 
Distributed Databases: Distributed Data Storage, Distributed Transactions, Commit protocol, Concurrency Control in Distributed Databases, Availability, Distributed Query Processing
UOR2017/BCA/2/02
497 Items

5 other products in the same category: