CHAITANYA BHARATHI INSTITUTE OF TECHNOLOGY (A)
  • IT2-Data Base Management System - IV-Sem.- 2020-21
    0%
  • Previous
  • Course data
    General
    Announcements
    DBMS SLIPTEST-01
    DBMS Assignment-Normalization &Transactions
    DBMS SLIPTEST-02
    DBMS ASSIGNMENT-02 (UNIT 3,4,5)
    Unit-1 & Unit-2 Question Bank
    Unit-4, Unit-5 &Unit-5 Question Bank
    DBMS -Equivalent subject-class trest-02 submission link
    Video Lectures
    S1-What is DBMS? and DBMS Applications-08th Feb 2021
    S2-Purpose of Database System, View of Data-data abstraction levels-09FEB2021
    S3-Data Model,Storage management&Query Processing,Database users-10FEB2021
    S4-DBA Functions,Transaction Management,Database Architectures-15FEB2021
    S5 -what is an Entity set?Relationship set, Degree of a Relationship-17FEB2021
    S6 -Types of Attributes-Mapping Cardinalities-18FEB2021
    S7-Cardinality Ratios, Weak Entity Set- Discriminator& Primary key of Weak entity set-22FEB2021
    S8-Extended ER Features-Specialization, Generalization & Aggregation-24FEB2021
    S9- ER Diagram Reduction to Relation Schemas-25FEB2021
    S10-Alternative Notations for ER Diagram-Chen's, Crow's feet notations-01MAR2021
    S11-Relation Model-Keys- Basic Relational Algebra Operations-08MAR2021
    S12-Relational Algebra Expressions-Examples-10MAR2021
    S13-Introduction to SQL-15MAR2021
    S14-Subqueries-Usage of Exists, Unique ,With Clause -17MAR2021
    S15-Scalar Query, Update with case, Join conditions, Join types-18MAR2021
    S16-Views-Integrity Constraints-22MAR2021
    S17-Assertion and user defined datatypes-24MAR2021
    S18-Advanced Aggregation Features: Ranking and Windowing-26MAR2021
    S19-DYNAMIC SQL-JDBC-30MAR2021
    S20-Embedded SQL-31MAR2021
    S21- PL/SQL Function &Procedure-06APR2021
    S22-TRIGGERS-07APR2021
    S23-Recursive Queries, Features of good relational database design: Lossy Decomposition-12APR2021
    S24-Relational database design(Normalization)-Functional dependemcy, Closure set of FDs-26APR2021-10.20 AM to 11.20am
    S25- Closure of Functional dependency set(F+), Closure of Attribute set and its uses-27APR2021-11:30am to12:30pm
    S26-Equivalence of functional dependency sets , canonical cover computation-28APR2021-10.20 am to11.20am
    527(ExtraClass)-Purpose of Normalization,1 NF ,2NF Definitions&Examples-30APR2021-4:15pm to5.15pm
    S28-2NF Examples and BCNF Definition and Example-03MAY2021:10:20AM TO 11:20AM
    S29-BCNF Example and Decomposition , 3NF Definition and Examples-04MAY2021:11.30AM-12:30PM
    S30-Test for Dependency Preservation and BCNF Decomposition-05MAY2021-10.20AM TO 11.20AM
    S31-Test for BCNF Decomposition, Multivalued Dependency, 4NF Definition,Transaction Concept ,ACID Properties-10MAY2021-10.20AM TO 11.20AM
    S32-Transaction states, Benefits of Concurrent Transactions, serial &concurrent Schedules-11MAY2021-11.30AM TO 12.30PM
    S33-Conflict Serializability and Recoverable Schedule, Casecadeless Schedule-12MAY2021-10:20AM 11.20AM
    S34-Concurrency control-Locking Protocol.-13MAY2021-4:45PM TO 5:45PM
    S35-Lock conversions ,Graph based protocol, multiple granularity, Deadlock Handling-17MAY2021
    S36-Timestamp based Protocol-18MAY2021-11:30AM -12:30PM
    S37- Thomas Write rule & validation based protocol-19MAY2021-10.20am to 11:20am
    S38-Multiversion concurrency control Schemes -24MAY2021-10:20AM TO 11.20AM
    S40-Recovery System-Log based recovery-checkpoint, fuzzy checkpoint.-25MAY2021-11:30AM TO 12:30PM
    S41- Indexing and Hashing-26may2021-10.20am to 11.20am
    Unit wise PPTS
    U1-P1-Introduction
    U1-P2-Entity Relationship Model
    U2-P1-Relational Model(Relational Algebra)
    U2-P2-Introduction to SQL
    U2-P3-INTERMEDIATE SQL
    Advanced Aggregation Features: Ranking and Windowing
    U3-P1-Advanced SQL
    U3-P2-Normalization (part-1) ppt
    U3-P2-Normalization(Part-2) ppt
    U4-P2-Transactions PPT
    U5-P1-Concurrency Control PPT
    U5-P2-Recovery System
    U4-P1-Indexing and Hashing
  • Next
  CHAITANYA BHARATHI INSTITUTE OF TECHNOLOGY (A)
    • Log in
      Forgot Password?
    IT2-Data Base Management System - IV-Sem.- 2020-21
    Home
    Skip to main content

    Course info

    1. Home
    2. Courses
    3. Information Technology
    4. UG
    5. Academic Year 2020-2021
    6. IV - Semester
    7. IT2-Data Base Management System - IV-Sem.- 2020-21
    8. Summary

    IT2-Data Base Management System - IV-Sem.- 2020-21

    • Teacher: Smt. A.Sirisha Assistant Professor
    Skill Level: Beginner

    Follow Us

    Chaitanya Bharathi Institute of Technology(Autonomous), Hyderabad
    You are not logged in. (Log in)
    Get the mobile app