2023 2024 EduVark > Education Discussion > General Discussion


  #1  
September 9th, 2016, 11:00 AM
Super Moderator
 
Join Date: Mar 2012
DBMS Notes VTU 5th Sem

I want the notes/ syllabus of Data Base Management System of BE V Sem of Visvesvaraya Technological University VTU so can you provide me?

Ok, here I am providing you the syllabus of Data Base Management System of BE V Sem of Visvesvaraya Technological University VTU.

VTU BE V Sem Data Base Management System syllabus

Subject Code: 10CS54
I.A. Marks : 25
Hours/Week : 04
Exam Hours: 03
Total Hours : 52
Exam Marks: 100

PART - A

UNIT – 1
6 Hours
Introduction: 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
6 Hours
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 degreehigher than two.

UNIT – 3
8 Hours
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 – 4
6 Hours
SQL – 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 – 5
6 Hours
SQL – 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
6 Hours
Database Design – 1: Informal Design Guidelines for Relation Schemas; Functional ependencies; Normal Forms Based on Prim

For complete notes here is the attachment



Contact-

Visvesvaraya Technological University Karnataka
Jnana Sangama, VTU Main Road, Machhe, Belagavi, Karnataka 590018
Attached Files
File Type: pdf VTU BE V Sem Data Base Management System syllabus.pdf (1.29 MB, 179 views)

Last edited by Neelurk; May 7th, 2020 at 03:52 PM.
Similar Threads
Thread
IIT Bombay DBMS Ppt
Anna University DBMS Notes for CSE
VTU DBMS Notes Free Download
DBMS Lab Programs VTU
Ptu dbms
DBMS Certification
DBMS Lab Manual for MBA
DBMS Notes for BCA of IGNOU
PTU DBMS Syllabus
IGNOU DBMS Paper
Anna University Chennai DBMS Notes
Dbms ignou
DBMS Notes Anna University
Differentiate between DBMS and RDBMS
DBMS Syllabus MU



Quick Reply
Your Username: Click here to log in

Message:
Options



All times are GMT +5. The time now is 02:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Content Relevant URLs by vBSEO 3.6.0

1 2 3 4 5 6 7 8