Go Back   2022-2023 StudyChaCha > StudyChaCha Discussion Forum > General Topics

  #1  
Old February 7th, 2017, 06:54 PM
Unregistered
Guest
 
Default DBMS VTU Syllabus

HI I would like to have the syllabus for the Database Management System Topic for the 5th semester of the Computer Science Engineering course at VTU?
Reply With Quote
Other Discussions related to this topic
Thread
VTU DBMS Notes PDF
IGNOU DBMS Notes
DBMS SMU
DBMS SBI Questions
DBMS RGPV
WBUT DBMS Syllabus
VTU DBMS Lab Programs
RGPV DBMS Syllabus
DBMS Syllabus For MBA
DBMS Notes For MBA PDF
IGNOU DBMS Books
DBMS Syllabus Anna University
DBMS IIT Madras
DBMS English School
VTU DBMS Notes Doc
DBMS School
MBA in DBMS
DBMS School Jamshedpur
VTU Programs DBMS
DBMS notes MBA PDF DBMS notes MBA students






  #2  
Old February 7th, 2017, 07:19 PM
Super Moderator
 
Join Date: Apr 2013
Default Re: DBMS VTU Syllabus

Database Management System (DBMS) is a PC programming application that communicates with the client, different applications, and the database itself to catch and break down information. A universally useful DBMS is intended to permit the definition, creation, questioning, upgrade, and organization of databases.

Database Management Systems - Syllabus

Unit – I Introduction to Databases and Transactions
What is database system, purpose of database system, view of data, relational databases, database architecture, transaction management,

Unit- II Data Models
The importance of data models, Basic building blocks, Business rules, The evolution of data models, Degrees of data abstraction.

Unit-III Database Design ,ER-Diagram and Unified Modeling Language
Database design and ER Modelverview, ER-Model, Constraints, ER-Diagrams, ERD
Issues, weak entity sets, Codd’s rules, Relational Schemas, Introduction to UML
Relational database model: Logical view of data, keys, integrity rules.
Relational Database design: features of good relational database design, atomic domain and Normalization (1NF, 2NF, 3NF, BCNF).

Unit- IV Relational Algebra and Calculus
Relational algebra: introduction, Selection and projection, set operations, renaming,
Joins, Division, syntax, semantics. Operators, grouping and ungrouping, relational comparison.
Calculus: Tuple relational calculus, Domain relational Calculus, calculus vs algebra, computational capabilities.

Unit- V Constraints, Views and SQL
What is constraints, types of constrains, Integrity constraints,
Views: Introduction to views, data independence, security, updates on views,
comparison between tables and views
SQL: data definition, aggregate function, Null Values, nested sub queries, Joined
relations. Triggers.

Unit-VI Transaction management and Concurrency control
Transaction management: ACID properties, serializability and concurrency control,
Lock based concurrency control (2PL, Deadlocks),Time stamping methods, optimistic methods, database recovery management.

Books:
A Silberschatz, H Korth, S Sudarshan, “Database System and Concepts”, fifth Edition McGraw-Hill,
Rob, Coronel, “Database Systems”, Seventh Edition, Cengage Learning.

Practicals
1) Design a Database and create required tables. For e.g. Bank, College Database
2) Apply the constraints like Primary Key , Foreign key, NOT NULL to the tables.
3) Write a sql statement for implementing ALTER,UPDATE and DELETE
4) Write the queries to implement the joins
5) Write the query for implementing the following functions: MAX(),MIN(),AVG(),COUNT()
6) Write the query to implement the concept of Intergrity constrains
7) Write the query to create the views
8) Perform the queries for triggers
9) Perform the following operation for demonstrating the insertion , updation and deletion using the referential integrity constraints
10) Write the query for creating the users and their role.
__________________
Answered By StudyChaCha Member
Reply With Quote
Reply


Reply to this Question / Ask Another Question
Your Username: Click here to log in

Message:
Options



All times are GMT +6. The time now is 08:57 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Friendly URLs by vBSEO 3.6.0 PL2

1 2 3 4 5 6 7 8