Section outline

  • Week 2

    • Students must
      Mark as done

      Lecture 1.1

      Learning Outcome:

      • Database Introduction,
      • Database History,
      • Flat File Database,
      • Data and Information,
      • Database Applications

      Lecture 1.2

      Learning Outcome:

      • Problems in Conventional File Processing System, 
      • Difficulty in accessing data, 
      • Integrity problems, 
      • Atomicity problems, 
      • Security problems

      Reference Book Chapter:

      • Fundamentals of Relational Database Management System, S. Sumathi and S. Esakkirajan   Chapter 1
      • Database System Concept, Silbertz, Korth and Sudarshan Chapter 1
    • url icon
      Lecture 1.1: Introduction to Database Management System (Video) URL
      Students must
      Mark as done
    • url icon
      Lecture 1.2: Purpose of DBMS System (Video) URL
      Students must
      Mark as done
    • resource icon
      Lecture 1.1: Introduction to Database Management System (Slide) File
      Students must
      Mark as done
    • resource icon
      Lecture 1.2: Purpose of DBMS System (Slide) File
      Students must
      Mark as done
    • url icon
      Section O-1(EVE) Lecture 1 Meet discussion URL
      Not available unless: You belong to DBMS O-1 (EVE)

    • Lecture 2

      Learning Outcome:

      • Relational Model,  
      • Relational Model Concept, 
      • Relational Integrity Constraints, 
      • Operation in Relational Model

      Reference Book Chapter:

      • Fundamentals of Relational Database Management System, S. Sumathi and S. Esakkirajan   Chapter 1
      • Database System Concept, Silbertz, Korth and Sudarshan Chapter 1
    • url icon
      Lecture 2.1: Relational Model in DBMS (Video) URL
      Students must
      Mark as done
    • url icon
      Lecture 2.2: Database Architecture (Video) URL
      Students must
      Mark as done
    • resource icon
      Lecture 2.1: Relational Model in DBMS (Slide) File
      Students must
      Mark as done
    • resource icon
      Lecture 2.2: Database Architecture (Slide) File
      Students must
      Mark as done
    • url icon
      Section O-1(EVE) Lecture 2 Meet discussion URL
      Not available unless: You belong to DBMS O-1 (EVE)
    • url icon
      Section O-2 Lecture 2 Meet discussion URL
      Not available unless: You belong to DBMS Section O-2
    • forum icon
      Forum Discussion about pros and cons of Conventional File Processing System
      Students must
      View
      Make forum posts: 1

      Forum Discussion Question:

      Discuss a real-life scenario where you have to work with a Conventional File Processing System. Now write the advantage and disadvantages on the basis of your experience.