Scribd Logo
Upload

Welcome to Scribd!

  • 46 views

    DBMS

    Uploaded by

    roxibe
    The document outlines the detailed syllabus for the Database Management System course taken in the 5th semester of a B.Tech in Information Technology and CSI degree program. The syllabus covers 5 units: 1) database concepts and modeling, 2) the relational data model and SQL, 3) database design and normalization, 4) transaction processing concepts, and 5) concurrency control techniques. The course aims to teach students to apply database knowledge to real applications, use query processing to solve problems, perform normalization to reduce redundancy, and design and implement a small database project using database tools.

    Copyright:

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

    DBMS

    Uploaded by

    roxibe
    46 views1 page
    The document outlines the detailed syllabus for the Database Management System course taken in the 5th semester of a B.Tech in Information Technology and CSI degree program. The syllabus covers 5 units: 1) database concepts and modeling, 2) the relational data model and SQL, 3) database design and normalization, 4) transaction processing concepts, and 5) concurrency control techniques. The course aims to teach students to apply database knowledge to real applications, use query processing to solve problems, perform normalization to reduce redundancy, and design and implement a small database project using database tools.

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document outlines the detailed syllabus for the Database Management System course taken in the 5th semester of a B.Tech in Information Technology and CSI degree program. The syllabus covers 5 units: 1) database concepts and modeling, 2) the relational data model and SQL, 3) database design and normalization, 4) transaction processing concepts, and 5) concurrency control techniques. The course aims to teach students to apply database knowledge to real applications, use query processing to solve problems, perform normalization to reduce redundancy, and design and implement a small database project using database tools.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    46 views1 page

    DBMS

    Uploaded by

    roxibe
    The document outlines the detailed syllabus for the Database Management System course taken in the 5th semester of a B.Tech in Information Technology and CSI degree program. The syllabus covers 5 units: 1) database concepts and modeling, 2) the relational data model and SQL, 3) database design and normalization, 4) transaction processing concepts, and 5) concurrency control techniques. The course aims to teach students to apply database knowledge to real applications, use query processing to solve problems, perform normalization to reduce redundancy, and design and implement a small database project using database tools.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 1

    B.TECH.

    (INFORMATION TECHNOLOGY and CSI)


    FIFTH SEMESTER (DETAILED SYLLABUS)

    Database Management System (KCS-501)


    Course Outcome ( CO) Bloom’s Knowledge Level (KL)
    At the end of course , the student will be able to:
    CO 1 Apply knowledge of database for real life applications. K3
    CO 2 Apply query processing techniques to automate the real time problems of databases. K3, K4
    CO 3 Identify and solve the redundancy problem in database tables using normalization. K2, K3
    Understand the concepts of transactions, their processing so they will familiar with broad range K2, K4
    CO 4
    of database management issues including data integrity, security and recovery.
    CO 5 Design, develop and implement a small database project using database tools. K3, K6
    DETAILED SYLLABUS 3-1-0
    Unit Topic Proposed
    Lecture
    Introduction: Overview, Database System vs File System, Database System Concept and
    Architecture, Data Model Schema and Instances, Data Independence and Database Language and
    Interfaces, Data Definitions Language, DML, Overall Database Structure. Data Modeling Using the
    I 08
    Entity Relationship Model: ER Model Concepts, Notation for ER Diagram, Mapping Constraints,
    Keys, Concepts of Super Key, Candidate Key, Primary Key, Generalization, Aggregation,
    Reduction of an ER Diagrams to Tables, Extended ER Model, Relationship of Higher Degree.
    Relational data Model and Language: Relational Data Model Concepts, Integrity Constraints,
    Entity Integrity, Referential Integrity, Keys Constraints, Domain Constraints, Relational Algebra,
    Relational Calculus, Tuple and Domain Calculus. Introduction on SQL: Characteristics of SQL,
    II Advantage of SQL. SQl Data Type and Literals. Types of SQL Commands. SQL Operators and 08
    Their Procedure. Tables, Views and Indexes. Queries and Sub Queries. Aggregate Functions.
    Insert, Update and Delete Operations, Joins, Unions, Intersection, Minus, Cursors, Triggers,
    Procedures in SQL/PL SQL
    Data Base Design & Normalization: Functional dependencies, normal forms, first, second, 8 third
    III normal forms, BCNF, inclusion dependence, loss less join decompositions, normalization using 08
    FD, MVD, and JDs, alternative approaches to database design
    Transaction Processing Concept: Transaction System, Testing of Serializability, Serializability of
    Schedules, Conflict & View Serializable Schedule, Recoverability, Recovery from Transaction
    IV 08
    Failures, Log Based Recovery, Checkpoints, Deadlock Handling. Distributed Database: Distributed
    Data Storage, Concurrency Control, Directory System.
    Concurrency Control Techniques: Concurrency Control, Locking Techniques for Concurrency
    V Control, Time Stamping Protocols for Concurrency Control, Validation Based Protocol, Multiple 08
    Granularity, Multi Version Schemes, Recovery with Concurrent Transaction, Case Study of Oracle.
    Text books:
    1. Korth, Silbertz, Sudarshan,” Database Concepts”, McGraw Hill
    2. Date C J, “An Introduction to Database Systems”, Addision Wesley
    3. Elmasri, Navathe, “ Fundamentals of Database Systems”, Addision Wesley
    4. O’Neil, Databases, Elsevier Pub.
    5. RAMAKRISHNAN"Database Management Systems",McGraw Hill
    6. Leon & Leon,”Database Management Systems”, Vikas Publishing House
    7. Bipin C. Desai, “ An Introduction to Database Systems”, Gagotia Publications
    8. Majumdar & Bhattacharya, “Database Management System”, TMH

    Curriculum & Evaluation Scheme IT & CSI (V & VI semester) 4

    You might also like