Database Management Systems

₹120.00

(₹120.00 Book)

Tax excluded

Quantity

Jasmeen Sandhu & Navneet Kalsotra

ISBN - 9789351638704

Punjab Technical University PTU BCA, Fourth Semester
Syllabus
 
(BSBC 404)
 
DATABASE MANAGEMENT SYSTEMS
 
Internal Assessment: 40 Marks                               External Assessment: 60 Marks
 
 
Section-A
An Overview of DBMS: Concept of File Processing Systems and Database Systems, Database Administrator and his Responsibilities. Physical and Logical Data Independence.
 
Three Level Architecture of Database System: The External Level, Conceptual Level and the Internal Level.
 
Section-B
Introduction to Data Models: Entity Relationship Model, Hierarchical, Network and Relational Model. Comparison of Network, Hierarchical and Relational Model.
 
Section-C
Relational Data Model: Relational Database, Relational Algebra and Calculus, SQL Dependencies, Functional Dependency, Multi-Valued Dependency and Join, Normalization.
 
Section-D
Database Protection: Recovery, Concurrency Management, Database Security, Integrity and Control, Disaster Management.
 
Distributed Databases: Structure of a Distributed Database, Design of Distributed Databases.
PTU2016/BCA/4/04
497 Items

3 other products in the same category: