Syllabus DBMS, Question papers, Answers, important Question DATABASE MANAGEMENT SYSTEMS R13 Regulation B.Tech JNTUK-kakinada Syllabus download
Syllabus ,DBMS, Question papers, Answers, important Question DATABASE MANAGEMENT SYSTEMS, R13 Regulation, B.Tech , JNTUK,Syllabus, download,
Database Management Systems Syllabus R13 Regulation unit wise
Unit-I
INTRODUCTION
- Database system
- Characteristics (Database Vs File System)
- Database Users(Actors on Scene, Workers behind thescene)
- Advantages of Data base 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 Serverarchitecture for the database
Unit-II
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 /li>
- Arithmetic & logical operations
- SQL functions(Date and Time, Numeric, String conversion)
Unit-III
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
Unit-IV
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)
Unit-V
TRANSACTION MANAGEMENT AND CONCURRENCY CONTROL
- Transaction
- Properties of transactions
- Transaction log
- Transaction management with SQL using commit rollback and savepoint
- Concurrency control for lost updates
- Uncommitted data
- Inconsistent retrievals and the Scheduler
- Concurrency control with locking methods : lock granularity
- lock types
- Two phase locking for ensuring serializability
- Deadlocks
- Concurrency control with time stamp ordering : Wait/Die and Wound/Wait Schemes
- Database Recovery management: Transaction recovery
- SQL constructs that grant access or revoke access from user or user groups
- Basic PL/SQL procedures
- functions andtriggers
Unit-VI
STORAGE AND INDEXING
- Database file organization
- File organization on disK
- Heap files and sorted files
- Hashing
- Single and multi-level indexes
- Dyamic multilevel indexing using B-Tree and B+ tree
- Index on multiple keys
Text Books
- Database Management Systems, 3/e Raghuram Krishnan, Johannes Gehrke, TMH
- Database Management System, 6/e Ramez Elmasri, Shamkant B. Navathe, PEA
- Database Principles Fundamentals of Design Implementation and Management, Corlos Coronel, StevenMorris, Peter Robb, Cengage Learning
Reference Books
- Database System Concepts. 5/e Silberschatz, Korth, TMH
- Introduction to Database Systems, 8/e C J Date, PEA
- The Database book principles & practice using Oracle/MySql Narain Gehani, University Press
For other Subject Syllabus Click here
IF you don't find something you are searching for contact us