WBUT Sample Question Papers

Hii sir, I wants to get the Question Paper of the B.tech Computer Science and Engineering Data Base Management System of the West Bengal University of Technology ?

[shikha]

As you Asking for the Question paper of the B.tech Computer Science and Engineering Data Base Management System of the West Bengal University of Technology Sorry I may not Found the Question Paper of the Data Base Management System of the B.tech Computer Science and Engineering

Here I am giving you the Syllabus of the B.tech Computer Science and Engineering Data Base Management System that is As Follow


Introduction
Concept & Overview of DBMS, Data Models, Database Languages, Database Administrator, Database Users, Three Schema
architecture of DBMS.

Entity-Relationship Model
Basic concepts, Design Issues, Mapping Constraints, Keys, Entity-Relationship Diagram, Weak Entity Sets,Extended E-R features.
Relational Model

Structure of relational Databases, Relational Algebra, Relational Calculus, Extended Relational Algebra Operations, Views,
Modifications Of the Database.

SQL and Integrity Constraints
Concept of DDL, DML, DCL. Basic Structure, Set operations, Aggregate Functions, Null Values, Domain Constraints, Referential
Integrity Constraints, assertions, views, Nested Subqueries, Database security application development using SQL, Stored

procedures and triggers.
Relational Database Design
Functional Dependency, Different anamolies in designing a Database., Normalization using funtional dependencies, Decomposition,
Boyce-Codd Normal Form, 3NF, Nomalization using multi-valued depedencies, 4NF, 5NF

Internals of RDBMS
Physical data structures, Query optimization : join algorithm, statistics and cost bas optimization. Transaction processing,
Concurrency control and Recovery Management : transaction model properties, state serializability, lock base protocols, two phase

locking.
File Organization & Index Structures
File & Record Concept, Placing file records on Disk, Fixed and Variable sized Records, Types of Single-Level Index (primary, secondary, clustering), Multilevel Indexes, DynamicMultilevel Indexes using B tree and B+ tree .


For Any Query you may contact to the West Bengal University of Technology the contact details Are given below

Contact details :
West Bengal University of Technology
Address: BF 142, Sector 1, Salt Lake City, Kolkata, West Bengal 700064
Phone: 033 2334 1014