8th October 2016 03:46 PM | |
shikha | Re: WBUT Sample Question Papers 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 |
8th October 2016 01:30 PM | |
Unregistered | 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 ? |