Section outline

  • Welcome Letter



    Dear Students, 
    Welcome to the CSE 311 Database Management System Course. I, Anika Nawar, will be your co-pilot in this online journey of learning. Let us ignite ourselves to start this journey at great speed.
    Anika Nawar
    Lecturer, Department of CSE
    Daffodil International University


    Instructor Information: Anika Nawar


    ani


    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.

    Course Objectives:

    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.

    Course Outcomes (CO’s):

    • CO1: To be able to apply analytical skills to map out the conceptual design for real-life problems and write database documentation, including data standards, procedures, and definitions for the data dictionary.
    • CO2: To be able to draw the model of Relational Database using the Entity-Relationship (ER) model and explain the fundamental elements of the Database management System.
    • CO3: To be able to evaluate the logical design to translate into a specific data model and physical design to meet system storage requirements.
    • CO4: To be able to evaluate MSSQL/MySQL/Oracle features and MSSQL /MySQL/Oracle related products for maintaining the integrity and performance of enterprise databases.