sc JNTUK B.TECH R20 2-1 Syllabus For Database management systems PDF 2022 – Cynohub

Blog

JNTUK B.TECH R20 2-1 Syllabus For Database management systems PDF 2022

Uncategorized

JNTUK B.TECH R20 2-1 Syllabus For Database management systems PDF 2022

Get Complete Lecture Notes for Database management systems on Cynohub APP

Download the APP Now! ( Click Here )

You will be able to find information about Database management systems along with its Course Objectives and Course outcomes and also a list of textbook and reference books in this blog.You will get to learn a lot of new stuff and resolve a lot of questions you may have regarding Database management systems after reading this blog. Database management systems has 5 units altogether and you will be able to find notes for every unit on the CynoHub app. Database management systems can be learnt easily as long as you have a well planned study schedule and practice all the previous question papers, which are also available on the CynoHub app.

All of the Topic and subtopics related to Database management systems are mentioned below in detail. If you are having a hard time understanding Database management systems or any other Engineering Subject of any semester or year then please watch the video lectures on the official CynoHub app as it has detailed explanations of each and every topic making your engineering experience easy and fun.

Database management systems Unit One

Introduction: Database system, Characteristics (Database Vs File System), Database Users(Actors on Scene, Workers behind the scene), Advantages of Database systems, Database applications. Brief introduction of different Data Models; Concepts of Schema, Instance and data independence; Three tier schema architecture for data independence; Database system structure, environment, Centralized and Client Server architecture for the database.

Database management systems Unit Two

Relational Model: Introduction to relational model, concepts of domain, attribute, tuple, relation, importance of null values, constraints (Domain, Key constraints, integrity constraints) and their importance BASIC SQL: Simple Database schema, data types, table definitions (create, alter), different DML operations (insert, delete, update), basic SQL querying (select and project) using where clause, arithmetic & logical operations, SQL functions(Date and Time, Numeric, String conversion).

Get Complete Lecture Notes for Database management systems on Cynohub APP

Download the APP Now! ( Click Here )

Database management systems Unit Three

Entity Relationship Model: Introduction, Representation of entities, attributes, entity set, relationship, relationship set, constraints, sub classes, super class, inheritance, specialization, generalization using ER Diagrams. SQL: Creating tables with relationship, implementation of key and integrity constraints, nested queries, sub queries, grouping, aggregation, ordering, implementation of different types of joins, view(updatable and non-updatable), relational set operations.

Database management systems Unit Four

Schema Refinement (Normalization): Purpose of Normalization or schema refinement, concept of functional dependency, normal forms based on functional dependency(1NF, 2NF and 3 NF), concept of surrogate key, Boyce-codd normal form(BCNF), Lossless join and dependency preserving decomposition, Fourth normal form(4NF), Fifth Normal Form (5NF).

Database management systems Unit Five

Transaction Concept: Transaction State, Implementation of Atomicity and Durability, Concurrent Executions, Serializability, Recoverability, Implementation of Isolation, Testing for Serializability, Failure Classification, Storage, Recovery and Atomicity, Recovery algorithm.

Indexing Techniques: B+ Trees: Search, Insert, Delete algorithms, File Organization and Indexing, Cluster Indexes, Primary and Secondary Indexes , Index data Structures, Hash Based Indexing: Tree base Indexing ,Comparison of File Organizations, Indexes and Performance Tuning

Database management systems Course Objectives

To introduce about database management systems

To give a good formal foundation on the relational model of data and usage of Relational Algebra

To introduce the concepts of basic SQL as a universal Database language

To demonstrate the principles behind systematic database design approaches by covering conceptual design, logical design through normalization

To provide an overview of physical design of a database system, by discussing Database indexing techniques and storage techniques

Database management systems Course Outcomes

By the end of the course, the student will be able to

Describe a relational database and object-oriented database

Create, maintain and manipulate a relational database using SQL

Describe ER model and normalization for database design

Examine issues in data storage and query processing and can formulate appropriate solutions

Outline the role and issues in management of data such as efficiency, privacy, security, ethical responsibility, and strategic advantage

Database management systems Text Books

Database Management Systems, 3/e, Raghurama Krishnan, Johannes Gehrke, TMH

Database System Concepts,5/e, Silberschatz, Korth, TMH

Database management systems Reference Books

Introduction to Database Systems, 8/e C J Date, PEA.

Database Management System, 6/e Ramez Elmasri, Shamkant B. Navathe, PEA

Database Principles Fundamentals of Design Implementation and Management, Corlos Coronel, Steven Morris, Peter Robb, Cengage Learning.

Scoring Marks in Database management systems

Scoring a really good grade in Database management systems is a difficult task indeed and CynoHub is here to help!. Please watch the video below and find out how to get 1st rank in your B.tech examinations . This video will also inform students on how to score high grades in Database management systems. There are a lot of reasons for getting a bad score in your Database management systems exam and this video will help you rectify your mistakes and help you improve your grades.

Information about JNTUK B.Tech R20 Database management systems was provided in detail in this article. To know more about the syllabus of other Engineering Subjects of JNTUH check out the official CynoHub application. Click below to download the CynoHub application.

Get Complete Lecture Notes for Database management systems on Cynohub APP

Download the APP Now! ( Click Here )

Leave your thought here

Your email address will not be published. Required fields are marked *