Data Base Management System Friday, January 14th, 2011
|BRANCH||INDUSTRIAL ENGINEERING AND MANAGEMENT|
|SUBJECT CODE||06IP/IM 836|
|SUBJECT NAME||Data Base Management System|
PART - A UNIT - 1 DATABASES AND DATABASE USERS: Introduction, characteristics of data base approach, intended uses of a DBMS, advantages and implication of database approach. 2 Hours DATABASE SYSTEMS CONCEPTS AND ARCHITECTURE: Data models, Schemas and instances, DBMS architecture and data independence, database languages and interfaces, database system environment, classification of data base management systems. 5 Hours UNIT - 2 DATA MODELING: High level conceptual data models for database design. Entity types, entity sets, attributes, and keys. Relationships, relationship types, roles, and structural constraints. Weak entity types. ER diagrams 6 Hours UNIT - 3 RECORD STORAGE AND PRIMARY FILE ORGANIZATIONS: Secondary storage devices, buffering of blocks, placing file records on disk, operations on files, heap files and sorted files, hashing techniques. 6 Hours UNIT - 4 INDEX STRUCTURE OF FILES: Single-level and multilevel ordered indexes, dynamic multi level indexes using B-trees and B+trees. 6 Hours PART - B UNIT - 5 RELATIONAL DATA MODEL AND RELATIONAL ALGEBRA: Brief discussion on Codd rules, relational model concepts, constraints, and schemas. Update operation on relations, basic and additional relational algebra operations, and queries in relational algebra. Structured Query Language (SQL): Data definition etc. in SQL2. Basic and complex queries in SQL. Insert, delete, update statements, and views in SQL, embedded SQL. 9 Hours UNIT - 6 DATABASE DESIGN: Design guidelines for relational schemes, functional Dependencies, normalization -1st, 2nd, 3rd, 4th, and 5th normal forms. Database design process, factors influencing physical database design guidelines, and guidelines for relational systems. 6 Hours UNIT - 7 SYSTEM IMPLEMENTATION: System catalog for RDBMSs, transaction processing and system concepts, properties of transactions, brief discussion on concurrency, control and recovery techniques, database security and authorization. 6 Hours UNIT - 8 BRIEF DISCUSSION ON: Distributed databases, Objected oriented databases, next generation databases, and interfacing with other technologies. 6 Hours
Send @fastvtu YOUR_USN to 92665 92665 to get your latest and previous semester results through SMS.
Recommended For You
Receive updates right in your inbox. Subscribe now!