JNTUK B.TECH R20 2-1 Syllabus For Database management systems PDF 2022
January 12, 2022 2022-01-12 16:09JNTUK B.TECH R20 2-1 Syllabus For Database management systems PDF 2022
JNTUK B.TECH R20 2-1 Syllabus For Database management systems PDF 2022
cynohub_admin 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 )
