CHAITANYA BHARATHI INSTITUTE OF TECHNOLOGY (A)
Database Management Systems - MCA II SEMESTER- 2020-2021
0%
Previous
Course data
General
Announcements
DBMS First Assignment
MCA II SEM ASSIGNMENT 2
Topic 1
AY2020-2021_PG_II_20MCC110_DBMS_MR_1_2021-05-19_Overview of DBMS
AY2020-2021_PG_II_20MCC110_DBMS_MR_2_2021-05-21_Introduction to DBMS, Levels of data abstraction
AY2020-2021_PG_II_20MCC110_DBMS_MR_3_2021-05-24_Introduction to SQL
AY2020-2021_PG_II_20MCC110_DBMS_MR_4_2021-05-25_continuation of SQL, Integrity constraints, Select, From ,Where Clause
AY2020-2021_PG_II_20MCC110_DBMS_MR_5_2021-05-26_Entity Relationship Model
AY2020-2021_PG_II_20MCC110_DBMS_MR_6_2021-05-28_Entity Sets ,Attributes, Relationship sets ,Weak Entity, Strong Entity, Specialization, Generalization
AY2020-2021_PG_II_20MCC110_DBMS_MR_7_2021-06-01_E-R Design Decisions, Notation of E-R Diagrams
AY2020-2021_PG_II_20MCC110_DBMS_MR_8_2021-06-02_Column level and Table level constraints , null values. implicit and explicit null values enable & disable
AY2020-2021_PG_II_20MCC110_DBMS_MR_9_2021-06-04_Views,Simple views,Read only,Check,Forced views
AY2020-2021_PG_II_20MCC110_DBMS_MR_10_2021-06-07_Normilazation, Functional Dependency
AY2020-2021_PG_II_20MCC110_DBMS_MR_11_2021-06-07_Normal Forms
AY2020-2021_PG_II_20MCC110_DBMS_MR_12_2021-06-10_TCL Commands
AY2020-2021_PG_II_20MCC110_DBMS_MR_13_2021-06-11_Queries,Special operator ,Dual table
AY2020-2021_PG_II_20MCC110_DBMS_MR_14_2021-06-14_Set operators, Aggregate Functions
AY2020-2021_PG_II_20MCC110_DBMS_MR_15_2021-06-15_Complex Views
AY2020-2021_PG_II_20MCC110_DBMS_MR_16_2021-06-16_Joins,Cross Joins,Equijoin_
AY2020-2021_PG_II_20MCC110_DBMS_MR_17_2021-06-18_Non-Equi-Joins,Outer-Joins,left outer join ,Right outer join .Self join
AY2020-2021_PG_II_20MCC110_DBMS_MR_18_2021-06-21_Date Formats and Date conversions
AY2020-2021_PG_II_20MCC110_DBMS_MR_19_2021-06-22_Date Functions, Character Manipulation Function, Sub Queries
AY2020-2021_PG_II_20MCC110_DBMS_MR_20_2021-06-23_Nested Queries
AY2020-2021_PG_II_20MCC110_DBMS_MR_21_2021-06-25_Introduction to PL/SQL ,Basic Programs, Attribute types
AY2020-2021_PG_II_20MCC110_DBMS_MR_22_2021-06-28_Introduction to Indexing, Dense and Sparse Indexing
AY2020-2021_PG_II_20MCC110_DBMS_MR_23_2021-06-29_Program using If Conditions ,and Loops
AY2020-2021_PG_II_20MCC110_DBMS_MR_24_2021-06-29_Introduction to Cursor
AY2020-2021_PG_II_20MCC110_DBMS_MR_25_2021-06-30_continuation of Cursor, Indexing , Multi-level Indexing
AY2020-2021_PG_II_20MCC110_DBMS_MR_26_2021-07-02_B-trees,construct,insert,delete
AY2020-2021_PG_II_20MCC110_DBMS_MR_27_2021-07-05_B+Trees, node format, insertion, deletion
AY2020-2021_PG_II_20MCC110_DBMS_MR_28_2021-07-06_Introduction to Hashing
AY2020-2021_PG_II_20MCC110_DBMS_MR_29_2021-07-07_continuation of hashing. Case conversion functions and Character Manipulation Functions
AY2020-2021_PG_II_20MCC110_DBMS_MR_30_2021-07-09_Open hashing -Chaining, linear probing
AY2020-2021_PG_II_20MCC110_DBMS_MR_31_2021-07-19_Quadratic Probing, Double hashing, Comparison of Open hashing(chaining) and Open Addressing
AY2020-2021_PG_II_20MCC110_DBMS_MR_32_2021-07-20_Introduction to Transaction Management
AY2020-2021_PG_II_20MCC110_DBMS_MR_33_2021-07-26_Continuation to Transaction Management, ACID Properties
AY2020-2021_PG_II_20MCC110_DBMS_MR_34_2021-07-27_Schedules in Transaction Management,
AY2020-2021_PG_II_20MCC110_DBMS_MR_35_2021-07-28_Serializability, conflict serializability, Precedence graph
AY2020-2021_PG_II_20MCC110_DBMS_MR_36_2021-07-30_Practice of conflict serializability, Precedence graph
AY2020-2021_PG_II_20MCC110_DBMS_MR_37_2021-08-04_doubts clarification and Marks shown to students
AY2020-2021_PG_II_20MCC110_DBMS_MR_38_2021-08-05_View Serializability and Testing with Precedence graph
AY2020-2021_PG_II_20MCC110_DBMS_MR_39_2021-08-06_Concurrency control Mechanisms, Locking Protocol, Two phase locking Protocol
AY2020-2021_PG_II_20MCC110_DBMS_MR_40_2021-08-10_ Strict Two phase locking Protocol, Dead locks
AY2020-2021_PG_II_20MCC110_DBMS_MR_41_2021-08-11_ Dead Lock-Prevention , Use Of Time-Stamps, Time-out Based Scheme
AY2020-2021_PG_II_20MCC110_DBMS_MR_42_2021-08-11_"Timestamp-Based Protocols, Multiple Granularity, Thomas’ Write Rule "
AY2020-2021_PG_II_20MCC110_DBMS_MR_43_2021-08-13_Introduction to Crash Recovery, ARIES
AY2020-2021_PG_II_20MCC110_DBMS_MR_44_2021-08-16_"Recovery Phases,Analysis pass ,Redo pass ,Undo Pass, Data Structures Used in ARIES "
AY2020-2021_PG_II_20MCC110_DBMS_MR_45_2021-08-17_WAL,Check Pointing, Recovery from System Crash
AY2020-2021_PG_II_20MCC110_DBMS_MR_46_2021-08-18_Media Recovery, Introduction to Security and Authorization
AY2020-2021_PG_II_20MCC110_DBMS_MR_47_2021-08-23_Database Security, Data control Language
AY2020-2021_PG_II_20MCC110_DBMS_MR_48_2021-08-24_Interaction with students and Clarifying the doubts
AY2020-2021_PG_II_20MCC110_DBMS_MR_49_2021-08-25_Access control policies , DAC, MAC ,Roll base access control
AY2020-2021_PG_II_20MCC110_DBMS_MR_50_2021-08-27_Additional Issues related to Security
AY2020-2021_PG_II_20MCC110_DBMS_MR_51_2021-08-30_Conducted Slip Test
AY2020-2021_PG_II_20MCC110_DBMS_MR_52_2021-09-01_Review of Syllabus and Question Paper discussion
Next
CHAITANYA BHARATHI INSTITUTE OF TECHNOLOGY (A)
Side panel
Log in
Username
Password
Remember username
Forgot Password?
Log in
Database Management Systems - MCA II SEMESTER- 2020-2021
Home
Skip to main content
Course info
Home
Courses
MCA
AY 2020 - 2021
MCA II Semester 2020-2021
Database Management Systems - MCA II SEMESTER- 2020-2021
Summary
Database Management Systems - MCA II SEMESTER- 2020-2021
Database Management Systems - MCA II SEMESTER- 2020-2021
Teacher:
Mr. M. Ramchander Assistant Professor
Skill Level
:
Beginner