DATA BASE MANAGEMENT SYSTEMS

DATA BASE MANAGEMENT SYSTEMS

Basic Concepts: Purpose of DBS, data obstruction, data models, instances and schemes, data independence, DDL, DML, DB manager, DB administrator, DB users, database system architecture.

Entity Relationship Model: Entity & entity sets, relationships & relationship sets, attributes, mapping constants, keys, ER diagram, generalization, aggregation.

Relational Model: Relational data structure, architecture, data structure, data manipulation, embedded SQL, external level, internal level, relational algebra, relational calculus, SQL, QBE, integrity constants, normalization, indexing & hashing.

Crash Recovery: Failure verification, storage hierarchy, transaction model, log-based recovery, buffer management, and checkpoints.

Concurrency Control: Schedules, serializability, log based protocols. Transaction Recovery: Storage model, recovery from transaction failure, deadlock handling.

Security & Integrity: Security & integrity violation, authorization & views, security systems in SQL, encryption.

Heiracheal Model: Architecture, data structure, external level, data manipulation, internal level, and logical databases.

Network Model: Architecture, data structure, external level, and data manipulation. Selection of DBMS. Introduction to OODB, distributed DB, temporal DB, and active DB.

Home > Bachelor of Engineering (BE) > DATA BASE MANAGEMENT SYSTEMS
  1. viky
    June 2nd, 2010 at 08:28 | #1

    i am viky passed my bcom exam…want to apply for finance & IT degree,pls let me know in MIS,finance,mail me at viky_2789@hotmail.com

  1. No trackbacks yet.