CHAITANYA BHARATHI INSTITUTE OF TECHNOLOGY (A)
20IT C08-IT1-Database Management Systems-3rdSem-2021-2022
0%
Previous
Course data
General
Announcements
DBMS SLIP TEST-01 on 24-11-2021
DBMS SLIPTEST-02 on 05 JAN 2022
DBMS Slip Test-03 22JAN2022
DBMS Assignment-02
Lecture Recordings
S1-What is DBMS/its Applications and Purpose of Database System-12.40pm to1.40pm-29SEP2021
S2-Data Abstraction-View of data-Data Models-Database Instance and Schema-11.30am to 12.30pm-30OCT2021
S3-Database Design-Database Languages(DDL.DML)10.20AM to11.20am-01OCT2021
S4-Storage Manager&Query Processor-Database users&DBA-11.30AM TO 12.30PM-07OCT2021
S5-Database System Architecture-ER Model-Types of attributes-08OCT2021
S6-Entity set, Relationship set, Degree, cardinality ratos-12.40pm-1.40pm-13OCT2021
S7-Types of constraints in ER Diagram-and representation in the ER Model-11.30AM to12.30PM-14OCT2021
S8-Weak Entity set-Reduction of entity Sets to relational schemas-11.30am-12.30pm-21OCT2021
S9-ER-Diagram Reduction to Relational Schemas-10.20AM to 11.20am-22OCT2021
U4-P2-Multiple Granularity & Timestamp based protocol-17jan2021-3:30pm to 4;30pm
U4-Validation based Protocol and U5-Failure classification & Storage media-19jan2022-12:30pm to1:30pm
U5-P1-RECOVERY and Atomicity-Differed database modification and Log based recovery-20jan2022-11:30pm to12:30pm
U5-P1-Immediate Database modification-check pointing-recovery algorithm-20jan20222-4:30pm to5:30pm
U5-P2-Indexing-Basic concepts -primary vs Secondary, Dense vs Sparse-Multilevel Indexing-21JAN2022-10.30AM TO 11.30AM
U5-P2-B+ Tree Index file creation - Hashing: Handling bucket overflows-21Jan2022-2.30pm TO 3.30PM
PPTS
U1-P1-Introduction
U1-P2-Entity-Relationship Model
U2-P1-Introduction to Relational Model
U2-P2-Introduction to SQL-new
U2-P3-Intermediate SQL-new
Ranking and windowing
U3-P1-Advanced SQL
U3-P2-Normalization-2021(part-1)
U3-P2-Normalization-2021-(part-2)
U4-P1-Transactions
U4-P2-Concurrency control
U5-P2-IndexingHashing
U5-P1-Recovery System
B++ TREE Construction
Previous Question Papers
DBMS (Main Exam)-Previous Question papers
UNIT-1 and UNIT-2 Question Bank
Question Bank-UNIT 3,45
DBMS Unit -3,4 5 important questions-Old Syllabus
Recorded video lectures for the unit-3(NORMALIZATION) &Unit-4(Transactions, Concurrency control)
U3-P2-Relational database design(Normalization)-Functional dependency, Closure set of FDs
U3-P2- Closure of Functional dependency set(F+), Closure of Attribute set and its uses
U3-P2-Equivalence of functional dependency sets , canonical cover computation
U3-P2-Purpose of Normalization,1 NF ,2NF Definitions&Examples
U3-P2-2NF Examples and BCNF Definition and Example
U3-P2-BCNF Example and Decomposition , 3NF Definition and Examples
U3-P2-Test for Dependency Preservation and BCNF Decomposition
U3-P2-Test for BCNF Decomposition, Multivalued Dependency, 4NF Definition,Transaction Concept ,ACID Properties
U4-P1-Transaction states, Benefits of Concurrent Transactions, serial &concurrent Schedules
U4-P1-Conflict Serializability and Recoverable Schedule, Cascade less Schedule
U4-P2-Concurrency control-Locking Protocol.
U4-P2-Lock conversions ,Graph based protocol, multiple granularity, Deadlock Handling
U4-P2-Timestamp based Protocol
U4-P2-Thomas Write rule & validation based protocol
U4-P2-Multiversion concurrency control Schemes
Next
CHAITANYA BHARATHI INSTITUTE OF TECHNOLOGY (A)
Side panel
Log in
Username
Password
Remember username
Forgot Password?
Log in
20IT C08-IT1-Database Management Systems-3rdSem-2021-2022
Home
Calendar
Skip to main content
Course info
Home
Courses
Information Technology
UG
Academic Year 2021-2022
3rd Semester
20IT C08-IT1-Database Management Systems-3rdSem-2021-2022
Summary
20IT C08-IT1-Database Management Systems-3rdSem-2021-2022
Teacher:
Smt. A.Sirisha Assistant Professor
Skill Level
:
Beginner