Book Details

Database Management Systems

Database Management Systems

Published by uLektz

Course Code:RT31054


University: JNTU Kakinada


Categories:Computer Science

Format : ico_bookePUB3 (DRM Protected)

Type :eBook


Buy Now

Description :Database Management Systems of RT31054 covers the latest syllabus prescribed by JNTU Kakinada for regulation 2013. Author: uLektz, Published by uLektz Learning Solutions Private Limited.

Note : No printed book. Only ebook. Access eBook using uLektz apps for Android, iOS and Windows Desktop PC.

Unit – I Introduction

1.1 Database system

1.2 Brief introduction of different Data Models

1.3 Database system structure, environment, Centralized and Client Server architecture for the database

Unit – II Relational Model

2.1 Introduction to relational model

2.2 BASIC SQL : Simple Database schema, data types

2.3 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).

Unit – III Entity Relationship Model

3.1 Introduction, Representation of entities, attributes, entity set, relationship, relationship set, constraints, sub classes, super class, inheritance, specialization, generalization using ER Diagrams

3.2 SQL : Creating tables with relationship, implementation of key and integrity constraints

3.3 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)

4.1 Purpose of Normalization or schema refinement

4.2 Normal forms based on functional dependency(1NF, 2NF and 3 NF)

4.3 Lossless join and dependency preserving decomposition

Unit – V Transaction Management And Concurrency Control

5.1 Transaction, properties of transactions, transaction log, and transaction management with SQL using commit rollback and save point.

5.2 Concurrency control for lost updates

5.3 Concurrency control with locking methods : lock granularity, lock types

5.4 Concurrency control with time stamp ordering : Wait/Die and Wound/Wait Schemes, Database Recovery management : Transaction recovery.

5.5 SQL constructs that grant access or revoke access from user or user groups. Basic PL/SQL procedures, functions and triggers.

Unit – VI Storage And Indexing

6.1 Database file organization

6.2 Hashing, single and multi-level indexes