Topic outline

  • General

    WELCOME LETTER

    Dear Students

    Welcome to the Database Management Systems (CSE 313) courses, I, Md. Fahad Hossain will be your co-pilot in this online journey of learning.

    I care about your success in these courses. I'm glad you are here.

    Md.  Fahad Hossain
    Lecturer, Department of Computer Science and Engineering
    Daffodil International University

    profile_pic

    Md. Fahad Hossain

    Lecturer, Department of CSE

    Daffodil International University

    Office: Room: 316(4), AB-4

    Email: fahad.cse0365@diu.edu.bd

    Phone: +8801946704373

    Course Rationals

    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 knowledgebase and relational database management systems, and the current developments in database theory and their practice.

    Course Objectives

    O1

    Describe the fundamental elements of relational database management systems.

    O2

    Design ER-models to represent simple database application scenarios

    O3

    Explain  the  basic  concepts  of  relational  data  model,  entity-relationship  model,  relational  database design, relational algebra and SQL.

    O4

    Convert  the  ER-model  to  relational  tables,  populate  relational  database  and  formulate  SQL  queries on data.

    O5

    Improve the database design by normalization.

    O6
    Familiar   with   basic   database   storage   structures   and   access   techniques:   file   and   page   organizations, indexing methods including B tree, and hashing

    Course Outcomes

    CO1
    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.
    CO2

    To be able to draw the model of Relational Database using Entity Relationship (ER) model and explain the fundamental elements of 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 productsfor maintaining the integrity and performance of enterprise databases.

    TEXT/REFERENCE BOOKS

    01
    Database System Concept
    by Silbertz, Korth and Sudarshan, Sixth Edition
    02
    Fundamentals of Relational Database Management Systems
    by S. Sumathi and S. Esakkirajan Second Edition

    Assessment Plan

    Final Exam
    40
    Mid-term Exam
    25
    3 Class Tests
    15
    Attendance
    07
    Presentation
    08
    Total
    100

  • Week 1

    Week 1

    Introductory session 

    • Week 2

      Week 2

      • 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

    • Week 3

      Week 3

    • Week 4

      Week 4

      • Lecture 4

        Learning Outcome:

        • Introduction to ER model,  
        • What is Entity, Attribute, relationship 
        • Symbols used in ER model
        • Types of Entity, Attribute, relationship Example

      • Lecture 5(ERD Continue..)

        Learning Outcome:

        • Introduction to ER model,  
        • What is Entity, Attribute, relationship 
        • Symbols used in ER model
        • Types of Entity, Attribute, relationship Example

    • Week 5

      Week 5

    • Week 6

      Week 6

      • Lecture 8

        Learning Outcome:
        • Scenario to ER model conversion Example,  


      • Exercise On ERD model Forum
        Due: Tuesday, 6 September 2022, 11:50 AM
        View Make forum posts: 1

        Construct an ER Diagram for Company having the following details :

        • Company organized into DEPARTMENT. Each department has unique name and a particular employee who manages the department. Start date for the manager is recorded. Department may have several locations.
        • A department controls a number of PROJECT. Projects have a unique name, number, and a single location.
        • Company's EMPLOYEE name, ssno, address, salary, and birth date are recorded. An employee is assigned to one department, but may work for several projects (not necessarily controlled by her dept). Number of hours/week an employee works on each project is recorded; The immediate supervisor for the employee.
        • Employee's DEPENDENT are tracked for health insurance purposes (dependent name, birthdate, relationship to employee).

      • Lecture 9

        Learning Outcome:
        • ER model to Relational Schema conversion 


      • Quiz-2
        Opened: Thursday, 22 September 2022, 8:00 PM
        Closed: Thursday, 22 September 2022, 8:18 PM

    • Assignment 1

      ASSIGNMENT 1 

      • Assignment
        Opened: Wednesday, 21 September 2022, 12:00 AM
        Due: Thursday, 6 October 2022, 11:59 PM

    • Week 7

      Week 7

    • Assignment 2

      Presentation 

    • Week 9

      Week 9

    • Week 10

      Week 10

    • Week 11

      Week 11


    • Week 13

      FINAL EXAM

      • Topics Covered in Final exam:

        • Scenario to ERD
        • Relational Algebra
        • Normalization
        • Transaction
        • SQL
        • Stored Procedure
        • Trigger
        [N.B you have to write descriptive answers in any text editor/ doc file. Otherwise, it will not be accepted. More than 30% plagiarism will give you marks penalty.]



      • Instructions:

        1.   Follow the given Assessment Script Template.
        2.   You will find the Final Assessment Question in PDF  format in your BLC on the scheduled time.   
        3.  You can upload the PDF file  BLC or by Google Form.
        4.  Answer Script Naming conversion format: FA_CSE311_C/D/N_1234 (Midterm_Course Code_Section_Last 4/5 digits of your ID)

        • You can submit only once. So, before submission Please check whether you are submitting the correct file or not.
        • Late Submission will cause 10% mark penalty. 
        • If you submit after 4.30PM you will get 20% mark penalty.