Scribd Logo
Upload

Welcome to Scribd!

  • 63 views

    First Page & Syll Dbms r21

    Uploaded by

    eswar p
    This document outlines the syllabus for a course on database management systems. The course objectives are to teach fundamental database concepts, modeling, design using SQL, optimization techniques, and concurrency. By the end of the course students will be able to design databases, define transactions, generate tables, organize data to reduce redundancy, and write queries. The syllabus covers database systems, the relational model, SQL, database design using ER modeling and normalization, query processing, optimization, transaction management, and concurrency control.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    First Page & Syll Dbms r21

    Uploaded by

    eswar p
    63 views3 pages
    This document outlines the syllabus for a course on database management systems. The course objectives are to teach fundamental database concepts, modeling, design using SQL, optimization techniques, and concurrency. By the end of the course students will be able to design databases, define transactions, generate tables, organize data to reduce redundancy, and write queries. The syllabus covers database systems, the relational model, SQL, database design using ER modeling and normalization, query processing, optimization, transaction management, and concurrency control.

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document outlines the syllabus for a course on database management systems. The course objectives are to teach fundamental database concepts, modeling, design using SQL, optimization techniques, and concurrency. By the end of the course students will be able to design databases, define transactions, generate tables, organize data to reduce redundancy, and write queries. The syllabus covers database systems, the relational model, SQL, database design using ER modeling and normalization, query processing, optimization, transaction management, and concurrency control.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    63 views3 pages

    First Page & Syll Dbms r21

    Uploaded by

    eswar p
    This document outlines the syllabus for a course on database management systems. The course objectives are to teach fundamental database concepts, modeling, design using SQL, optimization techniques, and concurrency. By the end of the course students will be able to design databases, define transactions, generate tables, organize data to reduce redundancy, and write queries. The syllabus covers database systems, the relational model, SQL, database design using ER modeling and normalization, query processing, optimization, transaction management, and concurrency control.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 3

    1

    DATABASE
    MANAGEMENT SYSTEM
    (DBMS)
    (R-21 Autonomous)

    Department of Computer Science & Engineering


    PBR Visvodaya Institute sof Technology & Science
    Visvodaya Campus, Udayagiri Road, Kavali, SPSR Nellore Dt -524 201.
    2

    SYLLABUS
    (21A050402) DATABASE MANAGEMENT SYSTEMS
    COURSE OBJECTIVES:
     Train in the fundamental concepts of database management systems, database modeling and
    design, SQL, PL/SQL and system implementation techniques.
     Enable students to model ER diagram for any customized application
     Inducting appropriate strategies for optimization of queries.
     Provide knowledge on concurrency techniques
     Demonstrate the organization of Databases
    COURSE OUTCOMES:
    At the end of the course, the student will be able to
    CO1: Design a database for a real-world information system
    CO2: Define transactions which preserve the integrity of the database
    CO3: Generate tables for a database
    CO4: Organize the data to prevent redundancy
    CO5: Pose queries to retrieve the information from database

    UNIT I
    Introduction: Database systems applications, Purpose of Database Systems, view of Data, Database
    Languages, Relational Databases, Database Design, Data Storage and Querying, Transaction
    Management, Database Architecture, Data Mining and Information Retrieval, Specialty Databases,
    Database users and Administrators.
    Introduction to Relational Model: Structure of Relational Databases, Database Schema, Keys,
    Schema Diagrams, Relational Query Languages, Relational Operations.

    UNIT II
    Introduction to SQL: Overview of the SQL Query Language, SQL Data Definition, Basic Structure of
    SQL Queries, Additional Basic Operations, Set Operations, Null Values, Aggregate Functions, Nested
    Sub-queries, Modification of the Database. Intermediate SQL: Joint Expressions, Views, Transactions,
    Integrity Constraints, SQL Data types and schemas, Authorization.
    Advanced SQL: Accessing SQL from a Programming Language, Functions and Procedures, Triggers,
    Recursive Queries, OLAP, Formal relational query languages.

    UNIT III
    Database Design and the E-R Model: Overview of the Design Process, The EntityRelationship Model,
    Constraints, Removing Redundant Attributes in Entity Sets, EntityRelationship Diagrams, Reduction to
    Relational Schemas, Entity-Relationship Design Issues. Relational Database Design: Features of Good
    Relational Designs, Atomic Domains and First Normal Form, Decomposition Using Functional
    Dependencies, Functional-Dependency Theory, Algorithms for Decomposition, Decomposition Using
    Multivalued Dependencies, More Normal Forms.
    UNIT IV
    Query Processing: Overview, Measures of Query cost, Selection operation, sorting, Join Operation,
    other operations, Evaluation of Expressions.
    Query optimization: Overview, Transformation of Relational Expressions, Estimating statistics of
    Expression results, Choice of Evaluation Plans, Materialized views, Advanced Topics in Query
    Optimization.

    UNIT V
    Transaction Management: Transactions Concept, A Simple Transactional Model, Storage Structures,
    Transaction Atomicity and Durability, Transaction Isolation, Serializability, Isolation and Atomicity,
    Transaction Isolation Levels, Implementation of Isolation Levels, Transactions as SQL Statements.
    Concurrency Control: Lock based Protocols, Deadlock Handling, Multiple granularities, Timestamp
    based Protocols, Validation based Protocols.
    Recovery System: Failure Classification, Storage, Recovery and Atomicity, Recovery Algorithm,
    Buffer Management, Failure with Loss of Nonvolatile Storage, Early Lock Release and Logical Undo
    Operations.

    TEXT BOOKS:
    1. “Database System Concepts” A.Silberschatz, H.F.Korth, S.Sudarshan, TMH 2019, 6/e.

    REFERENCE BOOKS:
    1. “Database Management System” , Shamkant B. Navathe, RamezElmasriPEA 6/e.
    2. “Database Principles Fundamentals of Design Implementation and Management”, Carlos Coronel,
    Steven Morris, Peter Robb, Cengage Learning .
    3. “Database Management Systems”, Raghurama Krishnan, Johannes Gehrke,TMH, , 3/e

    You might also like