CHAITANYA BHARATHI INSTITUTE OF TECHNOLOGY (A)
E1- Fundamentals of DBMS(OPE-II)-VII-2021-22
0%
Previous
Course data
General
Announcements
Syllabus
Lesson Plan
Vision,Mission,POs
Textbooks
Class PPTs
Unit-I
Unit-II
Unit-III
Unit-IV
Unit-V
Sample Mid Question Paper
Sample External QP
Question Bank
Unit-1 and Unit-2 Questions
Class Recordings
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20210803-01-COs, Course Overview
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20210804-02-Vision, mission, PEOs, PSOs, POs, UNIT - I Introduction: Database System Applications, Purpose of Database Systems
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20210809-03-Purpose of Database Systems, view of data
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20210810-04-Database Languages
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20210811-05-Database System Architecture, Application Architectures
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20210816-06-Database Users and Administrators, Basic concepts, database design phases
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20210817-07-ER-Diagrams
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20210818-08-ER-Diagrams
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20210823-09-Keys
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20210824-10-Reducing to relational Schema, E-R Design Issues, Extended E-R Features, Specialization and Generalization
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20210826-11-Relational Model: Structure of Relational Databases, Database Schema, Keys. Structured Query Language: Overviews, SQL Data Types
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20210830-12-SQL DDL DML Statements
Dept-Emp tables
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20210831-13-Order by, Null condition, Membership condition, like operator
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20210906-14-Set Operations, Null Values, Aggregate functions, group by clause, having clause
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20210907-15-Sub Queries, update, switch case , delete, insert and nested query in all of them
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20210908-16-Joins, Views
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20210921-17-Integrity Constraints, Index, Unit-III Relational Database Design: Undesirable Properties in Relational Database Design
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20210922-18-Functional Dependencies, Trivial and Nontrivial Dependencies, Closure of Set of Functional Dependencies
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20211001-19-Mid paper with key Discussed
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20211004-20-Trivial and Nontrivial Dependencies, Closure of Set of Functional Dependencies, Closure of Set of Attributes
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20211004-21-Normal Forms-1NF
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20211008-22-Normal Forms-2NF,3NF
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20211011-23,24-Normal Forms-,BCNF,4NF, Comparison of BCNF and 3NF ,Irreducible Set of Functional Dependencies,(Canonical Cover)-problems
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20211018-25-AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20211018-25-UNIT - IV Indexing: Basic concepts, Dense and Sparse Indices
AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20211018-26-AY21-22-UG-SEM-7-ECE1-18CSO06-FDBMS-AS-20211018-26- Secondary Index, Tree Index Introduction
Slip Tests and Assignments
Slip Test-1
Assignment-1
Assignment-2
Slip Test-2
Course End Survey
Course End Survey
Next
CHAITANYA BHARATHI INSTITUTE OF TECHNOLOGY (A)
Side panel
Log in
Username
Password
Remember username
Forgot Password?
Log in
E1- Fundamentals of DBMS(OPE-II)-VII-2021-22
Home
Skip to main content
Course info
Home
Courses
Electronics and Communications Engineering
UG
Academic Year - 2021-22
VII Semester
E1- Fundamentals of DBMS(OPE-II)-VII-2021-22
Summary
E1- Fundamentals of DBMS(OPE-II)-VII-2021-22
Teacher:
Smt. A. Sangeetha Assistant Professor
Skill Level
:
Beginner