2023 2024 Student Forum > Management Forum > Main Forum

 
  #2  
27th June 2018, 12:38 PM
Unregistered
Guest
 
Re: DBMS VTU Question Paper

Hii sir, I Wants to get the Question Paper of the Data Base Management System of the VTU University ?
  #3  
27th June 2018, 12:39 PM
Super Moderator
 
Join Date: Aug 2012
Re: DBMS VTU Question Paper

Visvesvaraya Technological University is a collegiate public state university in Karnataka State, India. It was established by the Government of Karnataka.

As you Asking for the Question Paper of the Data Base Management System of the VTU University Sorry I may Not Found the Question Paper here I am giving you the

Syllabus of the Data Base Management System of the VTU University is given below

Part A
Unit-1Introduction
Introduction; An example; Characteristics of Database approach; Actors on the screen; Workers behind the scene; Advantages of using DBMS approach; A brief history of database applications; when not to use a DBMS. Data models, schemas and instances; Three-schema architecture and data independence; Database languages and interfaces; The database system environment; Centralized and client-server architectures; Classification of Database Management systems.

Unit-2 Entity-Relationship Model
Using High-Level Conceptual Data Models for Database Design; An Example Database Application; Entity Types, Entity Sets, Attributes and Keys; Relationship types, Relationship Sets, Roles and Structural Constraints; Weak Entity Types; Refining the ER Design; ER Diagrams, Naming Conventions and Design Issues; Relationship types of degree higher than two.

Unit-3 Relational Model and Relational Algebra
Relational Model Concepts; Relational Model Constraints and Relational Database Schemas; Update Operations, Transactions and dealing with constraint violations; Unary Relational Operations: SELECT and PROJECT; Relational Algebra Operations from Set Theory; Binary Relational Operations : JOIN and DIVISION; Additional Relational Operations; Examples of Queries in Relational Algebra; Relational Database Design Using ER- to-Relational Mapping.

Unit-4SQL 1
SQL Data Definition and Data Types; Specifying basic constraints in SQL; Schema change statements in SQL; Basic queries in SQL; More complex SQL Queries.

Part B

Unit-5SQL 2
Insert, Delete and Update statements in SQL; Specifying constraints as Assertion and Trigger; Views (Virtual Tables) in SQL; Additional features of SQL; Database programming issues and techniques; Embedded SQL, Dynamic SQL; Database stored procedures and SQL /PSM.

Unit-6 Database Design 1
Informal Design Guidelines for Relation Schemas; Functional Dependencies; Normal Forms Based on Primary Keys; General Definitions of Second and Third Normal Forms; Boyce-Codd Normal Form

Unit-7 Database Design -
Properties of Relational Decompositions; Algorithms for Relational Database Schema Design; Multivalued Dependencies and Fourth Normal Form; Join Dependencies and Fifth Normal Form; Inclusion Dependencies; Other Dependencies and Normal Forms

Unit-8 Transaction Management
The ACID Properties; Transactions and Schedules; Concurrent Execution of Transactions; Lock- Based Concurrency Control; Performance of locking; Transaction support in SQL; Introduction to crash recovery; 2PL, Serializability and Recoverability; Lock Management; Introduction to ARIES; The log; Other recovery-related structures; The write-ahead log protocol; Checkpointing; Recovering from a System Crash; Media Recovery; Other approaches and interaction with concurrency control.

For more Information you may Contact to the VTU University the contact Details Are given below

Contact Details
VTU University
Address: Jnana Sangama, Machhe, Belgaum, Karnataka 590018
Phone: 0831 249 8196


Quick Reply
Your Username: Click here to log in

Message:
Options

Thread Tools Search this Thread



All times are GMT +5. The time now is 08:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
SEO by vBSEO 3.6.0 PL2

1 2 3 4