Section outline


    • Course Rationale

      Database Management Systems (DBMS) are vital components of modern information systems.  Database applications are pervasive and range in size from small in-memory databases to terra bytes or even larger in various applications domains.  The course focuses on the fundamentals of knowledge-base and relational database management systems, and the current developments in database theory and their practice.

    • Students must
      Mark as done

      Course Objective:

      Upon successful completion of this course, students should be able to:

      • Describe the fundamental elements of relational database management systems.
      • Explain  the  basic  concepts  of  relational  data  model,  entity-relationship  model,  relational  database design, relational algebra and SQL.
      • Design ER-models to represent simple database application scenarios
      • Convert  the  ER-model  to  relational  tables,  populate  relational  database  and  formulate  SQL  queries on data.
      •  Improve the database design by normalization.
      •  Familiar   with   basic   database   storage   structures   and   access   techniques.

    • Students must
      Mark as done

      Course Outcome

      CLO1
      To be able to apply analytical skills to map out the conceptual design for a real-life problems and write database documentation, including data standards, procedures and definitions for the data dictionary.

      CLO2
      To be able to draw the model of Relational Database using Entity Relationship (ER) model and explain the fundamental elements of Database management System.

      CLO3
      To be able to evaluate the logical design to translate into a specific data model and physical design to meet system storage requirements.

      CLO4
      To be able to evaluate MSSQL/MySQL/Oracle features and MSSQL /MySQL/Oracle related products for maintaining the integrity and performance of enterprise databases.


    • resource icon
      OBE Course outline File
      Students must
      Mark as done

    • Course Assessment:

      Final grade in each course will be given on the basis of performance in class attendance, in-
      course examinations, assignments, midterm test and final examination is shown in Table.


    • Students must
      Mark as done

      Text Book

      Oracle Database 10g: The Complete Reference, Author: KavinLoney



      Database System Concept, Silbertz, Korth and Sudarshan


    • Students must
      Mark as done

      Reference Book

      Oracle Database 10g: The Complete Reference, Author: KavinLoney


      Fundamentals of Relational Database Management Systems, Author: S. Sumathi and S. Esakkirajan.


    • url icon
      Students Interest Feedback URL
      Students must
      View
    • Student Counseling Hours

    • forum icon
      Announcement Forum

    • Made with Padlet


    • Course Navigation
      WK1, WK2, WK3, WK4, WK5, WK6, WK7, WK8, WK9, WK10, WK11, WK12,  Midterm Exam
      Final Exam, Class Test#1, Class Test#2, Class Test#3, Assignment-1, Assignment-2, Presentation