Introduction to Database 2021-22 ECE VII LBRCE

• Academic Calendar

• Roll List

• Time Table

  Day	Time	Class room
  Thursday	3:10-4:10	ECE IV year B Section
  Friday	3:10-4:10	ECE III year C Section
  Saturday	3:10-4:10	ECE III year B Section

• Syllabus

• Course Hand out / Lesson Plan

• Descriptive Questions ( Unit Wise)

• External Question Paper

• Objective Questions ( Unit Wise)

• Unit - I ( click for notes)

• Unit - II ( click for notes)

• Mid-I Question papers 

• Descriptive

• Objective

• Mid-I Marks

                             DESCRIPTIVE

                             OBJECTIVE

• Unit - III(ppt)( click for notes)

  • Notes for Relational Algebra and SQL (pdf)

    Video on Set Operations like Union, Join, Intersect and Minus - youtube

    Video on Cursors in SQL - youtube 
    

• Unit - IV

                       Functional Dependency (ppt)
                      Video Lecture on Functional Dependency(video)

                        Notes for Normalization(ppt)
                        Notes for Normalization(pdf)
                        Videos

                            1NF & 2NF

                                      3NF & BCNF 

 Unit - V 

                    Transaction System

                    Serializability of Schedules

                   Log based Recovery

                   Testing of Serializability

                   Check Point

                   ARIES Algorithm

                   Deadlock Handling

Mid-II Question Papers

                    DESCRIPTIVE

MID-II MARKS

                    DESCRIPTIVE

                    OBJECTIVE

CONSOLIDATED MID MARKS 

                     A SECTION

                     B SECTION

                     C SECTION